How to convert xls to csv file format | Selenium Forum
M
Posted on 12/09/2016
Hi Ashish,

In my application, a file gets downloaded with extension as xls. I need to convert this to csv format. How can I do so?

M
Replied on 14/09/2016

There are many converters available on net
Check this
https://www.completecampaigns.com/webhelp/Management/Imports/How_to_convert_an_existing_Excel_file_into_a_csv_format.htm


M
Replied on 14/09/2016

No I mean can we write some Java code to do so?


M
Replied on 15/09/2016

try these

http://www.simplecodestuffs.com/converting-xls-to-csv-files-using-java/
http://stackoverflow.com/questions/22994875/convert-xls-to-csv-in-java
http://stackoverflow.com/questions/23053151/convert-xls-to-csv-java


M
Replied on 15/09/2016

Ashish,

I already checked these but I have a doubt like everytime the file gets downloaded, it has different set of data. So, can we write a generic code for conversion irrespective of what the data inside the file is?


M
Replied on 16/09/2016

[quote="arora.akhil29@gmail.com":qvdnw3rq]Ashish,

I already checked these but I have a doubt like everytime the file gets downloaded, it has different set of data. So, can we write a generic code for conversion irrespective of what the data inside the file is?[/quote:qvdnw3rq]

everything is possible but i won't recommend it best way to do is using online converter.


M
Replied on 20/09/2016

Can u plz guide how to convert using code.


M
Replied on 20/09/2016

i'm afraid we don't have any expertise into what you are looking for.