multipal seet data save in data base

First read data from multiple sheets in excel file. Follow below link:

 

http://www.c-sharpcorner.com/UploadFile/a20beb/get-data-from-multiple-sheets-of-excel-in-Asp-Net-web-applic/

 

http://www.c-sharpcorner.com/UploadFile/00a8b7/dealing-with-excel-sheets295/

 

Next, save the data into database whatever datas you read from excel file. You can save it normal way or you can use SqlBulkCopy class.

 

http://www.c-sharpcorner.com/blogs/bulk-copy-in-sql-server-using-c-sharpnet1 

 

Next, you need to read from database and write to excelsheet.

 

http://www.c-sharpcorner.com/blogs/generate-excel-with-multiple-sheet-from-dataset1 

 

https://www.codementor.io/tips/2415380713/how-to-create-excel-file-with-multiple-sheets-from-dataset-using-c 

 

http://www.dotnetfunda.com/articles/show/3114/how-to-create-multiple-sheets-into-ms-excel-programmatically-in-csharp