Mass Import Data With a Spreadsheet

[Erik]

Hello,

I have a client that would like to make a mass import of purchase requests through a spreadsheet control in a asp.net core web application. The idea is that he can copy/paste data from a xml file, edit and then save them in a table in the database. The spreadsheet also have to be able to validate the data inputed by the user, like check for the correct format or if a user code exists in the database.

Could this be achieved using the spreadsheet control or is there a more appropriate control for this?

Thanks!

[Vinoth Kumar Sundara Moorthy]

Hi Erik, 

 

Thank you for contacting Syncfusion support. 

 

Query #1: “To make a mass import of purchase requests through a spreadsheet control” 

 

We would like to let you know that we have an option to import the excel file using “Import” method in spreadsheet. For further details regarding the import functionality in Spreadsheet, please refer the below help doc links 

 

https://help.syncfusion.com/aspnet-core/spreadsheet/open-and-save 

 

Query #2: He can copy/paste data from a xml file, edit and then save them in a table in the database 

 

We have checked your reported requirement, before we proceed further provide us the following details. 

 

1. The term you have mentioned copy/paste from xml file, whether you need to paste the value to the spreadsheet cell or any other? 

 

2. Please provide detailed description about your requirement or video demonstration of your requirement. 

 

3. If you need to save the spreadsheet data to the table in database, please refer below KB link for more details. 

 

https://www.syncfusion.com/kb/8637/how-to-load-and-save-a-sql-table-in-spreadsheet 

 

Related KB Links: 

 

https://www.syncfusion.com/kb/7675/how-to-save-and-retrieve-the-spreadsheet-data-as-json-in-database 

 

https://www.syncfusion.com/kb/7567/how-to-save-and-retrieve-the-spreadsheet-data-in-database 

 

Query #3: The spreadsheet also have to be able to validate the data inputed by the user, like check for the correct format or if a user code exists in the database. 

 

We would like to let you know that in Spreadsheet you can able to highlight the invalid data entered by the user by using highlightInvalidData() method. For more details refer the below help documentation link. 

 

https://help.syncfusion.com/aspnet-core/spreadsheet/cell-range#data-validation 

 

Could you please check the above details and get back to us with the above requested information, based on that we will check and provide you a better solution quickly? 

 

Regards, 

Vinoth Kumar S 

[Erik]

Hi Vinoth,

Thank you for the response. About query #2, the client would like to copy data (range of cells) from Excel and paste it into the spreadsheet control in the application, just like between two Excel files. Is it possible?

Att,

[Sangeetha Priya Murugan]

Hi Erik, 

 

Thank you for your update. 

 

Query #2: The client would like to copy data (range of cells) from Excel and paste it into the spreadsheet control in the application 

 

We have checked your reported requirement and we would like to let you know that based on our current implementation behavior the data copied from the Excel, paste only the values to the spreadsheet cells and it doesn’t paste applied formats in it. However, we can able to copy and paste the data with formats from one spreadsheet to another spreadsheet. For more details, please refer the below KB link. 

 

https://www.syncfusion.com/kb/9854/how-to-copy-and-paste-the-data-with-cell-formats-and-formula-from-one-spreadsheet-to-another 

 

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

 

Regards, 

Sangeetha M