Export MySQL table into MS Excel spreadsheet
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?