how to copy data from excel to webpage form?

[sanou]

Hi does anyone know if the following is possible?

I have an excel spreadsheet with values that i need transferred to a certain website's form. for instance, i have a value in excel spreadsheet xyz that i wanted to transfer to a data entry box on a webpage that is concurrently open. basically i want to make it simple enough that at a push of a button, i can copy/paste all my data into another form.

alternatively, i guess could have a webpage saved on my local harddrive, that would contain script to facilitate this process?

the purpose of this idea is to try to save time with data entry. i could enter raw data onto excel quickly and efficiently, and the excel file could be put to use for other internal data analysis. i don't have access to the webpage in question, as it was desgined by a third party vendor. hence my question.

i'm SUPER amateur at this stuff, so i know my idea will most likely be too cumbersome and there is probably a way to do all this alot more efficiently.

i would appreciate the help.

[Banfa]

I think you will have a lot of trouble doing this (in fact I think it is probably impossible).

I do something similar on one of my sites but it envolves having control of the site, the Excel spreadsheet is saved as a CSV file which is then uploaded to a CGI script (PHP in this case) and this script loads the data and performs the required action (saves it in a database).

However I can not think of a way to do this without control of the website.

[sanou]

yea, .csv's seem to be only solution i can find that comes close to solving this problem. i guess what i'm really trying to accomplish is to access a web page with data entry fields and autopopulate those fields with values from a file saved on my hard drive. ah screw it. maybe i'll try teaching myself php or something. :P thx for ur help.

[Devasena]

I am also in need of the same issue. I have a page which has N number of fields to enter data...and the user has to enter all the details in that page to navigate to the next page.since all the fields are made as mandatory.But i cant keep the field as optional also. I need all the information. I want to make automate, ie updating the form from the excel sheet data. So that the data entry will be easier to the user.
Help me in this regard.

Thanks in Advance
Devu

[Banfa]

As already stated above the only real way of doing that is to provide a form for the user to upload a CSV file (which is easily created in excel) and then use a server side script (like PHP) to auto-populate the details of the form.

[saif]

Hi does anyone know if the following is possible?

I have an excel spreadsheet with values that i need transferred to a certain website's form. for instance, i have a value in excel spreadsheet xyz that i wanted to transfer to a data entry box on a webpage that is concurrently open. basically i want to make it simple enough that at a push of a button, i can copy/paste all my data into another form.

alternatively, i guess could have a webpage saved on my local harddrive, that would contain script to facilitate this process?

the purpose of this idea is to try to save time with data entry. i could enter raw data onto excel quickly and efficiently, and the excel file could be put to use for other internal data analysis. i don't have access to the webpage in question, as it was desgined by a third party vendor. hence my question.

i'm SUPER amateur at this stuff, so i know my idea will most likely be too cumbersome and there is probably a way to do all this alot more efficiently.

i would appreciate the help.

I think it would be possible.
you need to find the names of input textboxes of the form in the website
and you could make a string value consisting the names of input and the values
from excel, similar to this .. "name=myName&ad dress=MyAddress "
this string has to convert to binary format and just post this data to the website address in the form.
you can make a program in vb and even in excel using VBA.
I remember I had made a AutoLogin program in vb that login to a website at
predetermined intervels.

Try...

[sanou]

Wow, I just realized how super amateur I am at this stuff. Haha.

So I've figured out how to manipulate excel data using Javascript (very basic manipulations but cool nonetheless).

Saif, I have no idea what you're talking about. Mind clarifying a bit? Haha sorry, I really slow at this.

From what I'm understanding.. .
1) if website www.XYZ.com has an input textbox named "BOX1"
2) the value "DATA" is currently stored in an Excel spreadsheet and I want transferred to BOX1
3) I create a string name=DATA&addre ss=http://www.XYZ.com
4) I find a way to post that string into the address bar of an internet browser

Did I get that right?

[saif]

1) if website www.XYZ.com has an input textbox named "BOX1"
2) the value "DATA" is currently stored in an Excel spreadsheet and I want transferred to BOX1
3) I create a string name=DATA&addre ss=http://www.XYZ.com
4) I find a way to post that string into the address bar of an internet browser

Did I get that right?

If you have a good Idea about HTML forms you would get what I mentioned earlear.
You need to dig into the HTML code of the webpage that contains the form.
as in the above example the code could be like this.

<FORM method="post" action="http://www.XYZ.com/dataentry.php" name="Form1">
<input type="text" name="BOX1" size="16">
<input type="text" name="BOX2" size="16">
</FORM>

you need to create a string similar to

"http://www.XYZ.com/dataentry.php?BOX1=Data1&BOX2=Data2"

just navigate this address in a browser.

No need to worry about the extention 'php' whatever address in the form
use that address

[sanou]

you're right, i don't understand that much about forms.

i think i'm attempting the impossible. after looking into this, i realized that what i'm really trying to do is attempt cross server scripting. so unless i had full access to xyz domain, then i'm stuck with manual data entry as my only option. my hope was automate data entry, using values from a data sheet to autopopulate a form on www.xyz.com

so unless i'm seriously missing something, i'm throwing in the towel. thanks saif for your help though.

[varun chawla]

you're right, i don't understand that much about forms.

i think i'm attempting the impossible. after looking into this, i realized that what i'm really trying to do is attempt cross server scripting. so unless i had full access to xyz domain, then i'm stuck with manual data entry as my only option. my hope was automate data entry, using values from a data sheet to autopopulate a form on www.xyz.com

so unless i'm seriously missing something, i'm throwing in the towel. thanks saif for your help though.

can some body provide me the vba code for this it woold be great help from your side. thanks and regards.

[iceman81]

Hi reflecting on the above say I have the following table in excel for example:
A B C D E F

aaa 0000 11 90% 07-02-08 Active/Inactive.

From the above, I would like collumns A, B, C to display static data on the web-page. Collumn D however changes as soon as the excel sheet is updated with a new value the updated value needs to be displayed on the webpage. Collumn E which contains the date has to update itself automatically showing the current date and last but not the least the last collumn F the user must have the option to change the status from "Active" to "Inactive" only once. Please can you provide a solution for the above in terms of methodology and some kinda sample script that I could use. Appreciate your help.