473,698 Members | 2,574 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to copy data from excel to webpage form?

19 New Member
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.
Jul 24 '06
10 23378
iceman81
1 New Member
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.
Feb 7 '08 #11

Sign in to post your reply or Sign up for a free account.

Similar topics

3
9552
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
5
5716
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 client pc, using javascript?
0
1178
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 is exported to excel and not the data. He has the same Excel version as others (Excel 2003) who...
0
1773
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,
7
11624
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 OpenFileDialog: Dim result As DialogResult = Pic_Sel.ShowDialog() If (result = DialogResult.OK) Then
9
2413
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 method? Filestream? -- Thanks,
1
1708
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 form containing the graph gets data from the excel spreadsheet.
2
2592
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.
2
3105
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
0
8610
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9170
Oralloy
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9031
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8873
tracyyun
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7740
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5862
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4623
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3052
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
2
2339
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.