Create form that accepts "pasting" from excel
Posted on 2006-10-20
Hey everybody, I don't know if this is posted in the right area, but I'm going to give it a shot. I am trying to build a web page that can accept data from the user. This is done very easily by creating a form with a bunch of input boxes ("<input type=text>"). My problem is, the page is going to be used by high-level executives, and I know it sounds bad, but they won't want to re-type all of their numbers. The numbers that they enter will already exist in an Excel workbook that they regularly use, so I want to make is so that the users can simply select 31 cells in their Excel workbook, hit "Copy", and then go to the web page and select "Paste", and then magically, all of the data will appear in the form on the web page.
I know I have seen this done with 3rd party applications, but I'm wondering if this can be done with a simple HTML page. I don't mind if some scripting has to be done... maybe the user could paste into the first input box and then a script would read the entire string that was pasted and split around a tab, then fill in each box separately, I don't know.
Any thoughts or prior experience would be GREATLY appreciated. Thanks!