Import column from excel XP

  • Thread starter Thread starter Problematic coder
  • Start date Start date
P

Problematic coder

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 apologise if this double posted, but first one seemed to fail, I
will delete one if that is the case
 
Sorry logged in through different place and different id since google seems
screwed up.

I need an answer in vb since I do not ever code in C# and know nothing about
it, I did try to find the snippets but couldn't, but I doubt it would have
helped anyway since I can only just about manage vb
 
Back
Top