microsoft excel spreadsheets convert to php or java

Question

I have been given a excel spreadsheet that already has some calulation built into it. e.g. a numerical amout is inputted into one field in the spreadsheet, this then gives results in the other fields in the spreadsheet.

Is there anyway i can "easily" convert this spreadsheet to either javascript, jquery or PHP. basically the results of the inputted information need to be sent to a sql database.

thanks in advance

the database is phpMyAdmin MySQL.

Drymetal · Answer

I got this to work one time and here is what I did:

1. I saved the excel file as a CSV file.

2. I opened the csv in Crimson Editor (or notepad if you don't have a fancy text editor) and I kept it open so I could reference it in a couple steps.

3. I went to phpmyadmin, clicked on the database, clicked on Import at the top.

4. At the bottom I chose CSV as the file format.

5. It then expands and ask you questions like this:

Fields terminated by

Fields enclosed by

Fields escaped by

Lines terminated by

Column names

6. I then filled that out using the appropiate information I found in the file.

I don't remember if this went smoothly or not. So you might have to play around with it. I'm not sure. I'd also make a copy of your database and use that the first time just in case.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded