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
@pravin_calvin , Thanks for the rply. " .Copydatatable " Means? Can you explain me.!
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
@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
@pravin_calvin , Thanks for your help dude. @‘Yourvalue’ that you change
readDt.Select(“[Item] ='”+CurrentRow(“Item”).ToString+“'”).CopyToDataTable.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.