How to get row number when extracting excel cells

Question

0.00/5 (No votes)

See more:

Hello Paul,

I've try to use your great code "C# How To Read .xlsx Excel File With 3 Lines of Code" to extract content cells of a simple sheet.

My problem is I can retrieve the column number with cell.ColumnIndex and cell content with cell.Text, but I don't know how to get the row number of the cell, So I can't extract the data successfully.

Can you lend me a hand?

Regards and thanks in advance

David Luque

What I have tried:

long MaxCol = 0;
            long MaxRow = 0;

            foreach (var worksheet in Workbook.Worksheets(@"T:\Libro1.xlsx"))
            {
                MaxCol = worksheet.MaxColumnIndex;
                foreach (var row in worksheet.Rows)
                {
                    foreach (var cell in row.Cells)
                        if (cell != null)
                        {                            
                            MessageBox.Show("Column: " + cell.ColumnIndex + "\nContent: " + cell.Text);
                        }

Posted 25-Mar-19 8:00am

TassadarNET

Updated 14-Jun-21 1:19am

Add a Solution

Comments

Richard Deeming 26-Mar-19 15:49pm

If your question is about the code in an article, you should post it in the forum at the bottom of that article:
C# How To Read .xlsx Excel File With 3 Lines of Code[^]

3 solutions

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)

Patrice T · Answer 1 · 2019-03-25T10:54:00

Solution 1

Quote:
My problem is I can retrieve the column number with cell.ColumnIndex and cell content with cell.Text, but I don't know how to get the row number of the cell, So I can't extract the data successfully.

Did you tried Cell.RowIndex ?
[Update]

Quote:
There is no RowIndex in Cell, there is only ColumnIndex.

Then try with cell.Row and cell.Column.

Posted 25-Mar-19 10:54am

Patrice T

Updated 25-Mar-19 13:03pm

v2

Comments

TassadarNET 25-Mar-19 17:38pm

Hi Patrice,

Many thanks for your answer. There is no RowIndex in Cell, there is only ColumnIndex.

I've try to count the rows in the foreach look, of course it works since it's counting the analyzed rows, but it I have a complete row in blank this row is not counted and all the rest fails.

Now I'm trying to use NPOI and it seems to be a good solution for my need, I've create a function that makes a new .xlsx file, now I'm trying to find out how to read an existent .xlsx

Regards

TassadarNET · Answer 2 · 2019-03-28T11:36:00

Solution 2

Then try with cell.Row and cell.Column.

There is no cell.Column, but many thanks for the try. I've finally use NPOI and it already works

Regards

Posted 28-Mar-19 11:36am

TassadarNET

Comments

Member 15245413 14-Jun-21 7:22am

Can You provide me your code once and explain NPOI

Member 15245413 · Answer 3 · 2021-06-14T01:19:00

Solution 3

Then try with cell.Row and cell.Column.

There is no cell.Column, but many thanks for the try. I've finally use NPOI and it already works

Regards

Can U give me solution of yours?

Posted 14-Jun-21 1:19am

Member 15245413