Workbook with Excel XML template

Sep 7, 2009 at 7:26 PM


How can i load xml excel template file into HSSWorkbook ?

Sep 7, 2009 at 7:33 PM

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

Sep 7, 2009 at 7:49 PM

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

Sep 8, 2009 at 1: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 7:12 AM
Edited Sep 8, 2009 at 7:17 AM

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



Sep 8, 2009 at 10: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 11:15 AM

Yes, you're right.

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