Can anybody knows how to convert excel file to .csv file using perl script or java. If u knows plz post me.
Does it have multiple worksheets or only one worksheet in each excel document ?
also, How data is organized in this excel sheet, typical table type (rows x columns) with / without header ?
You can build informatica to read the excel file and dump into a .csv file
Hi Dev Team,
I have one requirement, exctract data from multiple worksheets in one excel file and it contains header. So could you please let me suggest the solution.
Thanks in Advance.
Please follow the provided link to download the code with detailed user guide.
You can also find many other solutions and tools from the same website.
Try with this script in .sh file and let me know ......
xls2csv -q -x sorcedirectory_path/'input.xls' -w "insidesheetname" -c destination_path/outputfile.csv
it will be helpfull if xl file having onesheet inside..