Code to determine, no of excel worksheets, no. of rows  in excel sheet.

Posted on 2013-01-21
Medium Priority
Last Modified: 2013-02-05
Assuming header as first row in excel sheet.
How to determine no. of worksheets in excel sheet.
How to read every row of every worksheet.
Question by:searchsanjaysharma
LVL 15

Accepted Solution

Minh Võ Công earned 1000 total points
ID: 38804394
You can use Microsoft.Office.Interop.Excel to read data from exel


Author Closing Comment

ID: 38857862

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question