topic RE: Converting Excel file to Csv file in Product Forum

Converting Excel file to Csv file

Soumya21 — Fri, 13 Oct 2023 06:23:00 GMT

Hi,

I want to convert Excel file to Csv file without using Ms Excel Vbo actions

If anyone has an idea on this. Please help on this

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Converting Excel file to Csv file

salman_shaik — Fri, 13 Oct 2023 10:11:00 GMT

Hi Soumya,

Use the Move File Action available in File Management VBO.

Inputs

File Path: "C:\Template\ABC.xlsx"
Destination Path: "C:\Template\ABC.csv"

This will convert the .xlsx file to .csv

If you want it to be stored in a different location then in the destination path give different directory "D:\Template\ABC.csv".

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Salman Shaik
------------------------------

RE: Converting Excel file to Csv file

LeonardoSQueiroz — Fri, 13 Oct 2023 16:27:00 GMT

Hello Soumy,

Here are the steps suggested by Salman:

Process exemple:

Output:

Action inputs:

Output:

------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------

RE: Converting Excel file to Csv file

Soumya21 — Mon, 16 Oct 2023 03:54:00 GMT

Hi,

Thanks for the solution.

When I try this solution. when Bot is reading Values through Get CSV as Collection Data is coming in improper format.
Any other solution except copy and move file is appreciated.

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Converting Excel file to Csv file

Athiban_Mahamathi — Mon, 16 Oct 2023 04:49:00 GMT

Hi Soumya,

You can achieve this by slightly modifying the existing SaveWorkbookAs action in Excel VBO. Please refer to the below thread.

Save Excel worksheet as csv | Blue Prism Product

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------

RE: Converting Excel file to Csv file

Soumya21 — Mon, 16 Oct 2023 06:10:00 GMT

Hi @Athiban Mahamathi Mathialagan

How can we convert without using excel actions since excel is not installed in machine.

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Converting Excel file to Csv file

Athiban_Mahamathi — Mon, 16 Oct 2023 10:03:00 GMT

@Soumya21, can you please share the incorrect format example when you try to convert the xlsx file using move action?

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------

RE: Converting Excel file to Csv file

Soumya21 — Mon, 16 Oct 2023 10:15:00 GMT

Hi @Athiban Mahamathi Mathialagan

This is how converted csv file looks like

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Converting Excel file to Csv file

Athiban_Mahamathi — Mon, 16 Oct 2023 10:41:00 GMT

Hi Soumya,

if you have oldeb installed in the machine then can you please try the below steps?

Get the xlsx data as collection using "Data.Oledb"
use "Get collection as CSV" action in Utility - Strings to convert the collection to csv text.
save the text to the csv file.

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------

RE: Converting Excel file to Csv file

Soumya21 — Mon, 16 Oct 2023 11:31:00 GMT

Hi @Athiban Mahamathi Mathialagan

In the machine there is no office installed

To use oledb solution Office 365 is required

How can it be done without using oledb solution and without using excel actions

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Converting Excel file to Csv file

Athiban_Mahamathi — Mon, 16 Oct 2023 14:46:00 GMT

I don't think you need office 365 to use Oledb.

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext,
Singapore
------------------------------

RE: Converting Excel file to Csv file

Soumya21 — Tue, 17 Oct 2023 03:04:00 GMT

Hi @Athiban Mahamathi Mathialagan,

when I tried using Oledb without installing office 365

I am getting error like this
Could not find installable ISAM.

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Converting Excel file to Csv file

NagarajanSundar — Tue, 17 Oct 2023 10:52:00 GMT

Hi Soumya,

you must require MS-office installed in the resource for reading the excel content.

In case, if you have a excel data in the collection. Then you can alter some piece of codes from "create text file" and "Write text file" to customize coding stages. where you have to change the code from ".txt" to ".csv" and then you have to iterate the collection data using loop and refer the Seperator from the control panel. apply the same Seperator.

Note: Above specified workaround is applicable when the line items are very minimal. in case, if it goes beyond more than 5k line items. then it is not suggestable solution.

------------------------------
Nagarajan Sundararajan
------------------------------