Can someone help me with the excel automation!

Help Studio
, ,
1

can someone help me with the excel automation !!where I need to get the count of each element in a column

2

Hi @Suthari_RohithReddy

Use read range workbook as dt
assign: query = new dictionary(of string, string)

query = From row In dt.AsEnumerable()
            Group row By key = row("ColumnName") Into Group
            Select key, Count = Group.Count()

query is a dict variable and its contains key as column group value and value as count

3

can we connect for a while ?

4

And check this for count values to write in excel: @Suthari_RohithReddy

2 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.