1
https://www.aspsnippets.com/Articles/Export-data-from-SQL-Server-to-Excel-in-ASPNet-using-C-and-VBNet.aspx
https://www.aspsnippets.com/Articles/Using-SqlBulkCopy-to-import-Excel-SpreadSheet-data-into-SQL-Server-in-ASPNet-using-C-and-VBNet.aspx
Follow these links, you will get an idea. thanks in advance
0
I already have excel sheet. I need to map column from SQL Database and insert the data in excel. Database do not have all columns required for excel Sheet. Some are calculated Columns. and One more thing is that I need to map the data to second sheet of excel.