Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Web Programming > HTML > HTML Code Clinic
| Search | Today's Posts | Mark Forums Read
HTML Code Clinic Do you have some HTML code you'd like to share and get suggestions from others for tweaking or improving it? This discussion is the place.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the HTML Code Clinic section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 4th, 2005, 06:09 PM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel to Web Form Merge!!!

i need to be able to take my excel spreadsheet and upload the info to a web form on the internet. is this possible?

i need it for thousands of users. im trying to propagate the DB via the internet form.

 
Old January 5th, 2005, 05:23 AM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Probably possible assuming that the form is fairly straightforward and doesn't have features designed to prevent auto fill in, such as typing in characters from a gif.
Steps that need coding:
  • Open Excel workbook.
  • Locate range
  • Open IE
  • Begin to loop through rows, assuming each row contains one person's details.
  • Navigate IE to page, login if necessary
  • Fill in form values
  • Submit form
  • Process next Excel row

As you can see ther are a lot of bits needed, none of which are too complicated but a lot to learn if not used before. Check Google.groups and other posts here for examples of automating Internet Explorer and Excel via script.


--

Joe (Microsoft MVP - XML)
 
Old January 8th, 2005, 02:53 PM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks... and before i go out and start looking. do you know any off the top of your head? and could you or willing to help me?!

tia.

mike





Similar Threads
Thread Thread Starter Forum Replies Last Post
excel write to web java applet form mlov83 Excel VBA 0 April 30th, 2008 12:26 PM
Mail Merge in Web aspBegineer83 ASP.NET 2.0 Basics 12 January 4th, 2008 06:00 PM
Merge to word from excel Kevinsharrison Access VBA 1 April 26th, 2005 07:40 AM
Capturing Javascript form via Excel web query helentoomik Javascript 3 November 25th, 2004 12:19 PM
merging data from web form to excel spreadsheet fmh002 Classic ASP Basics 1 June 30th, 2003 04:53 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.