Export data from MySQL to Excel .xlsx ( Java JTable )
https://www.apache.org/dyn/closer.lua...
https://mvnrepository.com/artifact/my...
import java.awt.Desktop;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import javax.swing.JFileChooser;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
jar utilizados
poi-5.0.0.jar
poi-ooxml-5.0.0.jar
poi-ooxml-full-5.0.0.jar
xmlbeans-4.0.0.jar
commons-compress-1.20.jar
commons-collections4-4.4.jar
commons-math3-3.6.1.jar
mysql-connector-java-8.0.21.jar