Dumps a MySQL table to Microsoft Excel .xlsx spreadsheet.
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
src/main/java/com/devdungeon/mysql2excel
.gitignore
LICENSE
README.md
pom.xml

README.md

mysql2excel

Command-line tool to dump MySQL tables to Microsoft Excel .xlsx Spreadsheets written in Java.

Downloading

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

Usage

Print help information

java -jar mysql2excel-1.0.1.jar

Generate a settings template file

java -jar mysql2excel-1.0.1.jar -g sample.config

Dump from MySQL to Excel using settings in config file

java -jar mysql2excel-1.0.1.jar my.config

Project Page

Contact

NanoDano nanodano@devdungeon.com

Changelog

  • 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

To do

  • Allow multiple tables or all tables to be dumped at once
  • Allow custom SQL query to be run