how to get total no of sheet in excel file using C#

Question

0.00/5 (No votes)

See more:

C#3.5

can u just tell me how to retrieve total number of sheet in a excel file

Posted 17-Jun-14 20:34pm

Member 10891595

Add a Solution

3 solutions

Solution 2

C#

   Application _excelApp = new Application();
Workbook workBook = _excelApp.Workbooks.Open("d:/Book1.xls");

int numSheets = workBook.Sheets.Count;

Posted 17-Jun-14 21:04pm

PrakashCs.net

Comments

Member 10891595 18-Jun-14 4:42am

pls eleborate this sir

Solution 1

I hope this link will help you :-
C# - Retrieve Excel Workbook Sheet Names.[^]

Good luck.

Posted 17-Jun-14 20:45pm

Raje_

v2

Comments

Member 10891595 18-Jun-14 4:43am

sry sir i can not get it is there are any other way for this

Raje_ 18-Jun-14 8:38am

Pls check solution 2 :
int numSheets = workBook.Sheets.Count;
this line gets the number of sheets.

Raje_ 19-Jun-14 3:43am

Who has down voted.....LOL!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2014-06-17T22:52:00

Solution 3

See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^].

Posted 17-Jun-14 22:52pm

Richard MacCutchan

Comments

Member 10891595 18-Jun-14 5:40am

pls sir give me the exact solution of my problem

Richard MacCutchan 18-Jun-14 6:37am

Don't be lazy, go and read the article and try it for yourself.

Member 10891595 18-Jun-14 23:29pm

dear sir when i m applying ur code in my project i m getting following error pls provide me the exact solution for this

Excel cannot open the file 'Test Input.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

Richard MacCutchan 19-Jun-14 4:11am

What do you mean the exact solution? The message explains exactly what is wrong, you need to examine the file to find out why.