Open .csv files with Spreadsheet component

Hello,

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

Thanks,
Omar

3 Replies 1 reply marked as answer

SP Sangeetha Priya Murugan Syncfusion Team June 11, 2021 07:23 AM UTC

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. 
 
 
 
 
For save action please refer the below link: 
 
 
To save/open the excel file in server, please refer the below link. 
 
 
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. 
 
 
 
Could you please check the above link and get back to us, if you need any further assistance on this. 
 
Regards, 
Sangeetha M 



OM Omar June 19, 2021 03:46 PM UTC

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,



AS Aravinthan Seetharaman Syncfusion Team June 21, 2021 12:43 PM UTC

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. 
 
 
For your convenience we have prepared a sample please check the below sample link 
 
 
public openUrl = 'http://localhost:55367/Home/Open'; 
public saveUrl = 'http://localhost:55367/Home/Save'; 
 
 
 
Could you please check the above sample and get back to us if you need further assistance on this? 
 
Regards, 
Aravinthan S 


Marked as answer
Loader.
Up arrow icon