Hi,
I have just been asked to create an app that will import a specific
column from an excel spreadsheet, something like sheet1 columnD or a
column with the first row with a value of 'ID' whichever would be
easier. The rest of what I need to do once I have the data I am ok
with but the connecting to the spreadsheet and extracting a column
into an array or dataset or whatever would work best I have no clue.
I would appreciate some actual code examples, I know this represents
doing my work for me, (actual work not homework) but I can assure you
this is only a small part of the overall project.
If it is not possible to specify a specific column, alternative
suggestions would also be appreciated.
Thank you in advance
I have just been asked to create an app that will import a specific
column from an excel spreadsheet, something like sheet1 columnD or a
column with the first row with a value of 'ID' whichever would be
easier. The rest of what I need to do once I have the data I am ok
with but the connecting to the spreadsheet and extracting a column
into an array or dataset or whatever would work best I have no clue.
I would appreciate some actual code examples, I know this represents
doing my work for me, (actual work not homework) but I can assure you
this is only a small part of the overall project.
If it is not possible to specify a specific column, alternative
suggestions would also be appreciated.
Thank you in advance