Spreadsheet - convert workbook to stream

4 posts, 0 answers
  1. Mahesh
    Mahesh avatar
    3 posts
    Member since:
    Feb 2016

    Posted 30 Jan Link to this post

    Can we convert workbook to a stream and return the stream?
  2. Petya
    Admin
    Petya avatar
    990 posts

    Posted 31 Jan Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Mahesh
    Mahesh avatar
    3 posts
    Member since:
    Feb 2016

    Posted 31 Jan in reply to Petya Link to this post

    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?

     

     

  4. Petya
    Admin
    Petya avatar
    990 posts

    Posted 01 Feb Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top