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
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.
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 client
pc, using javascript?
|
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...
|
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 OpenFileDialog:
Dim result As DialogResult = Pic_Sel.ShowDialog()
If (result = DialogResult.OK) Then
| |
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,
|
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.
|
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: 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,...
|
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...
| |
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...
|
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...
|
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...
|
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();...
|
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.
| |