microsoft excel spreadsheets convert to php or java

Report · Jan 18, 2012

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.

Report · Jan 18, 2012

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.

Report · Jan 18, 2012

ok thanks, i will give that a go