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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to create a sample to sync Excel file with database using XlsIO?

Platform: ASP.NET Web Forms (Classic) |
Control: XlsIO |
Published Date: March 3, 2015 |
Last Revised Date: March 3, 2015

An Excel file can be generated based on a selected value from database using XlsIO. The following steps illustrates to sync an Excel file with database.

Step 1: Create a database and load values of a specific field from the database to a dropdown on the web form.

Step 2: Select an ID from the provided drop down to download an excel file.

Step 3: Make some changes on the downloaded file. Then upload it using upload button.

Step 4: Now the changes are made in the database. It can be viewed in a grid after clicking the Upload Excel button.

Here is the code snippet to pull values from the database.




Figure 1: UI of the sample

You can also refer to the sample here.



You must log in to leave a comment

Please sign in to access our KB

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