java-CSV-to-Excel

Usage

The executable jar is in the 'dist' directory

java -jar java-csv-to-excel-jar-with-dependencies.jar -t [xlsx|xls] -o [outfile] -d [delimiter] -e [input encoding] -i [infile1:infile2:infile3...]

Example Usage

Pipe Delimited CSVs

java -jar java-csv-to-excel-jar-with-dependencies.jar -t xlsx -o myoutfile -d "|" -e UTF-8 -i mysheet1.txt:mysheet2.txt:mysheet3.txt

Using same output name as input name

java -jar java-csv-to-excel-jar-with-dependencies.jar -t xlsx -o /home/toto/doc/myfile.csv -d "|" -e UTF-8 -i /home/toto/doc/myfile.csv

Will create a file with name '/home/toto/doc/myfile.csv.xlsx'

Troubleshooting:

1. "Command not found.": If you are using a pipe delimiter it must be escaped with a slash. E.g. "\|".
   
2. "(No such file or directory)": Check you have the correct input/output file paths
   l

HOWTO build a new executable jar

mvn clean compile assembly:single