C#: Getting the number of rows/columns with ExcelPackage

Posted by Napoli on Stack Overflow See other posts from Stack Overflow or by Napoli
Published on 2009-11-11T15:27:18Z Indexed on 2010/05/31 18:03 UTC
Read the original article Hit count: 630

Filed under:
|
|
|
|

I need to read and write data from an Excel spreadsheet. Is there a method to finding out how many rows/columns a certain worksheet has using ExcelPackage? I have the following code:

        FileInfo newFile = new FileInfo(@"C:\example.xlsx");
        using (ExcelPackage xlPackage = new ExcelPackage(newFile)) 
        {
            ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets[1];
        }

I need to iterate through each cell this worksheet has and spit it into a fairly big table, but I don't want to print out blank cells or get an exception. Is there a method resembling worksheet.rowNum or colNum?

© Stack Overflow or respective owner

Related posts about c#

Related posts about excel