Spreadsheet - convert workbook to stream

[Mahesh]

Can we convert workbook to a stream and return the stream?

[Petya]

Hello Mahesh,

Could you please elaborate which product you are using exactly? We provide Spreadsheet controls/widgets as part of several of our suites, both for web and desktop development. In order to provide you with the most appropriate information that will help achieve your requirement, I'd appreciate some additional details about your setup.

Regards,
Petya
Progress Telerik

[Mahesh]

Hi petya,

 

Thanks for your reply.

We are using RadSpreadProcessing library for exporting data to Excel.

In the below link it is mentioned on how to write to workbook and export it.

Iam looking to save the workbook to a MemoryStream and return it instead of exporting the workbook; something like WorkBook.Save(stream) which should save all the workbook data to 'stream'. Do we have any option like this?

 

 

[Petya]

Hi Mahesh,

Thank you for the information, I'm moving this forum thread to the SpreadProcessing forum category. 

The process of exporting a workbook to XLSX format basically converts that object to a binary array. For convenience, the XlsxFormatProvider also has an overload of the Export() method which accepts a Stream object as a second parameter and writes the data in it - XlsxFormatProvider API Reference You can take a look at the example with a FileStream in this help article and adapt it to your exact needs.

I hope this helps.

Regards,
Petya
Progress Telerik