Well, I think you may export your worksheet data to fill a datatable or array using Cells.ExportDataTable or Cells.ExportArray methods.
//You can open the excel file using Aspose.Cells.Workbook.Open() method, now export / fill a datatable based on the sheet data in the cells, finally use ADO.NET API or your own code to fill/update the SQL Server Database table(s) or other db tables for your need.//
Sample code:
Workbook wb = new Workbook(); wb.Open(“f:\test\MyExcelFile.xlsx”); Worksheet ws = wb.Worksheets[0]; int trows = ws.Cells.MaxDataRow; int tcols = ws.Cells.MaxDataColumn; DataTable dt = ws.Cells.ExportDataTable(0, 0,trows, tcols, true);
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.