how to interact interactive html excel cell in javascript

nivas.meda

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

Follow Post Reply

2805

mscir

ni********@gmail.com wrote:

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

Post the html shoing the cells you want to interact with. I'm wondering
if you can give them unique ID's then in the textbox onblur event call a
function that uses the id to change the innerHTML.

Mike

Oct 22 '05 #2

Evertjan.

wrote on 22 okt 2005 in comp.lang.javascript:

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

Please do not multipost, crossposting is preferred if on topic.

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)

Oct 22 '05 #3

srinivas

the object loos like

<object id="Copy of Chart for Website_23902_WebCalc"
codebase="file:msowc.cab#version=9,0,0,6430"
classid="CLSID:0002E510-0000-0000-C000-000000000046" VIEWASTEXT>
<param name="DisplayTitleBar" value="false">
<param name="DataType" value="HTMLData">
<param name="HTMLData" value="<html
xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40&quot... <style
id="Copy of Chart for
Website_23902_Styles">  </style> </head> <body>  <table
x:str border=0 cellpadding=0 cellspacing=0 width=629
style='border-collapse:
collapse;table-layout:fixed;width:472pt'> <col
width=255
style='mso-width-source:userset;mso-width-alt:9325;width:191pt'>
<col width=79
style='mso-width-source:userset;mso-width-alt:2889;width:59pt'>
<col width=64 span=2 style='width:48pt'> <col
width=93
style='mso-width-source:userset;mso-width-alt:3401;width:70pt'>
<col width=74
style='mso-width-source:userset;mso-width-alt:2706;width:56pt'>
<tr height=51 style='height:38.25pt'> <td
class=xl26 width=255 style='width:191pt' x:str="Input
">Input </td> <td class=xl15 width=79
style='width:59pt'></td> <td class=xl15 width=64
style='width:48pt'></td> <td class=xl15 width=64
style='width:48pt'>Year</td> <td class=xl15
width=93 style='width:70pt'>Electricty Cost</td>
<td class=xl30 width=74 style='width:56pt'>After Tax Loan
Payment</td> </tr> <tr height=17
style='height:12.75pt'> <td class=xl15>Average
Monthly Electric Bill</td> <td class=xl22
x:num="200"></td> <td height=17
class=xl15 style='height:12.75pt'></td> <td
class=xl15 x:num="2006"></td> <td
class=xl23 x:num="250"
x:fmla="=B2*1.25"></td> <td class=xl28
x:num="216.9382700907907"
x:fmla="=IF((D2-2006)&lt;$B$7,$B$19+IPMT($B$6,(D2-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
class=xl15 style='height:12.75pt'></td> <td
class=xl22></td> <td
class=xl15></td> <td class=xl15
x:num="2007"
x:fmla="=D2+1"></td> <td class=xl25
x:num="265"
x:fmla="=E2*(1+$B$10)"></td> <td
class=xl28 x:num="218.80947376269731"
x:fmla="=IF((D3-2006)&lt;$B$7,$B$19+IPMT($B$6,(D3-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl26>Constants</td> <td height=17
colspan=2 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2008"
x:fmla="=D3+1"></td> <td class=xl25
x:num="280.9"
x:fmla="=E3*(1+$B$10)"></td> <td
class=xl28 x:num="220.79294965491829"
x:fmla="=IF((D4-2006)&lt;$B$7,$B$19+IPMT($B$6,(D4-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>Price of Electicity</td> <td
class=xl23 x:num="00.2"></td> <td
height=17 class=xl15 style='height:12.75pt'></td>
<td class=xl15 x:num="2009"
x:fmla="=D4+1"></td> <td class=xl25
x:num="297.75400000000008"
x:fmla="=E4*(1+$B$10)"></td> <td
class=xl28 x:num="222.89543410067256"
x:fmla="=IF((D5-2006)&lt;$B$7,$B$19+IPMT($B$6,(D5-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>Interest Rate</td> <td class=xl24
x:num="00.06"></td> <td height=17
class=xl15 style='height:12.75pt'></td> <td
class=xl15 x:num="2010"
x:fmla="=D5+1"></td> <td class=xl25
x:num="315.6192400000001"
x:fmla="=E5*(1+$B$10)"></td> <td
class=xl28 x:num="225.12406761317209"
x:fmla="=IF((D6-2006)&lt;$B$7,$B$19+IPMT($B$6,(D6-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>Term (years)</td> <td class=xl15
x:num="20"></td> <td height=17
class=xl15 style='height:12.75pt'></td> <td
class=xl15 x:num="2011"
x:fmla="=D6+1"></td> <td class=xl25
x:num="334.5563944000001"
x:fmla="=E6*(1+$B$10)"></td> <td
class=xl28 x:num="227.48641913642157"
x:fmla="=IF((D7-2006)&lt;$B$7,$B$19+IPMT($B$6,(D7-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>System Cost (/W AC)</td> <td
class=xl25 x:num="9"></td> <td
height=17 class=xl15 style='height:12.75pt'></td>
<td class=xl15 x:num="2012"
x:fmla="=D7+1"></td> <td class=xl25
x:num="354.62977806400011"
x:fmla="=E7*(1+$B$10)"></td> <td
class=xl28 x:num="229.99051175106604"
x:fmla="=IF((D8-2006)&lt;$B$7,$B$19+IPMT($B$6,(D8-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>Production (kWh / W AC)</td> <td
class=xl29 x:num="1.8"></td> <td
height=17 class=xl15 style='height:12.75pt'></td>
<td class=xl15 x:num="2013"
x:fmla="=D8+1"></td> <td class=xl25
x:num="375.90756474784013"
x:fmla="=E8*(1+$B$10)"></td> <td
class=xl28 x:num="232.64484992258917"
x:fmla="=IF((D9-2006)&lt;$B$7,$B$19+IPMT($B$6,(D9-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>Electricity Price Inflation</td> <td
class=xl24 x:num="00.06"></td> <td
height=17 class=xl15 style='height:12.75pt'></td>
<td class=xl15 x:num="2014"
x:fmla="=D9+1"></td> <td class=xl25
x:num="398.46201863271057"
x:fmla="=E9*(1+$B$10)"></td> <td
class=xl28 x:num="235.45844838440368"
x:fmla="=IF((D10-2006)&lt;$B$7,$B$19+IPMT($B$6,(D10-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>Rebate</td> <td class=xl25
x:num="2.8"></td> <td height=17
class=xl15 style='height:12.75pt'></td> <td
class=xl15 x:num="2015"
x:fmla="=D10+1"></td> <td class=xl25
x:num="422.3697397506732"
x:fmla="=E10*(1+$B$10)"></td> <td
class=xl28 x:num="238.44086275392706"
x:fmla="=IF((D11-2006)&lt;$B$7,$B$19+IPMT($B$6,(D11-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>Tax Credit</td> <td class=xl28
x:num="2000"></td> <td height=17
class=xl15 style='height:12.75pt'></td> <td
class=xl15 x:num="2016"
x:fmla="=D11+1"></td> <td class=xl25
x:num="447.71192413571362"
x:fmla="=E11*(1+$B$10)"></td> <td
class=xl28 x:num="241.60222198562184"
x:fmla="=IF((D12-2006)&lt;$B$7,$B$19+IPMT($B$6,(D12-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>Marginal Tax Rate</td> <td class=xl24
x:num="00.35"></td> <td height=17
class=xl15 style='height:12.75pt'></td> <td
class=xl15 x:num="2017"
x:fmla="=D12+1"></td> <td class=xl25
x:num="474.57463958385648"
x:fmla="=E12*(1+$B$10)"></td> <td
class=xl28 x:num="244.95326277121833"
x:fmla="=IF((D13-2006)&lt;$B$7,$B$19+IPMT($B$6,(D13-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2018"
x:fmla="=D13+1"></td> <td class=xl25
x:num="503.0491179588879"
x:fmla="=E13*(1+$B$10)"></td> <td
class=xl28 x:num="248.5053660039506"
x:fmla="=IF((D14-2006)&lt;$B$7,$B$19+IPMT($B$6,(D14-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl26>Intermediate Calculations</td> <td
height=17 colspan=2 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2019"
x:fmla="=D14+1"></td> <td class=xl25
x:num="533.2320650364212"
x:fmla="=E14*(1+$B$10)"></td> <td
class=xl28 x:num="252.27059543064684"
x:fmla="=IF((D15-2006)&lt;$B$7,$B$19+IPMT($B$6,(D15-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>Requried System Size (W AC)</td> <td
class=xl27 x:num="6666.6666666666661"
x:fmla="=$B$2/$B$5*12/$B$9"></td> <td
height=17 class=xl15 style='height:12.75pt'></td>
<td class=xl15 x:num="2020"
x:fmla="=D15+1"></td> <td class=xl25
x:num="565.22598893860652"
x:fmla="=E15*(1+$B$10)"></td> <td
class=xl28 x:num="256.26173862294479"
x:fmla="=IF((D16-2006)&lt;$B$7,$B$19+IPMT($B$6,(D16-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>System Cost</td> <td class=xl28
x:num="60000"
x:fmla="=$B$16*$B$8"></td> <td
height=17 class=xl15 style='height:12.75pt'></td>
<td class=xl15 x:num="2021"
x:fmla="=D16+1"></td> <td class=xl25
x:num="599.13954827492296"
x:fmla="=E16*(1+$B$10)"></td> <td
class=xl28 x:num="260.49235040678064"
x:fmla="=IF((D17-2006)&lt;$B$7,$B$19+IPMT($B$6,(D17-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>System Cost After Rebate and Tax
Credit</td> <td class=xl28
x:num="39333.333333333328"
x:fmla="=$B$17-$B$11*$B$16-$B$12"></td>
<td height=17 class=xl15
style='height:12.75pt'></td> <td class=xl15
x:num="2022"
x:fmla="=D17+1"></td> <td class=xl25
x:num="635.08792117141832"
x:fmla="=E17*(1+$B$10)"></td> <td
class=xl28 x:num="264.97679889764663"
x:fmla="=IF((D18-2006)&lt;$B$7,$B$19+IPMT($B$6,(D18-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>Monthly Payment</td> <td class=xl28
x:num="285.77160342412401"
x:fmla="=-PMT($B$6,$B$7,$B$18)/12"></td>
<td height=17 class=xl15
style='height:12.75pt'></td> <td class=xl15
x:num="2023"
x:fmla="=D18+1"></td> <td class=xl25
x:num="673.19319644170344"
x:fmla="=E18*(1+$B$10)"></td> <td
class=xl28 x:num="269.73031429796458"
x:fmla="=IF((D19-2006)&lt;$B$7,$B$19+IPMT($B$6,(D19-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td
class=xl15>After Tax Monthly Payment (Year 1)</td>
<td class=xl28 x:num="216.9382700907907"
x:fmla="=$B$19+IPMT($B$10,1,$B$7,$B$18)*$B$13/12"></td>
<td height=17 class=xl15
style='height:12.75pt'></td> <td class=xl15
x:num="2024"
x:fmla="=D19+1"></td> <td class=xl25
x:num="713.58478822820564"
x:fmla="=E19*(1+$B$10)"></td> <td
class=xl28 x:num="274.76904062230165"
x:fmla="=IF((D20-2006)&lt;$B$7,$B$19+IPMT($B$6,(D20-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2025"
x:fmla="=D20+1"></td> <td class=xl25
x:num="756.39987552189802"
x:fmla="=E20*(1+$B$10)"></td> <td
class=xl28 x:num="280.11009052609887"
x:fmla="=IF((D21-2006)&lt;$B$7,$B$19+IPMT($B$6,(D21-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2026"
x:fmla="=D21+1"></td> <td class=xl25
x:num="801.7838680532119"
x:fmla="=E21*(1+$B$10)"></td> <td
class=xl28 x:num="0"
x:fmla="=IF((D22-2006)&lt;$B$7,$B$19+IPMT($B$6,(D22-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2027"
x:fmla="=D22+1"></td> <td class=xl25
x:num="849.89090013640464"
x:fmla="=E22*(1+$B$10)"></td> <td
class=xl28 x:num="0"
x:fmla="=IF((D23-2006)&lt;$B$7,$B$19+IPMT($B$6,(D23-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2028"
x:fmla="=D23+1"></td> <td class=xl25
x:num="900.884354144589"
x:fmla="=E23*(1+$B$10)"></td> <td
class=xl28 x:num="0"
x:fmla="=IF((D24-2006)&lt;$B$7,$B$19+IPMT($B$6,(D24-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2029"
x:fmla="=D24+1"></td> <td class=xl25
x:num="954.93741539326436"
x:fmla="=E24*(1+$B$10)"></td> <td
class=xl28 x:num="0"
x:fmla="=IF((D25-2006)&lt;$B$7,$B$19+IPMT($B$6,(D25-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2030"
x:fmla="=D25+1"></td> <td class=xl25
x:num="1012.2336603168603"
x:fmla="=E25*(1+$B$10)"></td> <td
class=xl28 x:num="0"
x:fmla="=IF((D26-2006)&lt;$B$7,$B$19+IPMT($B$6,(D26-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2031"
x:fmla="=D26+1"></td> <td class=xl25
x:num="1072.967679935872"
x:fmla="=E26*(1+$B$10)"></td> <td
class=xl28 x:num="0"
x:fmla="=IF((D27-2006)&lt;$B$7,$B$19+IPMT($B$6,(D27-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2032"
x:fmla="=D27+1"></td> <td class=xl25
x:num="1137.3457407320243"
x:fmla="=E27*(1+$B$10)"></td> <td
class=xl28 x:num="0"
x:fmla="=IF((D28-2006)&lt;$B$7,$B$19+IPMT($B$6,(D28-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2033"
x:fmla="=D28+1"></td> <td class=xl25
x:num="1205.5864851759459"
x:fmla="=E28*(1+$B$10)"></td> <td
class=xl28 x:num="0"
x:fmla="=IF((D29-2006)&lt;$B$7,$B$19+IPMT($B$6,(D29-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2034"
x:fmla="=D29+1"></td> <td class=xl25
x:num="1277.9216742865026"
x:fmla="=E29*(1+$B$10)"></td> <td
class=xl28 x:num="0"
x:fmla="=IF((D30-2006)&lt;$B$7,$B$19+IPMT($B$6,(D30-2005),$B$7,$B$18)/12*$B$13,
0)"></td> </tr> <tr
height=17 style='height:12.75pt'> <td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'></td>
<td class=xl15 x:num="2035"
x:fmla="=D30+1"></td> <td class=xl25
x:num="1354.5969747436927"
x:fmla="=E30*(1+$B$10)"></td> <td
class=xl28 x:num="0"
x:fmla="=IF((D31-2006)&lt;$B$7,$B$19+IPMT($B$6,(D31-2005),$B$7,$B$18)/12*$B$13,
0)"></td>
</tr> </table> </body> </html> ">
</object>

my requirement is how to change a cell value in this object through
javascript.Please send me the javascript code to change the cell value

Thanks,
Srinivas.M

Oct 22 '05 #4

srinivas

Hi,

Evertjan thanks for responding i posted the object code and what i
required.Please tell me how to access that interactive html excel
object through javascript.

Thanks,
Srinivas

Oct 22 '05 #5

srinivas

Hi mscir,

Thanks for responding for my question.the requirement
is how to access the interactive html workbook object from javascript.

Thanks,
Srinivas

Oct 22 '05 #6

how to interact interactive html excel cell in javascript

This discussion thread is closed

Similar topics