Copy Excel data into HTML webpage

Hi,

I have a simple HTML form like this, laid out with 3 lines of 3 input fields:

<form name="test">
<input type="text"><input type="text"><input type="text"><br>
<input type="text"><input type="text"><input type="text"><br>
<input type="text"><input type="text"><input type="text"><br>
</form>

Open in new window

I have an Excel file, 3 rows by 3 columns, with data like this (without the dots):

1.....4.....7
2.....5.....8
3.....6.....9


If I select those 9 cells in Excel, copy them and then select an input field on my HTML form and then paste, the contents of the 9 Excel cells all go into the 1 input field.

Is there any way to have those 9 cells pasted into my 9 HTML input fields (without having to do them one by one) and if so, can someone please provide a script to do it?

Many thanks
kbitAsked:
Who is Participating?
 
Big MontyConnect With a Mentor Senior Web Developer / CEO of ExchangeTree.org Commented:
here's a tutorial that does just that:

http://www.ibm.com/developerworks/opensource/library/os-phpexcel/index.html

it requires a database to save the results in, not sure if that's part of your requirements...
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
you would need to either paste the contents of the excel file into one field and then parse it out, or you would need to open the excel file server side and parse it out.

what are you ultimately trying to do? If you want to be able to edit the excel spreadsheet, have a look at this jquery plugin:

http://handsontable.com/
0
 
kbitAuthor Commented:
"you would need to either paste the contents of the excel file into one field and then parse it out,"

This sounds like a possibility, maybe submit the contents and somehow split it all out using PHP?
0
 
kbitAuthor Commented:
Yes this method will work perfectly, thank you for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.