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 rownext column
Thanks for any help!