cancel
Showing results for 
Search instead for 
Did you mean: 

Converting Excel file to Csv file

Soumya21
Level 6

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
------------------------------
12 REPLIES 12

salman_shaik
Level 5

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

If I was of assistance, please vote for it to be the "Best Answer". Thanks & Regards, Salman Shaik

Hello Soumy,

Here are the steps suggested by Salman:

Process exemple:

20975.png

Output:

20977.png

Action inputs:

20978.png

Output:

20979.png



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

Leonardo Soares RPA Developer América/Brazil

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

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

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

@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
------------------------------

Hi @Athiban Mahamathi Mathialagan

This is how converted csv file looks like

20997.png



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

Hi Soumya,

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

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


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

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