Read csv and then change it into an excel file

Help Studio
, ,
1

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.

2

Hi @clumsily
You can do the removal of duplicates using datatable itself and then save it to excel file

steps

  1. Read the csv file using read csv file activity and store in dt1

  2. Use Remove duplicates to remove the duplicates

  3. 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

Regards,
Nived N
Happy Automation

3

Hi @clumsily

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: https://www.youtube.com/watch?v=vpi_es13-AI
Video 2: https://www.youtube.com/watch?v=RyVUSn8JJpQ

Best regards
Mahmoud

4

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