How to write Row value on next sheet

Hi Developers,
I have come to a challenge on writing the particular row value on the next sheet. How to automate it?

Hi @Majunu09

With Select method we can achieve !

NewDt =readDt.Select(“[Columnname] =‘Yourvalue’”).CopyToDatatable

Write range to a new Sheet!

Regards

2 Likes

@pravin_calvin , Thanks for the rply. " .Copydatatable " Means? Can you explain me.!

1 Like

Hi @Majunu09

The Result from the select method will be of variable type Data row!

CopyToDataTable will Convert the Data row to Datatable and save it as datatable.

Have a view below!

Regards

1 Like

@pravin_calvin , Its throwing error like this cannot find column (“ABC”)

@pravin_calvin , On my xaml file I have created the workflow up to this, can you explain to me an update to be done. While Attempt1 works fine and it is written on a particular cell.
Main.xaml (26.8 KB)

Monthly.xlsx (11.7 KB)

Hi @Majunu09

As per my Understanding you need to write each item in each sheet with the Sheet name as item Correct me if i am wrong?

Regards

Right. Ill be fetching those data from Sheet November to placing on other sheet based on “Column Item” “Value Tea or Coffe or Puff” Like wise . My my condition from item fetch tea value from the column and I need to pick whole row and place on its sheets.

Hi @Majunu09

Refer to the xaml below and alter the if condition based on your item!

Main.xaml (7.9 KB)

Regards

1 Like

@pravin_calvin , Thanks for your help dude. @‘Yourvalue’ that you change
readDt.Select(“[Item] ='”+CurrentRow(“Item”).ToString+“'”).CopyToDataTable.

1 Like

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