Hello, a project I am working on is I need to pull manual tips from a csv file. Within this csv file my bot inserts a table and filters by category to only show “manual tips”. My issue now is that I do not know how to get my bot to copy this information and append it into the already existing sheet. Thank you in advance!
Hi @RPALearner_17 ,
If the data is in a CSV file, then you can use the Read CSV Activity and store it into a DataTable.
Make sure you mention the Delimiter so that the bot knows how it should interpret the data.
Next, use an Append Range Activity and pass in the DataTable you just copied from the CSV file.
Could you give this a try and let us know if it works?
Kind Regards,
Ashwin A.K
You don’t copy/paste into/out of Excel. Use the Excel activities.
Use Read CSV to get the file into a datatable, then use Filter Datatable to get just the rows you want, then use Workbook Append Range to write to Excel.
That worked thank you!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Anil_G
Anjani_Kapoor
ijanszen1
OGunnarsson
satish_nangedda
lakshmi.mp
Shruthika_r
sudster
Siraj_Balkhis_Reshma_YICC
devasaiprasad_K