Spreadsheet file not opening/file open api returnig status 500

[Hyder Ali]

I used spreadsheet component in angular a few days ago for a sample app to test spreadsheet on web. It was working fine until I checked today. File from url wasnt loading and when I saw console, there printed that url I passed in [openUrl] prop is throwing 500. Is it related to licensing? or what could be the issue?

[Sangeetha Priya Murugan]

Hi Hyder Ali, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported issue and the file loaded properly in our Angular Spreadsheet by using our EJ2Service. For your convenience, we have prepared the sample that load the excel file in spreadsheet created event as like in the below code example. 

 

created () { 

    fetch( 

      https://js.syncfusion.com/demos/ejservices/data/Spreadsheet/LargeData.xlsx // provide your server path for excel file 

    ).then(response => { 

      response.blob().then(fileBlob => { 

        var file = new File([fileBlob], "Sample.xlsx"); 

        this.spreadsheetObj.open({ file: file }); // To open the excel file 

      }); 

    }); 

  } 

 

Sample Link: https://stackblitz.com/edit/angular-yzmmhu?file=app.component.ts 

 

Could you please check the above sample and kindly share the imported excel file that you have loaded in spreadsheet and more details regarding this. Based on that we will check and provide you a better solution quickly. 

 

Regards, 

Sangeetha M 

[Hyder Ali]

Hello Sangeeta,

Thank you so much for addressing. It resolved my issue

[Sangeetha Priya Murugan]

Hi Hyder Ali, 

 

Thank you for your update. Please feel free to contact us, if you need any further assistance on this. 

 

Regards, 

Sangeetha M 

[Hyder Ali]

Hey Sangeetha,

I have this large file so I keep scrolling till I reach row 843 and it start showing loading and in the console there is a crash "ERROR Error: Uncaught (in promise): TypeError: Cannot read property 'style' of undefined

TypeError: Cannot read property 'style' of undefined

    at setRowEleHeight (util.js:897)"

[Sangeetha Priya Murugan]

Hi Hyder Ali, 

 

Thank you for your update. 

 

We have checked your reported issue with our previously updated sample and it is properly worked in our end. Meanwhile, we have prepared the video demonstration of this. If you have facing issue with another imported excel file, please share that file to us.  

 

Video Link: https://www.syncfusion.com/downloads/support/forum/159647/ze/script-error-issue1295360338 

 

Could you please check the above link and get back to us with more details like issue replicable excel file and spreadsheet customization codes. Based on that we will check and provide you a better solution quickly. 

 

Regards, 

Sangeetha M 

[Hyder Ali]

Hey,

1. Request URL:
   https://ej2services.syncfusion.com/production/web-services/api/spreadsheet/open
Above api keeps crashing. Its again returning 500 since morning. My file is a little big. I have started feeling that this module is not a good option. Or if there is any option to load excel file without calling this api. Please let me know.

[Sangeetha Priya Murugan]

Hi Hyder Ali, 

 

Thank you for your update. 

 

We have checked your reported issue with our previously updated sample that refers our online service for open/save functionality. It works properly in our end, if you are facing issue with our online service we would suggest you to use local service for open/save functionality. For your convenience, we have modified our previously update sample that refers the local service. Please find the links below. 

 

Sample Link: https://stackblitz.com/edit/angular-yzmmhu-inmalc?file=app.component.ts 

 

Service Link: https://www.syncfusion.com/downloads/support/forum/159647/ze/core-sample1002052492 

 

Note: launch the service first and then open the stackblitz sample for import and export. 

 

Could you please check the above link and get back to us, if you need any further assistance on this. 

 

Regards, 

Sangeetha M 

[gofeatureus]

Issue occur with  latest version ( formula, hyperlink)

[Sangeetha Priya Murugan]

Hi gofeatureus,

Before, we proceed further please share the below details.

1. Please share the saved JSON data of spreadsheet by using saveAsJson method in the text file format (which contains applied formula details).

2. If you are facing this issue with the imported file, please share it to us.

3.Please share the stack trace of the issue that you are facing

4. Please confirm whether you are using the latest scripts and assemblies in your application.

5. Video demonstration of this issue in your end.

6. If possible, please share the issue replicable sample or spreadsheet rendering codes.

Could you please check the above details and get back to us with the above requested information, based on that we will check and provide you a better solution quickly.

Regards,

Sangeetha M