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?

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.

C#

VB

 

Figure 1: UI of the sample


You can also refer to the sample here.

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
4205 03/03/2015 03/03/2015 ASP.NET Web Forms (Classic) XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Please sign in to access our KB

or the page will be automatically redirected to 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