How can I dynamically populate an excel spreadsheet?
I have a text file with some data in it, I want to conver that file to excel
format via code. I can get the data out, and populate the spreadsheet but it
keeps going in Cell A2. I have 20 rows in my text file so I want the
spreadsheet to have cell A2 to A21 filled in. I'm Getting all the data
because i'm able to see each row when i show the data in a message box. How
can i get the spreadsheet to populate correctly?
I want
BMW
Lexus
Chevy
Ford
instead of seeing only Ford in the A2 cell.
I have a text file with some data in it, I want to conver that file to excel
format via code. I can get the data out, and populate the spreadsheet but it
keeps going in Cell A2. I have 20 rows in my text file so I want the
spreadsheet to have cell A2 to A21 filled in. I'm Getting all the data
because i'm able to see each row when i show the data in a message box. How
can i get the spreadsheet to populate correctly?
I want
BMW
Lexus
Chevy
Ford
instead of seeing only Ford in the A2 cell.