I have come to a challenge on writing the particular row value on the next sheet. How to automate it?
With Select method we can achieve !
NewDt =readDt.Select("[Columnname] =‘Yourvalue’").CopyToDatatable
Write range to a new Sheet!
@pravin_calvin , Thanks for the rply. " .Copydatatable " Means? Can you explain me.!
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!
@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)
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?
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.
Refer to the xaml below and alter the if condition based on your item!
Main.xaml (7.9 KB)
@pravin_calvin , Thanks for your help dude. @‘Yourvalue’ that you change
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.