+
+=head1 NAME
+
+sql2xls.pl - convert sql queries on file system to Excel file
+
+=head1 USAGE
+
+Each file in current directory which ends in C<*.sql> will
+be converted to Excel sheet. If you want to have specific order, you can
+prefix filenames with numbers which will be striped when creating sheet
+names.
+
+Comments in sql files (lines beginning with C<-->) will be placed
+in first line in bold.
+
+To specify database on which SQL query is executed
+C<\c database> syntax is supported.
+
+You can also run script from command line, and it will produce
+C<sql_reports.xls> file.
+
+If run within directory, it will use files in it to produce file.
+
+When called as CGI, directory name can be appended to name of script
+to produce report for any sub-directory within directory where
+C<sql2xls.cgi> is installed.
+
+=head1 INSTALLATION
+
+Only required file is this script C<< sql2xls.cgi >>
+
+If your server is configured to execute C<.cgi> files, you can
+drop this script anywhere, but you can also add something like
+
+ ScriptAlias /xls-reports /srv/SQL2XLS/sql2xls.cgi
+
+in Apache's virtual host configuration to get nice URLs
+
+To configure default database, user, password and other settings create
+C<config.pl> file in same directory in which C<sql2xls.cgi> is with something
+like this:
+
+ $dsn = 'DBI:mysql:dbname=';
+ $database = 'database';
+ $user = 'user';
+ $passwd = 'password';
+ $path = 'sql_reports.xls';
+
+ $db_encoding = 'utf-8';
+ $xls_date_format = 'dd.mm.yyyy';
+
+ $debug = 1;
+
+=head1 SECURITY
+
+There is none. Use apache auth modules if you need it.
+
+=head1 AUTHOR
+
+Dobrica Pavlinusic, dpavlin@rot13.org, L<http://svn.rot13.org/index.cgi/SQL2XLS/>
+
+=cut
+