How can I change .csv to .xlsx from export downloaded queue data

Help Activities
, ,
1

Hi, everyone,

I downloaded the queue data from orchestrator. Like:
image

image
image316×196 4.7 KB

How can I change .csv extensions with .xlsx
Replace not working.
I don’t want to do it manually

2

Hi @Kismet_Tosun

  1. Read your csv file with “Read CSV” activity, Save output in Variable Eg. Dt_data.
  2. Use “Write Range workbook” activity and give above saved variable in same activity.

Let me if you need any more explaination.

Thanks,
Anwar khan

3

@anwarkhan

@anwarkhan I don’t want to use read cvs and write csv activity.I tried. I have a structure and I using add data rows. I can’t use add data row while csv

4

@Kismet_Tosun

Can you please tell what you mean by not able to use add data row?

what are you tryign to do?

did you try append csv?

cheers

5

Hello, good evening,

Can you try using Rename File activity. In the File field pass the file path with csv extension and the in the new name field pass the path with the .xlsx extension. Uncheck the Keep Extension box and run the process. This should convert your file to the xlsx format from csv.

Thank you

6

Have you tried it with modern activities.
Please find solution provided by @Anil_G

7

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