Command-line tool to dump MySQL tables to Microsoft Excel .xlsx Spreadsheets written in Java.
Download the latest release from https://github.com/DevDungeon/mysql2excel/releases or clone the repo from https://github.com/DevDungeon/mysql2excel
git clone https://github.com/DevDungeon/mysql2excel
# Compile and package with Maven
cd mysql2excel
mvn package
java -jar mysql2excel-1.0.1.jar
java -jar mysql2excel-1.0.1.jar -g sample.config
java -jar mysql2excel-1.0.1.jar my.config
NanoDano nanodano@devdungeon.com
- 2018-03-25 v1.0.1
- Bug fix: added convert zeroDateTimeBehavior to convertToNull, minor formatting tweaks
- 2018-03-18 v1.0.0
- Initial stable release
- Allow multiple tables or all tables to be dumped at once
- Allow custom SQL query to be run