B
Bikelane
I am needing to convert an Excel spreadsheet that my code receives as an
SMTP/MIME attachment (and so is base64-encoded) to an XML spreadsheet (a la
Microsoft.Office.Interop.Excel.xlXMLSpreadsheet) prior to handing it off to a
web service. I've been poking around with the Interop stuff, but without
much success. Can't figure out how to load a workbook directly from the
binary spreadsheet data that results from decoding the base64 attachment
(without first saving to a file). And, then there's the conversion to XML
spreadsheet, which I would prefer to do in-memory (or, as a stream) rather
than having to write anything to the file system. In fact, it would be ideal
if I could somehow simply stream the base64 (ASCII) data directly through a
converter to Excel binary, and then through a converter to Excel XML
spreadsheet, and right out to the web service.
Anyway, I'm still fairly new to all this MS Windows .NET Visual C# stuff
(old Unix programmer here), so please be gentle. ;-)
Thanks in advance!
-Lane Wimberley
Austin, TX
SMTP/MIME attachment (and so is base64-encoded) to an XML spreadsheet (a la
Microsoft.Office.Interop.Excel.xlXMLSpreadsheet) prior to handing it off to a
web service. I've been poking around with the Interop stuff, but without
much success. Can't figure out how to load a workbook directly from the
binary spreadsheet data that results from decoding the base64 attachment
(without first saving to a file). And, then there's the conversion to XML
spreadsheet, which I would prefer to do in-memory (or, as a stream) rather
than having to write anything to the file system. In fact, it would be ideal
if I could somehow simply stream the base64 (ASCII) data directly through a
converter to Excel binary, and then through a converter to Excel XML
spreadsheet, and right out to the web service.
Anyway, I'm still fairly new to all this MS Windows .NET Visual C# stuff
(old Unix programmer here), so please be gentle. ;-)
Thanks in advance!
-Lane Wimberley
Austin, TX