Foreach loop for excel column

Question

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

Uehara Ayaka · Answer

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

Rukshar Khan · Answer

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.