How to convert .xlsx to .csv

[jai_kumar2 (jai kumar)]

HI

Iam trying to convert .xlsx file to .csv without using write csv activity

just want to convert

Please help me with the possible mathod

Thanks in advance

[raja.arslankhan (Raja Muhammad Arslan khan)]

@jai_kumar2
Did you try Vb Code?

1. Use the “Excel Application Scope” activity:

• Drag and drop the “Excel Application Scope” activity onto your workflow.
• Set the WorkbookPath property to the path of your .xlsx file.

2. Use the “Read Range” activity:

• Inside the “Excel Application Scope,” add the “Read Range” activity.
• Specify the range of cells you want to read from the .xlsx file or leave it empty to read the entire sheet.
• Set the DataTable output property to store the data from the .xlsx file.

3. Use the “Write Text File” activity:

• Outside of the “Excel Application Scope,” add the “Write Text File” activity.
• Set the FileName property to the desired output .csv file path.
• In the “Content” field, use the following expression to convert the DataTable to CSV format:

String.Join(Environment.NewLine, dataTable.AsEnumerable().Select(Function(row) String.Join(",", row.ItemArray)))

• Set the Append property to False to overwrite the file if it already exists.

4. Save and run your workflow to convert the .xlsx file to .csv.

[mkankatala (Mahesh Kankatala)]

Hi @jai_kumar2

Use the Read range workbook activity to read the excel file and store it in a datatable. Use the Write csv activity to write the same datatable to csv file. It was the simple process.

Hope it helps!!

[Nitya1 (Nitya Tomar)]

Hi @jai_kumar2

To convert an .xlsx file to .csv format in UiPath without using the “Write CSV” activity, you can use the following steps:

1. Use the “Excel Application Scope” activity to open the Excel file.
2. Within the scope of “Excel Application Scope,” use the “Read Range” activity to read the data from the Excel file into a DataTable variable.
3. Create a new StringBuilder variable to store the CSV data.
4. Use a “For Each Row” activity to iterate through each row in the DataTable.
5. Within the loop, use a “For Each” activity to iterate through each column in the row.
6. Append the column value to the StringBuilder variable, followed by a comma (,) to separate the values.
7. After the inner loop, use an “Assign” activity to append a newline character (Environment.NewLine) to the StringBuilder variable.
8. After the outer loop, use the “Write Text File” activity to write the content of the StringBuilder variable to a .csv file.

Thanks!!

[supriya117 (Supriya Allada)]

Hi @jai_kumar2

You can check this once:

Convert XLSX file to CSV through Invoke code method VBA, only change file type

Hello, I am working on a unique case. Data has to be uploaded in a csv file format, but with a XLSX layout. As in Cell A has data Cell B has data Cell C has data. To do this manually, one can save a copy as and change the file type. I would like to do this without having to interface with the UI of Excel through the invoke code perspective. I have found the thread on how to achieve this in reverse, but i was unable to reverse engineer it to meet this specific use case requirements. Please p…

[Anil_G (Anil Gorthi)]

@jai_kumar2

1. Use read range activity and then read the data into datatable
2. Use output datatable activity which will convert your datatable dt to string str
3. Now use write text file and give str as data input and filename as a .csv instead of .txt

Cheers

[lrtetala (Lakshman Reddy)]

Hi @jai_kumar2

By using Rename File activity you can convert your .xlsx file to .csv file

Regards,