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, both ASP.NET web sites and Windows Forms application.

Tue Dec 06, 2011 12:44 am

I have a macro-based Excel file (Excel 2010).
I'm evaluating the components, and wondering is I can do the following...

On a server (running .NET 3.5) I want to...

1. Open it (test.xlsm)
2. Modify one value
3. Update the values (run the macros)
4. Save it (test2.xlsm)
5. Create a PDF ((test2.pdf)

Can I do this?

A. I can create a sample.xml (as in the HelloWorld tutorial)
Good (Simple)

B. I can create a PDF from sample.xls (as using the tutorial)
Good

C. If I try to do this is a marco excel workbook (ie sample.xlsm), I get "Value cannot be null."
I guess this is because you cannot open Macro-Enable Excel Workbooks?
Bad - Help?

D. I cannot open the sample.xml and save it (sample2.xml) -
I get "Name of worksheet must be unique in a workbook."
I guess because I am using the evaluation version? How can I test this?
Bad - Help?

Any ideas suggestions or comments would be appreciated.

Thank you.

bleckett
 
Posts: 2
Joined: Mon Dec 05, 2011 10:53 pm

Tue Dec 06, 2011 2:55 am

Hello bleckett,

Thank you for your inquiry.

1.pire.XLS can't support open Macro-Enable Excel Workbooks.

2.You can use Spire.Doc to open Sample.xml and save it as Sample2.xml. At this stage Spire.XLS just support convert xml to xls. You can get more informations from the following web page:http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html.

3. if you got this error "Name of worksheet must be unique in a workbook.", you need to check whether the workbook has been insert a worksheet which name is "evaluation warning".

Sorry for the inconvenience caused by us again.
If you still have any other doubts, please feel free to contact us.

Have a nice day.
Tina
Technical Support/Developer,
e-iceblue Support Team
User avatar

Tina.Lin
 
Posts: 152
Joined: Tue Sep 13, 2011 5:37 am

Thu Dec 08, 2011 12:02 pm

Thank you for the information.
One other question...

Does Spire support (or will it eventually support) xlsx files.
I have a workbook that updates information on multiple pages (worksheets) and this cannot be down-converted to the older xls format.

bleckett
 
Posts: 2
Joined: Mon Dec 05, 2011 10:53 pm

Fri Dec 09, 2011 3:14 am

Hello bleckett,

Thank you for your inquiry.

Spire.XLS support xlsx file.

You mean you want to load a xlsx file and update the data of multiple worksheets. and then save the xlsx file as xls file ??
Spire.XLS support load and save same version file. If you want to save xlsx as xls, it will throw error.

If you still have any other questions, please don't hesitate to contact us.
Have a nice day.
Tina
Technical Support/Developer,
e-iceblue Support Team
User avatar

Tina.Lin
 
Posts: 152
Joined: Tue Sep 13, 2011 5:37 am

Return to Spire.XLS