Opening MS Excel worksheet in C#
Posted
by topgun_ivard
on Stack Overflow
See other posts from Stack Overflow
or by topgun_ivard
Published on 2010-06-18T00:58:16Z
Indexed on
2010/06/18
1:03 UTC
Read the original article
Hit count: 290
I know we can open a particular worksheet of MS Excel using C# by providing the sheet number (1,2,3..) or name (sheet1, sheet2, sheet3...)
I have a excel file which has 2 sheets, 1. Values, 2. Results
Is there a way to open a sheet giving the sheet name ,i.e, "Values" instead of 1 or [s|S]heet1 in C# ??
I looked thru the old posts but didnt find anything useful...
so again, what I am trying to do is, open a Excel worksheet by using its user defined name (Values) instead of the system defined name(1 or [s|S]heet1)
any inputs would be greatly appreciated!
© Stack Overflow or respective owner