Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Fri Oct 08, 2010 2:22 am

Could you please tell me - or point me to some information - about the limitations the demo version has?

So far (I'm evaluating this component as part of a pilot project) I've found the following issues/limitations:
- Columns are limited to 256
- I cannot save a worksheet in Excel 2007 or 2010 format
- The spreadsheet gets protected when saved
- and the more obvious "new" worksheet saying this is trial version of Spire.XLS

Are there any more limitations that I should be aware of? How do I know if these limitations or issues are not an issue in the paid/full version?

Thanks again!
Roshan

adaptive
 
Posts: 3
Joined: Fri Oct 08, 2010 12:57 am
Location: Melbourne, Australia

Fri Oct 08, 2010 2:38 pm

Hello,

Thank you for your inquiry.
- Columns are limited to 256
You need set excel version to excel 2007, so columns are not limited to 256.
Workbook workbook = new Workbook();
workbook.Version = ExcelVersion.Version2007;

//Initailize worksheet
workbook.CreateEmptySheets(1);
Worksheet sheet = workbook.Worksheets[0];
sheet.GridLinesVisible = false;
sheet.Range[2, 266].Text = "test";

- I cannot save a worksheet in Excel 2007 or 2010 format
Please use following to save excel 2007 or 2010 format.
workbook.SaveToFile("Sample.xlsx",ExcelVersion.Version2007);

- The spreadsheet gets protected when saved
Here is a link for your reference.
http://www.e-iceblue.com/Knowledgebase/ ... ction.html

- and the more obvious "new" worksheet saying this is trial version of Spire.XLS
If you use trail version of Spire.XLS, a evaluation warning sheet will be added in your workbook.

Best Regards
User avatar

Flash
 
Posts: 56
Joined: Thu Jun 29, 2006 2:34 pm

Return to Spire.XLS