Excel file internal server error on being opened

[Vivek Singhal]

Hello. I'm using syncfusion angular spreadsheet. I open S3 url files via syncfusion default openURL ( https://ej2services.syncfusion.com/production/web-services/api/spreadsheet/open ). All files are being opened successfully but When I open this file 

https://parspec-staging.s3.amazonaws.com/media/submittals/4944/testing_buggy.xlsx , I'm getting 500 (Internal server error) on openUrl api with response "Failed to load response data; No data found for resource with given identifier". I tried this file url on syncfusion official stackblitz demo but file data is not being loaded.
Stackblitz demo: https://stackblitz.com/edit/angular-mm7uxh?file=app.component.ts

[Thaneegairaj Sankar]

Hi Vivek,

Thanks for contacting Syncfusion support,

We have checked your reported issue and we can be able reproduce in our end. So, we have logged this as a bug report and this fix will be available on 5^th January 2022.We appreciate your patience until then. You can also track the status of this issue fix by using our feedback portal link.

Feedback Link: https://www.syncfusion.com/feedback/31250/opening-the-excel-file-with-defined-names-throws-an-exception

Regards,

Thaneegairaj S

[Vivek Singhal]

Hey Shankar

Thanks for the response. Please check these files as well.

Following file (with extension xlsx) is giving unsupported file error.

https://parspec-staging.s3.amazonaws.com/media/submittals/5239/testing_unsupported.xlsx

but If I save save the same file with .xls extension then it is opening fine
https://parspec-staging.s3.amazonaws.com/media/submittals/5238/testing_unsupported_2.xls

Please check this issue as well.

Thanks

Vivek Singhal

[Thaneegairaj Sankar]

Hi Vivek,

Thank you for contacting Syncfusion support.

We have checked your reported query. We would like to let you that your XLSX downloadable file is corrupted, we have opened the file in excel. For your reference, please find the error image,

We have opened and re-saved the same file then it’s working fine. Please find the below re-saved file(XLSX) link,

Saved file: https://www.syncfusion.com/downloads/support/directtrac/general/ze/testing_unsupported111527441896

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

Regards,

Thaneegairaj S

[Vivek Singhal]

Hey Sankar,

I just checked the syncfusion angular spreadsheet version 19.4.41 via stackblitz official demo and the issue is still not resolved. It is still throwing internal server error on opening the specific file.

Stackblitz demo with new version: https://stackblitz.com/edit/angular-gvmmh9?file=app.component.ts

Please check the console. I'm printing the error.

Thanks.

Regards,

Vivek Singhal

[Thaneegairaj Sankar]

Hi Vivek,

We are sorry for the delay. 

Spreadsheet dependent team resolved your issue. While implementing this fix in spreadsheet package, we are facing version mismatch error. We are working this issue with high priority and we have planned to include this fix in our 12th January 2022 patch release. We appreciate your patience until then. You can also track the status through the below feedback portal link.

Feedback: https://www.syncfusion.com/feedback/31680/exception-is-thrown-when-sheet-name-contains-excel-extension

Regards,

Thaneegairaj S

[Thaneegairaj Sankar]

Hi Vivek,

Thank you for your patience.

We are glad to announce that our weekly patch release (19.4.42) is rolled out. We have included the fix for your issue in this release. So, we suggest you upgrade our Syncfusion Spreadsheet NuGet packages (assemblies) to overcome this issue in your end.

https://www.nuget.org/packages/Syncfusion.EJ2.Spreadsheet.AspNet.Core/

https://www.nuget.org/packages/Syncfusion.EJ2.Spreadsheet.AspNet.MVC5/

Feedback Link: https://www.syncfusion.com/feedback/31680/exception-is-thrown-when-sheet-name-contains-excel-extension

Please let us know, if you need further assistance.

Regards,
Thaneegairaj S

[Vivek Singhal]

Hey Sankar

Issue is still not resolved in 19.4.42 patch.

Stackblitz Demo: https://stackblitz.com/edit/angular-d4tqup?file=package.json

Regards

Vivek Singhal

[Vivek Singhal]

Hey Sankar,

We're not using any NuGet packages. We're using only Angular Spreadsheet component. Please provide the support on that one. My Org has bought the license as well and we need it on production level fix.

Thanks and Regards,

Vivek Singhal

[Thaneegairaj Sankar]

Hi Vivek,

Sorry for the inconvenience.

We have refreshed the web-service link with latest packages. Please use the below link for open functionality to resolve the issue in your end.

OpenUrl: https://ej2services.azurewebsites.net/production/web-services/api/spreadsheet/open

For your reference we have prepared a sample, please find the below link.

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

Could you please check the above details and get back to us whether it fulfill your requirement or need further assistance on this.

Regards,

Thaneegairaj S

[Vivek Singhal]

Hey Sankar

Bug got resolved. Thanks for the support.

Regards,

Vivek Singhal

[Thaneegairaj Sankar]

Hi Vivek,  

 

Thanks for the update. 

 

We are happy to hear that your issue has been resolved. Please feel free to contact us if you need any further assistance on this. 

 

Regards, 

Thaneegairaj S