How to get rows count from column

[Addy_619]

Hi I have an excel and I want to get rows count for column can you please help on this??

[GersonTun]

Hi @Addy_619
Can you share what’s de input, and what would be the output desired?

[Addy_619]

simple just want row count of column. ex. how many records present in column B in excel like that.

[NIVED_NAMBIAR (NIVED N)]

Hi @Addy_619
You can try this way

dt1.AsEnumerable().Select(Function(r) r(columnname).ToString).ToArray().Where(Function(r1) r1<>“”).Count

columnname should be put in quotes for eg, if the column name is Data u had to write code like

dt1.AsEnumerable().Select(Function(r) r(“Data”).ToString).Where(Function(r1) r1<>“”).Count

[GersonTun]

ColumnRowsCount.xaml (5.3 KB)
sample.xlsx (8.3 KB)

Take a look at this WF, and let me know.

[Addy_619]

Just one question it is not counting blank rows in between records

[Palaniyappan (Forum Leader)]

Hi

Hope these steps would help you resolve this

—use a excel application scope and pass the file path as input and get the output as dt

—now create a variable in variable panel named Finaldt of type System.Data.Datatable with default value as New System.Data.Datatable

—then use a assign activity like this

Finaldt = dt.DefaultView.ToTable(False,”yourcolumnname”).CopyToDatatable()

Here Finaldt is our new dt with just the column B

—now use a Assign activity like this

Int_rowcount = Finaldt.Rows.Count

Int_rowcount is the row count of column B

Cheers @Addy_619

[GersonTun]

@Addy_619
You can modify the highlighted code as you need

If you leave it like this: Where item(“ColumnB”) IsNot Nothing
it will count all the rows, no matter what the content of the cell is.