Forum Discussion

arbitram's avatar
arbitram
Copper Contributor
Feb 23, 2021

Excel API data in JSON format from Excel

Dear All,

 

We are currently working with Microsoft.Graph for manipulation and computation to read excel file from OneDrive and convert it into object which could be easily used in .Net platform.

 

While we are able to get entire table rows from excel file into CSV format. However, we are dealing with huge dataset and therefore converting each CSV row into C# table format is resource intensive and time consuming which is impacting our productivity.

 

I am therefore reaching out to you to request your help in identifying an alternative solution which is similar to Spire.xls/gembox that provides us with a table object which could be directly used for front end which also provide output in 4-5 seconds

 

We are looking for ways in which we can get it in the JSON format which can be consumed in the front end which is Angular 7 in a quick and efficient way. 

 

There is likely to be fast interactions between the Angular 7 front end and the connected Excel file wherein the connected file would have the computations while the Angular front end would act as the Input data collector. 

 

Any help would be great. it is quite urgent.

 

Regards

    • arbitram's avatar
      arbitram
      Copper Contributor
      May 07, 2022

      Kenneth2000 

      No it never got sorted 

      so we have done other things and we use Spire plus some coding to optimise.

      We couldnt use Excel API directly. 

      We are still wasting time in opening Excel in the backend instead of only computation

      We tried Excel Embed but that is very buggy and with limited control.   

      if you have any bright ideas please let me know 🙂

      thanks for the message.

      ramesh

Resources