Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update a html with data unloaded from an excel spreadsheet

Status
Not open for further replies.

spining123

Technical User
Jun 5, 2003
33
US
I have a two column excel file with 300 href links to individual documents.
Manually I select and copy from the excel file the href links, inputting this data into my html page table.

Is there anyway I can unload data from the excel file to my html page table automatic. The html page is on a server.

Thank you in advance for your help.
 

If the HTML page is on a server outside your own domain, then due to cross-domain security, I imagine you could not achieve this with JavaScript alone.

Your best bet is to mock up the form exactly as they have it, with all their form element names intact, then use JavaScript to script an Excel ActiveX component to read the URLs and insert them in your local form, and then submit the form to the their URL.

Of course, this will only work if they allow form submissions from outside their domain.

Hope this helps,
Dan


[tt]D'ya think I got where I am today because I dress like Peter Pan here?[/tt]
[banghead]

 
Thank you very much Dan,

Now I have some direction. I will try this today. Funny, I'm scheduled for JavaScript training next month.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top