| EasyXLS http://forum.easyxls.com/ |
|
| Convert excell 2003 XML Spreadsheet to XLS worksheet http://forum.easyxls.com/viewtopic.php?f=11&t=2241 |
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 and 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 http://www.phpbb.com/ |
|