Skip to content

Dumps a MySQL table to Microsoft Excel .xlsx spreadsheet.

License

Notifications You must be signed in to change notification settings

deltay/mysql2excel

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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 [email protected]

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

About

Dumps a MySQL table to Microsoft Excel .xlsx spreadsheet.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Java 100.0%