MySQL query output to excel file using perl script

listenerit · 02-16-2014, 02:32 PM

Hi Everyone,

Please help me in writing a perl script which would connect to MySQL database and execute a query and export the MySQL query output to an excel file with correct rows and columns.

Thank you Listener

John VV · 02-16-2014, 04:00 PM

that would be a MICROSOFT OFFICE excel file *.xlsx

For starters use a bat file on a Microsoft operating system

but for a normal everyday CSV file that can be done many different ways

chrism01 · 02-17-2014, 12:06 AM

We'd quite like to see what you've done so far ...
That being said, as above, '.csv' is the usual portable way to handle this.

However, if you really want to go direct to the correct Excel format, try search.cpan.org to find a '.pm' (Perl module).
It's probably there ... somewhere, but it may be a bit fiddly.

Personally I'd use '.csv'

pan64 · 02-17-2014, 02:35 AM

as far as I remember excel has an odbc interface therefore it can directly read mysql database. Why do you need perl?