I did a quick search, but couldn't find sample code for opening XLS file and then looping through the records in order to insert into database.
I am having a hard time identifying how many filled columns are there and how many rows.
Thank you
I did a quick search, but couldn't find sample code for opening XLS file and then looping through the records in order to insert into database.
I am having a hard time identifying how many filled columns are there and how many rows.
Thank you
To loop through cells in a worksheet, you can try this:
for(int i = 0; i < sheet.Cells.Count; i ++)
{
Cell cell = sheet.Cells;
......
}