Open .csv files with Spreadsheet component

[Omar]

Hello,

How can I open .csv files using the Spreadsheet component ?

Thanks,
Omar

[Sangeetha Priya Murugan]

Hi Omar, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported query and we would like to let you know that we have fixed some issues in our previous patch release regarding CSV file import in spreadsheet. So, we would suggest you to use the latest version (19.1.67) for both scripts and assemblies to resolve achieve this in your end.  

 

We have provided option in File Menu to open the excel/CSV file in spreadsheet through UI level. And open method also available to open the file in spreadsheet programmatically. For more details, please refer the below links. 

 

Demo Link: https://ej2.syncfusion.com/vue/demos/#/material/spreadsheet/default.html  

 

Documentation Link: https://ej2.syncfusion.com/vue/documentation/spreadsheet/open-save/  

 

API Link: https://ej2.syncfusion.com/javascript/documentation/api/spreadsheet/#open  

 

For save action please refer the below link: 

 

https://ej2.syncfusion.com/angular/documentation/api/spreadsheet/#save  

 

To save/open the excel file in server, please refer the below link. 

 

https://www.syncfusion.com/kb/11970/how-to-open-and-save-an-excel-file-to-server-in-the-spreadsheet  

 

We have done the Open/ Save (server side) functionality in ASP.NET. 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/aspnetcore/documentation/spreadsheet/open-save/ 

 

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

 

Regards, 

Sangeetha M 

[Omar]

Hi Sangeetha,

I just tried to open a .csv file on the demo here:
https://ej2.syncfusion.com/vue/demos/?_ga=2.191813549.669649612.1624096807-259303177.1608820189&_gac=1.87698026.1622221333.CjwKCAjwqcKFBhAhEiwAfEr7zXOBzjMdHGf8F2LcoWNYkPN3MqvKilitVihdXxr_DjVjs_KgZKw41hoCKg0QAvD_BwE#/material/spreadsheet/default.html

But for some .csv files it displays the following:

For other .csv files it keeps loading forever till the request fails.

Thanks,

[Aravinthan Seetharaman]

Hi Omar, 

 

We have checked your reported issue and we would like to let you know that it is a known issue and we have already fixed and included in our latest version (19.1.0.69). So, we would suggest you update the latest Nuget packages and use the updated script file to resolve this issue in your end. Please find the links below. 

 

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

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

 

For your convenience we have prepared a sample please check the below sample link 

 

Client side sample link: https://stackblitz.com/edit/angular-kltmda?file=app.component.ts 

 

public openUrl = 'http://localhost:55367/Home/Open'; 

public saveUrl = 'http://localhost:55367/Home/Save'; 

 

 

Server side sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/CORE(2~1418556799 

 

Could you please check the above sample and get back to us if you need further assistance on this? 

 

Regards, 

Aravinthan S