Loading

Foreach loop for excel column

Rukshar Khan

Hi

Need help in C# for excel generating. I have set of columns in which i want to set data from database through the use of foreach loop. The start cell should be E9 and then it set out to F9 , G 9 and so on. How can i go about doing this.

Thanks

2 Replies

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

Rukshar Khan9y ago
Thanks for your response, but i am using closed xml for this project any idea on how to do this on closed xml. Or creating a foreach loop through count.
0
Uehara Ayaka9y ago
Hi, if you use Spire.XLS to export data from datatable to Excel, it provides a method XlsWorksheet.InsertDataTable(System.Data.DataTable dataTable, bool columnHeaders, int firstRow, int firstColumn) which enables you to choose the start cell for inserting data.

refer to this link:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html
+1