I'd use DBI for everything..like this:
1) File | Save As and save the spreadsheet as a CSV file
2) Remove the .csv extension if excel tries to put one on the newly created csv file
3) Use DBD::CSV to read in the data, and DBD::mysql to insert the rows into your new table.

Notes:
-The name of the CSV file is the table name for DBD::CSV, thus why I suggest removing the .csv extension
-Lots of ways I think you can get the column names dynamically, and do a one time creation in the myssql database. One perhaps bad idea is if your query is "SELECT * from csvFileName" then you can access the column names with $statement->{NAME} # its an array ref