Workbook with Excel XML template

Sep 7, 2009 at 8:26 PM

Hello

How can i load xml excel template file into HSSWorkbook ?

Coordinator
Sep 7, 2009 at 8:33 PM

What kind of xml excel template? Can you show me an example?

Sep 7, 2009 at 8:49 PM

This format named as XML Spreadsheet 2003 (*.xml) in Excel 2007 Save As dialog

Coordinator
Sep 8, 2009 at 2:31 AM

I'm afraid this is not supported. I suggest you convert the xml template into xls and then use the xls as a template for HSSFWorksheet.

Sep 8, 2009 at 8:12 AM
Edited Sep 8, 2009 at 8:17 AM

I prepare excel file in xml and want to convert it to xls

 

 

Coordinator
Sep 8, 2009 at 11:30 AM

I understand what you want. It is suggested that you use .NET XML/XPath classes to read necessary data from the xml. Then use NPOI to generate the similar xls file. This seems to be the only solution I can figure out.

Sep 8, 2009 at 12:15 PM

Yes, you're right.

But i can't find component for this conversion (except Excel interop).