Excel 2 CSV Command Line Tool
Switch branches/tags
Nothing to show
Failed to load latest commit information.
src/main/java/org/apache/poi/ss/examples fix evaluate bad formulas Apr 23, 2012
.gitignore Fix .gitignore Mar 23, 2012
README Usage in readme Sep 15, 2011
pom.xml Closes #4 Mar 23, 2012


# Build

mvn clean package

# Use

usage: java -jar excel2csv-1.0.0.jar [OPTIONS] <source> [<destination-folder>]
            Here <source> is XLS or XSLX file <destination-folder> folder for CSV files. If not
            specified <source> folder will be used.
 -f,--format      Optional. This argument can take one of two values. Passing 0 (zero) will result
                  in a CSV file that obeys Excel's formatting conventions whilst passing 1 (one)
                  will result in a file that obeys UNIX formatting conventions. If no value is
                  passed, then the CSV file produced will obey Excel's formatting conventions.
 -h,--help        Prints this help message.
 -r,--row-limit   Rows limit per sheet. Default unlimited (-1). Will produce preview file per sheet.
 -s,--separator   Optional. The character or characters that should be used to separate fields in
                  the CSV record. If no value is passed then the comma will be assumed.

java -Dfile.encoding=utf8 -Xms512m -Xmx512m -XX:MaxPermSize=256m -jar excel2csv-1.0.0.jar file.xls