point in the right direction

[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

 

[Michael Nemtsev]

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

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

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?

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