in reply to Uploading Excel data into MySQL via a browser

Get the raw .xls file via File Upload with CGI.pm, parses Excel raw data with Spreadsheet::ParseExcel, and finally put em into MySQL with DBI + DBD::mysql. That's all.

And there is also Spreadsheet::WriteExcel::FromDB which does the opposite. FYI.

--
Tatsuhiko Miyagawa
miyagawa@cpan.org

  • Comment on Re: Uploading Excel data into MySQL via a browser