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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Mass Import Data With a Spreadsheet

Thread ID:

Created:

Updated:

Platform:

Replies:

144067 Apr 16,2019 07:58 PM UTC Apr 18,2019 03:46 PM UTC ASP.NET Core 3
loading
Tags: Spreadsheet
Erik
Asked On April 16, 2019 07:58 PM UTC

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 [Syncfusion]
Replied On April 17, 2019 12:43 PM UTC

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 


Erik
Replied On April 17, 2019 06:41 PM UTC

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 [Syncfusion]
Replied On April 18, 2019 03:46 PM UTC

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 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon