Loading

How do i map table from database to already existing excel

Nepethya Rana

I already have excel sheet. This excel sheet has some columns with formula.

I need to map column from database to excel sheet. How do i do it?

Excel sheet has multiple sheets. I need to map the right sheets .

Please help me

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nepethya Rana9y ago
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.
0
Sundaram Subramanian9y ago
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