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
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

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.

Up arrow icon

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