Creating DataRow[] var

[cacafundi (J.G.)]

Hi folks,

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

please could you help me?.

thanks in advance folks.

[ddpadil (Dilip)]

Hello there,

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

1.

2.

3.

[cacafundi (J.G.)]

Thank you very much ddpadil !!

BR. !

[cacafundi (J.G.)]

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!!

BR.

[andrzej.kniola (Andrzej Knioła)]

@cacafundi

i want to select and copy all rows that contains certain value in a column

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

@cacafundi

but i can’t reach it.

please could you help me to reach it?

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

[cacafundi (J.G.)]

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

thanks!!.

BR.

[andrzej.kniola (Andrzej Knioła)]

Check if this leads you to a conclusion:

Group the information in Excel

Like this? (remember to set the path to wherever you put the Excel). DT_GroupCalculateTest.xaml (12.0 KB) GroupingOutput.xlsx (8.2 KB) Sometimes splitting actions into separate activities, while looking “longer” makes it easier to write and understand (also for long-term maintainability). In this case, doing it per step (1. Group values; 2. Calculate totals; 3. Prepare new outputs; 4. Write the outputs) is much clearer than trying to write a one-liner that does it all. For those that don’t …

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).

[cacafundi (J.G.)]

Thanks andrzej!!

BR.