PHP MYSQL
(a quick example)
Open terminal, navigate to project folder, run composer require phpoffice/phpspreadsheet.
Composer will download the latest version into vendor folder.
CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);
LOAD PHPSPREADSHEET require "vendor/autoload.php"; use PhpOffice\PhpSpreadsheet\ Spreadsheet; use PhpOffice\PhpSpreadsheet\ Writer\Xlsx;
CREATE SPREADSHEET $ss = new Spreadsheet(); $as = $ss->getActiveSheet();
FETCH DATA $stmt = $pdo->prepare ( "SELECT * FROM TABLE"); $stmt->execute();
WRITE TO SPREADSHEET $i = 1; while ($r = $stmt->fetch()) { $as->setCellValue("A$i", $r["COL"]); $as->setCellValue("B$i", $r["COL"]); $i++; }
SAVE FILE $writer = new Xlsx($ss); $writer->save("EXPORT.xlsx");