Read huge Excel file: Read excel file of min 43MB and export values to MySQL

	All requests	>	Read huge Excel file	>	Request new recommendation	>	Featured requests	>	No recommendations

Read huge Excel file

Edit

by Roddy - 5 months ago (2015-09-14) excel reader

Read excel file of min 43MB and export values to MySQL

+3	I have a huge Excel file that I should turn in MySQL tables. The script should run on Linux and Windows. Data can be exported as array, JSON, or MySQL tables, any of the three are perfect for me.

Ask clarification

2 Recommendations

eiseXLSX: Read and write Excel spreadsheets in XLSX format

+2	by Larry Wakeman 140 - 4 months ago (2015-09-21) Comment Does a good job reading Excel 2007+ spreadsheets.

• 1 Comment

• 1. by Manuel Lemos - 4 months ago (2015-09-23) Reply

  It can read Excel files but that is half of the requested jobs.

  Hopefully it can work return cell data so another package can insert it in the MySQL database.

Quick CSV import: Import CSV data into a MySQL database table

+1	by Manuel Lemos 11100 - 4 months ago (2015-09-21) Comment I do not think there is exactly a class that exports Excel files in the native format to MySQL. But if you can export Excel tables to the CSV format, you can use this class to import them into MySQL.

• 2 Comments

• 3. by Dan Thanh - 4 months ago (2015-09-25) in reply to comment 2 by Manuel Lemos Reply

  Yes, you can phpmyadmin. It has csv import function.

• 4. by Zhao - 4 months ago (2015-10-05) in reply to comment 2 by Manuel Lemos Reply

  Yes, CSV is a best choice for you.