I am trying to populate a list view object with data from an Excel worksheet. I have set it up to load in the column headers automatically by iterating through my worksheet until it finds an empty cell. What I then want to do it iterate from the second row in the first column to the last row populated in the last column, filling in the listview as it goes.

I am looking for a solution something like:

from 1st column to last column
from 2nd row to last row
add value from cell from worksheet to this location in listview
next row
next column

Thanks for any help!

Dan