This is a migrated thread and some comments may be shown as answers.
Edit excel file in backend and load on spreadsheet component.
3 Answers 28 Views
This is a migrated thread and some comments may be shown as answers.
Rei
Top achievements
Rank 1
Rei asked on 01 Jun 2020, 10:26 AM

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

3 Answers, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 03 Jun 2020, 05:37 AM

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.
0
Rei
Top achievements
Rank 1
answered on 03 Jun 2020, 01:49 PM

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!

0
Veselin Tsvetanov
Telerik team
answered on 04 Jun 2020, 11:23 AM

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.
Asked by
Rei
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Rei
Top achievements
Rank 1
Share this question
or