Creating DataRow[] var


#1

Hi folks,

i’m tryng to create a variable using the browse for types but i can’t find this type of var:

image

please could you help me?.

thanks in advance folks.


#2

Hello there,

First you need to choose array type->then browse->datarow.

1.array

2.browse

3.datarow


#3

Thank you very much ddpadil !! :clap: :clap: :clap:

BR. !


#4

Hi again,

kindly, may you could help me with another question.

i want to select and copy all rows that contains certain value in a column to another sheet in the excel, but i can’t reach it.

please could you help me to reach it?

thanks in advance!! :smiley:

BR.


#5

Search for .Select( on the forums. There are multiple examples of different queries.

Not sure what you mean by that. Could you elaborate?


#6

Hi Andrzej,

sure, i can explain it…

i have ten rows in an excel, those rows have seven columns.

what i want is to separate those rows filtering by the value stored in the column “value2”, and separate rows by sheet name, the result should be like this

i hope this will be helpful :sweat_smile:

thanks!!.

BR.


#7

Check if this leads you to a conclusion:


You could use same grouping (by value2 instead of TranType), then convert each grouping to DT, ignore the sum calls, and write to separate sheets (use grouping.Key.ToString as sheet name).


#8

Thanks andrzej!!:clap:

BR.