• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Updating an excel spreadsheet in a frames environment

Hello experts,

This is a bit of an odd question so bear with me.  I wasn't sure which language would
be the best to do this in, so I posted this here.  I have a webpage set up in frames:


In frame B, I've loaded an excel spreadsheet.  In frame A, I have
simple window that allows the user to enter a single value and submit it.
What I need to do is take the value the user submits from frame A, and enter it into
a cell in the excel spreadsheet in frame B.  That's it.  

I realize the user 'could' just alter the value in the spreadsheet directly in frame b.
However, I'm simplifying the question a little.  This question is a small part of a larger application,
and the people I'm building it for want the top frame for workers to use, and bottom frame
for viewing only.  Gotta give 'em what they want.

Many thanks,

1 Solution
This is rather difficult to do but more information might give us a idea if it is actually possible.

What server is this on...
What coding language are you using...
What browser is being used...
GRCHELPDESKAuthor Commented:
Thanks for the response.

Right now everything is coded in HTML.  It's really just one frame with an excel spreadsheet, and one with a text box and submit button.  I have a good understanding of ASP, and a bit in Javascript... but I'm not entirely sure where to start with
this or even if it's possible in those languages.  The browser that will support the application is Internet Explorer 6.
I'm not sure what you mean by the type of server, but it's a Compac Proliant with Windows 2000 server running IIS.
While the demonstration code is in ASP.NET, the rest of this page should be informative:

basically you end up using the spreadsheet as a datasource for an adodb.connection and you can select and insert data (but not delete) using sql commands.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now