XLSM Files

[bleckett]

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.

[Tina.Lin]

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.

[bleckett]

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.

[Tina.Lin]

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.

[58861@supinfo.com]

Hi,
no evolution since ?
I saw that spire.xls can open xlsm files now... can it refresh data by executing macros ?
thank you,

[rachel.lei]

Hi Benjamin,

Thanks for your inquiry.
At present our Spire.XLS only support loading/saving Excel document with macros and detecting macros. Sorry to tell that executing macros to refresh data is not supported yet. We will let you know if it can be achieved in the future.
If there is any other question, please feel free to let us know.

Sincerely,
Rachel
E-iceblue support team