i have tried using the read csv and then move file to change the csv from .csv to .xlsx but it does not work. i need to convert it to .xlsx to remove duplicate and do some data ordering.
You can do the removal of duplicates using datatable itself and then save it to excel file
Read the csv file using read csv file activity and store in dt1
Use Remove duplicates to remove the duplicates
after other operations with datatable, use write range to write the datatable to excel file
Hope it helps
Mark it as solution if it resolves ur query
Use read CSV file activity → You will save the data as DataTable. Then you can use Write Range to write your data in an Excel file.
See these videos about csv.
Video 1: UiPath | Read CSV File | Add Column to CSV File | How to read CSV File and Add Data Column to CSV - YouTube
Video 2: UiPath | Convert Text File to CSV File | Get Data from Text File into CSV File | Create CSV File - YouTube
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.