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 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
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|
|4205||03/03/2015||03/03/2015||ASP.NET Web Forms (Classic)||XlsIO|