Free Support Forum - aspose.com

Reading XLS file and looping through records

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.CellsIdea [I];

......

}