File Not Opening. Giving 500 error

[Vivek Singhal]

Hey Syncfusion Team,

I'm using Angular Spreadsheet and following file is giving 500 error on open. Can u please tell the reason for it or rectify the issue if it's syncfusion related?
file link: https://parspec-staging.s3.amazonaws.com/media/submittals/7608/Q15655TM_Lincoln_Ventures.xlsx
demo link: https://stackblitz.com/edit/angular-md1w6j?file=app.component.html

Thanks and Regards
Vivek Singhal

[Gayathri KarunaiAnandam]

Hi Vivek,

Currently, we are validating the reported issue at our end and will update further details by today April 21^st.

Regards,

Gayathri

[Gayathri KarunaiAnandam]

Hi Vivek,

We have made improvements in Spreadsheet regarding import and export in our last weekly patch release(20.1.50). Please upgrade your service project Nuget to latest to avail changes.

Please find the below link to update your nuget package,

https://www.nuget.org/api/v2/package/Syncfusion.EJ2.Spreadsheet.AspNet.Core/20.1.0.50

Please check the reported issue with latest source and Nuget package and get back to us, if you need further assistance.

Regards,

Gayathri K

[Vivek Singhal]

Hey Gayathri

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. 

I've created this angular based on new Patch release 20.1.50 and it's still not loading. You can check the console.
Demo: https://stackblitz.com/edit/angular-gebo75?file=app.component.html

Thanks and Regards,

Vivek Singhal

[Gayathri KarunaiAnandam]

Hi Vivek,

We are validating your reported issue at our end. So, we will check and update further details within April 26^th,2022 and we appreciate your patience until then.

Regards,

Gayathri K

[Gayathri KarunaiAnandam]

Hi Vivek,

We have checked your reported requirement and are pleased to inform that we only update our ej2 online services in major releases and Service Pack releases. So, we suggest you that use your local service for open/save functionality. For local service you need ASP.NET Core project as a backend for Open/Save functionality in your angular application.

Create ASP.NET Core project and generate the license based on the below KB link.

https://www.syncfusion.com/kb/8976/how-to-generate-license-key-for-essential-studio-products

And include the licensed key in your project startup file as like in the below documentation link.

https://help.syncfusion.com/common/essential-studio/licensing/license-key

For more details, please refer the below links.

https://ej2.syncfusion.com/documentation/spreadsheet/open-save/#server-dependencies

For more details regarding the Open/Save server functionality. Please refer the below links.

https://ej2.syncfusion.com/aspnetcore/documentation/spreadsheet/open-save/

Open Method:

public IActionResult Open(IFormCollection openRequest)

{

    OpenRequest open = new OpenRequest();

    open.File = openRequest.Files[0];

    return Content(Workbook.Open(open));

}

Save Method:

public void Save(SaveSettings saveSettings)

{

    Workbook.Save(saveSettings);

}

Refer the above Open/Save controller method link in openUrl and saveUrl respectively in spreadsheet as like as below.

<ejs-spreadsheet openUrl=”Your Hosted link /controller name/open action method” saveUrl=” Your Hosted link /controller name/save method”

> </ejs-spreadsheet>

For example link would be: "http://localhost:49371/Spreadsheet/Save"

When import your excel file we are facing browser hang issue on our end and we have confirmed this as an issue from our side. So, we have logged a bug report for this and the fix will be available in our weekly patch release which is scheduled for May 18th,2022. You can track its status from the below feedback link.

https://www.syncfusion.com/feedback/34472/it-takes-too-long-to-import-an-excel-file-into-a-spreadsheet

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.”

Regards,

Gayathri K

[Pratyush Havelia]

Hello Gayathri,

We are currently using Python as backend for our project. However, according to the solution mentioned by you, you are recommending to use ASP.NET as backend for open/save functionality. Our team has some questions:

1) Can't we use python as a backend or is there any workaround involving python (Some libraries, etc). 

2)  Is ASP.NET mandatory?

3) If we use ASP.NET as backend, then will any additional licensing be required? 

Thanks and Regards,

Lovish Kumar

[Gayathri KarunaiAnandam]

Hi Lovish kumar,

Query:  Can't we use python as a backend or is there any workaround involving python (Some libraries, etc). 

We have checked your query and we need to inform that we have done the Open/ Save (server side) functionality in ASP.NET only. We are using the syncfusion XLSIO library for open/save action in spreadsheet. We don’t have open/save support for spreadsheet in python. So, we suggest you to use the local ASP.NET web service for open/save action to achieve your requirement in your end.

And we have published our API services in the GitHub location, for more details please refer the below links. 

Service sample Location: https://github.com/SyncfusionExamples/EJ2-Spreadsheet-WebServices/ 

https://ej2.syncfusion.com/angular/documentation/spreadsheet/open-save/

Query: Is ASP.NET mandatory?

Yes, you need to create a service in ASP.NET to use Spreadsheet Save/Open functionality.

Query: any additional licensing be required? 

Yes, it is required. As stated before, you have to create ASP.NET Core project and generate the license based on the below KB link.

https://www.syncfusion.com/kb/8976/how-to-generate-license-key-for-essential-studio-products

And include the licensed key in your project startup file as like in the below documentation link.

https://help.syncfusion.com/common/essential-studio/licensing/license-key

Please get back to us, if you need further assistance.

Regards,

Gayathri K

[Gayathri KarunaiAnandam]

Hi Lovish Kumar and Vivek,

We are glad to announce that our weekly patch release (20.1.56) is rolled out. And we have fixed your reported issue in this release. So, kindly upgrade your package versions to the latest to avail these changes (20.1.56). 

Package:  https://www.npmjs.com/package/@syncfusion/ej2-angular-spreadsheet/v/20.1.56

Release Notes: https://ej2.syncfusion.com/angular/documentation/release-notes/20.1.56/?type=all#spreadsheet

Feedback: https://www.syncfusion.com/feedback/34472/it-takes-too-long-to-import-an-excel-file-into-a-spreadsheet

Please let us know if you need further assistance on this. 

Regards,

Gayathri K