Xlbook vs Spread.net

Xlbook vs Spread.net

Posted by: Hans on 20 February 2018, 1:47 pm EST

• 

  Hans

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 February 2018, 1:47 pm EST

  I am a VB.Net Winforms developer and I need to create an application that generates Excel spreadsheets. I would like some advise regarding the best product to use: XLBook or Spread. Net.

  A major component is the ability to read an existing spreadsheet and each cell style and to create a new spreadsheet with similar cell styles. If there is a capability to copy styles from one spreadsheet(excel) to another(XlBook or Spread.NET) , that would be ideal.

  It must support all of the current Excel style features such as shrinktofit, colorindex, patterns etc.

  Please advise on the best fit for my requirements.

  Thank You

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 21 February 2018, 9:32 am EST

  Hi,

  Thank you for showing interest in GrapeCity’s products.
  
  Though, both C1Excel and Spread are related to excel and helps in loading, creating excel etc, they are very different in themselves.
  
  Starting with C1Excel: Its a .net control and is not a UI component. We can save, load, read/write, format the data etc but all that has to be done in code-behind. Using C1Excel you will need a different control like Grid, etc to show your data and then using C1Excel you can export the data, format it etc.
  
  However, Spread is an excel-compatible spreadsheet component that allows the end-user to manipulate , format the data, perform import/export functions etc just like MS-Excel.
  
  For more information about Spread, please refer the following URL:
  
  https://www.grapecity.com/en/spreadnet

  Also, following is an URL for one of our C1Excel product samples, that meets your requirement of reading a spreadsheet along with its styles, create new spreadsheet:
  
  https://www.grapecity.com/en/samples/combinesheets

  Regards,
  
  Ruchir Agarwal

• 

  Hans

  • Post Options:
  • Link
    Copy

  Posted 21 February 2018, 11:51 am EST

  Thank You

• 

  Hans

  • Post Options:
  • Link
    Copy

  Posted 21 February 2018, 2:59 pm EST

  Ruchir,

  based on your description I’ve decided to develop my application using XLBook, however there seem to be a number of features either missing or not documented. Could you please advise if these features are available.

  Freeze - the ability to set freeze certain number of rows and/or columns
  
  Text Subscript and Superscript
  
  Setting Number Format
  
  Cell Background patterns

  If any of the above features are available, would you please point me to the documentation or a sample of their use.

  Thanks again

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 23 February 2018, 12:31 am EST

  Hello,

  I have attached a demo application implementing the features you need.
  
  Also, following are the documentation links for them, which you may like to refer:
  
  Freeze Columns/Rows: http://helpcentral.componentone.com/nethelp/c1excel/C1.C1Excel.4~C1.C1Excel.XLColumnCollection~Frozen.html, http://helpcentral.componentone.com/nethelp/c1excel/C1.C1Excel.4~C1.C1Excel.XLRowCollection~Frozen.html
  
  Number Format: http://helpcentral.componentone.com/nethelp/c1excel/C1.C1Excel.4~C1.C1Excel.XLStyle~Format.html
  
  Cell Background Pattern:http: http://helpcentral.componentone.com/nethelp/c1excel/C1.C1Excel.4~C1.C1Excel.XLStyle~BackPattern.html
  
  SubScript/SuperScript:
  
  http://helpcentral.componentone.com/nethelp/c1excel/C1.C1Excel.4~C1.C1Excel.XLFontScript.html

  Also, at location: …\Documents\ComponentOne Samples\WinForms\C1Excel, you can find samples for C1Excel, you can refer to these samples for gaining more knowledge and/or contact us for any further assistance.

  Thanks & Regards,
  
  Ruchir Agarwal
  
  C1Excel_Demo.zip

• 

  Hans

  • Post Options:
  • Link
    Copy

  Posted 26 February 2018, 4:32 pm EST

  Thank you very much. Your information allowed me to implement my application.