:   export-spreadsheet.bat
:   batch file to generate a spreadsheet file for OOo-Calc or MS-Excel
:   n6lhv@arrl.net
:   created:  20-December-2004
:   updated:  22-December-2004

:   functional dependencies
:     -the ODBC driver (e.g., MySQL Connector/ODBC) has been installed correctly
:     -the MySQL Service is running
:     -all of the correct database files have been successfully generated
:     -any one of the desired table(s) *isn't*/*aren't* larger than 65535 [(64*1024)-1] rows

: Set the correct parameters
SET fileWorkBook=%1

: MS-Excel workbook, structure and data for one or more WorkBooks
del %fileWorkBook%-xls.zip
del %fileWorkBook%.xls
perl -w export-spreadsheet.pl %fileWorkBook%
pkzip25 -add %fileWorkBook%-xls %fileWorkBook%.xls