point in the right direction

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey all,
i have an excel file that contains employee information. inside the workbook
there are numerous worksheets - one per employee. is it possible to iterate
thru the workbook reading pieces of data by any chance?

can somone please point me in the right direction?

thanks,
rodchar
 
Hello rodchar,

See there http://connectionstrings.com/?carrier=excel


---
WBR,
Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo


r> hey all,
r> i have an excel file that contains employee information. inside the
r> workbook
r> there are numerous worksheets - one per employee. is it possible to
r> iterate
r> thru the workbook reading pieces of data by any chance?
r> can somone please point me in the right direction?
r>
r> thanks,
r> rodchar
 
Hi,

rodchar said:
hey all,
i have an excel file that contains employee information. inside the
workbook
there are numerous worksheets - one per employee. is it possible to
iterate
thru the workbook reading pieces of data by any chance?
Click to expand...

I had never see such a construction, normally you have one row per employee,
not one worksheet.

Anyways, take a look at this
http://support.microsoft.com/defaul...kb;EN-US;316934

you can also find a lot of references in google
 
Back
Top