Open existing excel, read and display each rows.

[gms-fitri]

Hello,

I able to create, open and modified excel files via XlsIO using few lines of code but I need to read and display the excel rows on screen.

How can I able to achieve that ?

[Sangeetha Priya Murugan]

Hi gms-fitri 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported requirement and it can be achievable in our spreadsheet. We have provided option in File Menu to open/save the excel 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/aspnetcore/Spreadsheet/DefaultFunctionalities#/material  

 

Documentation Link: https://ej2.syncfusion.com/aspnetcore/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/javascript/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 

[gms-fitri]

Can I do that using Collection Objects in ASP.NET Core XlsIO Control instead ?

And if yes, is there any sample to refer to ?

[Thaneegairaj Sankar]

Hi gms-fitri,

We have validated your reported query. We would like to let you know that XLSIO control allows you to create, modify and open the excel file, for your viewing purpose you can use EJ2 Spreadsheet control. Here you can be able to open/save the excel file.

For more details, please refer the below links. 

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

And also You can use “openFromJson” and “saveAsJson” client side methods to save/open the excel file in server

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
 

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

Regards,

Thaneegairaj S