Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can you populate a form fields on a html web page (client side)
with data from an Excel file (CSV). The web page has several text fields for input that I manually populate. I would like to transfer the data into the web form automatically from the CSV file. How can this be done? TIA Jman -- --------------------------------- --- -- - Posted with NewsLeecher v3.7 Final Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
CSV files are not really excel files, they are just ordinary text files. You
can open CSV just like any other text files and read the data. Each line of data has multiple fields seperated by commas and a line return at the end of each line. I don't know webpages that well, but determine if it is easier to just open the CSV as text in HTML or open an excel file and copy a range of data. "jman" wrote: How can you populate a form fields on a html web page (client side) with data from an Excel file (CSV). The web page has several text fields for input that I manually populate. I would like to transfer the data into the web form automatically from the CSV file. How can this be done? TIA Jman -- --------------------------------- --- -- - Posted with NewsLeecher v3.7 Final Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Google for "IE automation VBA"
Eg: http://p2p.wrox.com/topic.asp?TOPIC_ID=43120 Tim "jman" wrote in message ... How can you populate a form fields on a html web page (client side) with data from an Excel file (CSV). The web page has several text fields for input that I manually populate. I would like to transfer the data into the web form automatically from the CSV file. How can this be done? TIA Jman -- --------------------------------- --- -- - Posted with NewsLeecher v3.7 Final Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Linking and Formatting across worksheets to form Summary Page - Only pull/link non-null fields | Excel Worksheet Functions | |||
How to Transfer data from Text Form Fields in MS Word into Excel? | Excel Discussion (Misc queries) | |||
Transfer data to form from Excel range upon loading of form. | Excel Programming | |||
Form 2 Form data transfer | Excel Programming | |||
how do i transfer data from excel to another program | New Users to Excel |