We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Mass Import Data With a Spreadsheet

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!

3 Replies

VK Vinoth Kumar Sundara Moorthy Syncfusion Team April 17, 2019 04:43 AM

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 
 
 
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. 
 
 
Related KB Links: 
 
 
 
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. 
 
 
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 



ER Erik April 17, 2019 10:41 AM

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,


SP Sangeetha Priya Murugan Syncfusion Team April 18, 2019 07:46 AM

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. 
 
 
Could you please check the above link and get back to us, if you need any further assistance on this. 
 
Regards, 
Sangeetha M 


Loader.
Live Chat Icon For mobile
Up arrow icon