470,586 Members | 1,324 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,586 developers. It's quick & easy.

how to interact interactive html excell cell in javascript

Hi,

I have an excel sheet with a graph and cells.If i change the value in
the excel cells the graph will reflect.Now i am going to implement this
functionality in html page.I successfully saved this as interactive
html page.Now my requirement changes a bit.The excell cells will not
visible to others.i have a text box,If i change the value in text box
the excel template cell value need to change.

I did the follwing steps for creating interactive html page

1.go to and click save as webpage link

2.selected selection:sheet option button .

3.click the publish button.

Please tell me how to interact the cells in this html page through
javascript.

Thanks,
Srinivas.Meda

Oct 22 '05 #1
2 1784
McA
> I have an excel sheet with a graph and cells.If i change the value in
the excel cells the graph will reflect.Now i am going to implement this
functionality in html page.I successfully saved this as interactive
html page.Now my requirement changes a bit.The excell cells will not
visible to others.i have a text box,If i change the value in text box
the excel template cell value need to change.


In source code You find object element with name Book1_xxxx_WebCalc or
something.
There is two different objects actually, one for workseet and another one
for graph.

So, if you want change some value of workseet object cell, then simply
reference it by object name:
Book1_xxxx_WebCalc.cells(i,j).value=document.yourf orm.yourtextbox.value;

Note that collection cells(i,j) is indexed first (i) by rows and then (j) by
columns. Collection index begins with 1.

Another way is to reference cells by range:
Book1_xxxx_WebCalc.range("A1").value=document.your form.yourtextbox.value;
Oct 22 '05 #2
thank you , its working for me

Oct 24 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mustafa | last post: by
1 post views Thread by Mustafa | last post: by
2 posts views Thread by WJ | last post: by
2 posts views Thread by Dave Ekhaus | last post: by
8 posts views Thread by James Kimble | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.