Reply to topic  [ 2 posts ] 
Convert excell 2003 XML Spreadsheet to XLS worksheet 
Author Message

Joined: Mon Feb 26, 2018 1:45 pm
Posts: 1
Reply with quote
Post 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.


Mon Feb 26, 2018 1:49 pm
Profile

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 199
Location: Brasov, Romania
Reply with quote
Post 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"

_________________
EasyXLS Team
.NET and Java library to read and write Excel files
Facebook X Reddit LinkedIn


Tue Feb 27, 2018 7:31 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.