Last post Jul 20, 2011 11:02 PM by Hussein
Jul 19, 2011 08:43 AM|Hussein|LINK
I've written an extension method to IEnumerable<T> that takes a deferred executable IEnumerable and streams its result row by row as CSV (in a differred executed manner)
However, when I started using Microsoft
OpenXML SDK to generate XLSX instead of CSV, I lost this immediate streaming advantage (i.e. having the file start streaming before all the results are returned).
Reason for that is the nature of the XLSX file itself. It's a container zip file of several xml files (styles, shared data, sheets, etc..). Hence, all the content within the XLSX container needs to be ready before being packaged and zipped inside the XLSX
file, which prevents me from immediately starting streaming the xlsx file while it's being generated.
Does anyone know of what Microsoft recommends for such cases? Or is deferred streaming of xlsx is at all possible?
Also, am I writing this in the right forum?
Many thanks in advance
Jul 20, 2011 10:15 PM|decker dong - msft|LINK
Microsoft OXML library
Sorry but I googled for it and nothing returns to me about OXML library, Do you mean
http://msdn.microsoft.com/en-us/library/ms763742(v=vs.85).aspx or something like this? Would you mind showing us your link if I take you wrongly?
Jul 20, 2011 11:02 PM|Hussein|LINK
hi, many thanks for the reply. OXML = OpenXML (http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=5124)
It's Microsoft's SDK for OpenXML documents (e.g. docx, xlsx, etc..)