Edit excel file in backend and load on spreadsheet component.

4 posts, 0 answers
  1. Rei
    Rei avatar
    2 posts
    Member since:
    Oct 2018

    Posted 01 Jun 2020 Link to this post

    Hello,

     

    I have a controller action where I can read an excel file, convert it to base64 send it to the front end, and decode it using a javascript function I found here on this forum.

    However the problem arises when I make edits to the loaded excel through a library such as OpenXML/ClosedXML, etc... Sometimes the array size of the excel changes, sometimes it is the same but, no matter what the spreadsheet component CAN NOT read a file saved by either packages. They work fine when saved through normal excel.

     

    Is there any way I can fix this? Maybe some other excel library I'm missing? The edits I need to do are fairly trivial. I'll just replace cell values, nothing more.

     

    Thanks!

     

    Ps: Project is in .NET Core 3.1

  2. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1236 posts

    Posted 03 Jun 2020 Link to this post

    Hi Rei,

    We have not tested how files created by the OpenXML/ClosedXML libraries are loaded in the Spreadsheet widget. Nevertheless, if the file format is the correct one, the created files should be properly loaded in the widget. Could you, please, prepare and send us a small isolated .Net Core sample demonstrating how you load the file in the Spreadsheet and a sample file revealing the issue observed? This way we will be able to troubleshoot the issue locally and to provide you with the most appropriate assistance on the above.

    As per alternative approaches to manipulate XLSX files on the server, I would recommend you our SpreadProcessing library. Here is where you could find further information on the above:

    https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/overview

    Regards,
    Veselin Tsvetanov
    Progress Telerik

    Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
    Our thoughts here at Progress are with those affected by the outbreak.
  3. Rei
    Rei avatar
    2 posts
    Member since:
    Oct 2018

    Posted 03 Jun 2020 in reply to Veselin Tsvetanov Link to this post

    Hi Veselin,

    I thought that library is not available on .NET Core. I'll give that one a shot. I'll provide feedback or submit a sample .NET core app if I can't get it done myself.

    Thank you!

  4. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1236 posts

    Posted 04 Jun 2020 Link to this post

    Hello Rei,

    Take your time to test the suggested and let me know if you need any assistance in using the Telerik SpreadProcessing library with the Spreadsheet widget.

    Regards,
    Veselin Tsvetanov
    Progress Telerik

    Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
    Our thoughts here at Progress are with those affected by the outbreak.
Back to Top