• 0

[PHP] display excel sheet


Question

I've been searching for awhile now on Google and Bing for a solution to upload an excel sheet, and extract the data, importing it into a MySQL database.

I can handle the upload and import stages of the sheet, but I'm lost on finding a working script that allows me to export excel -> PHP.

There is a total of 8 columns, and about 9000 rows of data, so I don't want to manually input each one.

So i've turned to Neowin for a solution for my problem. Help me out!

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

In column 9 you could write out a formula to INSERT that row into the database table, copy down said formula and then copy the formulae and execute them?

This is the simplest method I could think of; rather than searching for custom interfaces between Excel & PHP.

Link to comment
Share on other sites

  • 0

Thanks, but I was looking on the code to even display the excel sheet on the site in a readable format.

I found a solution tho.

Save file as CSV > Upload > Explode by comma > display / insert into DB.

Thanks to DaveLegg for telling me this :D

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.