Export MySQL table into MS Excel spreadsheet
Hi, all.
Help me, please. I have a MySQL database on web server, and PERL scripts working whit it. All I need is a mechanism that can export a table from DB to client MS Excel spreadsheet and vice versa. It may be download/upload for user. How can I generate MS Excel readable file on base of the MySQL table? How can I read uploaded from user MS Excel file to insert date into MySQL table on PERL under Linux? Thank You. |
I don't know much about the Excel format, but it may be easier to conver to/from a CSV format. It's an easy format that you can probably already find tools to import/export to MySQL, and Excel can also import/export it. And if you can't find tools to import/export to MySQL, it's an easy enough format to write your own import/export for.
|
All times are GMT -5. The time now is 03:09 AM. |