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.
10  23343  Banfa 9,065
Recognized Expert Moderator Expert
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.
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.
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 9,065
Recognized Expert Moderator Expert
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.
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...
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?
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
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.
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.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: cv |
last post by:
Hi all,
I have to copy two set of data from 2 files(notepad/excel) say,
products and their corresponding prices to list/textarea/table. I
should be able to retrieve the product and corresponding price
information from the control(list/textarea/table). Which is the best
way? Quite urgent.. pls let me know.
TIA, cv
|
by: NK |
last post by:
Hi,
We have a webpage that has a form available on the intranet.
A user will have a window open that runs a different application open.
When the user accesses the webpage and clicks a button we should
capture the data from the application window and populate the form.
Is it possible to access text inside another opened window on the...
|
by: Liz |
last post by:
Hi! I have a .Net webpage that displays data in some datagrids populated
based on user search criteria. There is a button, that when clicked, the
data is exported to excel. For one user, I am seeing that it works
correctly the first time he tries the report, but if he reruns the
result set or even picks a different report, the web page itself...
|
by: Ben |
last post by:
Hi,
Can you display data, for example datagrid, in a "Formatted Excel Form"
dynamically?
I mean the data in datagrid will be display on the webpage as Full Formatted
Excel like frame, different font styles, formatted column header, colors...
Please show me how or any information related.
Thank you,
|
by: lgbjr |
last post by:
Hello All,
I¡¯m using a context menu associated with some pictureboxes to provide
copy/paste functionality. Copying the image to the clipboard was easy. But
pasting an image from the clipboard is proving to be more difficult. These
pictureboxes are bound to an AccessDB. If the user wants to add an image,
they select an image using an...
| | |
by: CGW |
last post by:
I asked the question yesterday, but know better how to ask it, today:
I'm trying to use the File.Copy method to copy a file from a client to
server (.Net web app under IIS ). It looks to me that when I
give a path like @"C:\holdfiles\myfile.txt" it looks on the server C drive.
How do I pull from the client? Do I need a different class and/or...
|
by: Herbert Chan |
last post by:
Hello,
I'm subscribing to funds on HSBC, and the fund prices can be found here:
http://www.tools.hsbc.com.hk/search/mpf?id=hk+mpf+fundsearch&lang=en&init=true
At the moment, I'm copying each day's data into an excel spreadsheet (I'm
using the query function of excel to automatically extract the data from the
webpage). So now, the Access...
|
by: anusow |
last post by:
hello iam new to java can any one help me in extacting data from a webpage when i click on link in the page .the data has to be in the form of Excel sheet.
|
by: umeshchitta |
last post by:
Hi ALL,
I written code to download data in Excel from webpage in PLSQL.
i have used owa_util.mime_header to write data in excel.But if data cmng from db table is "32E104" then data in Excel appears as "3.2E+104" in exponential form..Can anybody help me out with this issue.
Thanks
Umesh
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
