I have multiple Excel workbooks with a single worksheet in them.
The only column that is filled out is the first column with numeric
data.
The first colum 'A' has a random number of rows.
I want to import the rows from a1 to the last row in the column.
When I import the data I just need to add it to an arraylist.
What is the most efficient way of doing this?
I'm looking for the best way to pull the data out of the excel
worksheets only. I have already writen the code to find the paths to
the workbooks and they are stored in an arraylist named 'alMyPaths'.
-Peter
Sample data
Cell A Cell B-,,, (Empty)
1 238978
2 2378975
3 90238958908
4 0238978
5 89402738957
6 023878
7 937255
8 8948585
9 85723975
1 0127897
The only column that is filled out is the first column with numeric
data.
The first colum 'A' has a random number of rows.
I want to import the rows from a1 to the last row in the column.
When I import the data I just need to add it to an arraylist.
What is the most efficient way of doing this?
I'm looking for the best way to pull the data out of the excel
worksheets only. I have already writen the code to find the paths to
the workbooks and they are stored in an arraylist named 'alMyPaths'.
-Peter
Sample data
Cell A Cell B-,,, (Empty)
1 238978
2 2378975
3 90238958908
4 0238978
5 89402738957
6 023878
7 937255
8 8948585
9 85723975
1 0127897