Convert excell 2003 XML Spreadsheet to XLS worksheet
Page 1 of 1

Author:  bobsimoneau [ Mon Feb 26, 2018 1:49 pm ]
Post subject:  Convert excell 2003 XML Spreadsheet to XLS worksheet

Currently we create SpreadsheetML and send to our client with response.write(Spreadsheet as a string). We can no longer use XML spreadsheets. We also cannot write files to the sever. Is there a way to use workbook.easy_LoadXMLSpreadsheetFile(Spreadsheet as a string) with a string vs Hardfile, or feed response.write(Spreadsheet as a string) into a loader of some type? The code available for reading an XML Spreadsheet from a file and rewriting a XLS seems so easy.

Author:  daniela [ Tue Feb 27, 2018 7:31 am ]
Post subject:  Re: Convert excell 2003 XML Spreadsheet to XLS worksheet

You can write your SpreadsheetML string to a MemoryStream, instead of a harddrive file:

Use the the MemoryStream with workbook.easy_LoadXMLSpreadsheetFile method and then convert the workbook to XLS with workbook.easy_WriteXLSFile(Response.OutputStream).

Useful links:
Open Excel in browser using Response stream
Convert XML to Excel
section "Convert XML Spreadsheet file to Excel"

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group