Importing Multi worksheet Excel into SQL server

Aspose.Cells Product Family
1

Will aspose.Excel allow me to import data from multiple worksheets using ASP.NET into SQL server tables?

If so will I need to set any specific permissions on my web server other than allowing asp net security to read and wirte files to a specific directory on my meb server.

Thanks
Dave

2

Sure you can.

If you want to import data from worksheets and populate data to SQL server tables, please use the following steps:

  1. Use Excel.Open 1method to import an excel spreadsheet.
  2. Use Cells.ExportDataTable 2method to export data of the worksheet to a datatable.
  3. Populate data into SQL server tables.
3

Hi Dave,

You don’t need to set any specific permissions other than allowing Aspose.Excel.dll to run on your machine and to read/write file to a specific directory.