Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Converting Excel file to Csv file

Soumya21
Level 6

‎13-10-23 07:23 AM

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

Athiban_Mahamathi
MVP
In response to Soumya21

‎16-10-23 03:46 PM

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

Soumya21
Level 6
In response to Athiban_Mahamathi

‎17-10-23 04:04 AM

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

0 Likes

NagarajanSundar
Level 2

‎17-10-23 11:52 AM

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