473,883 Members | 2,177 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to interact interactive html excel 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
5 2938
ni********@gmai l.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
wrote on 22 okt 2005 in comp.lang.javas cript:
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
the object loos like

<object id="Copy of Chart for Website_23902_W ebCalc"
codebase="file: msowc.cab#versi on=9,0,0,6430"
classid="CLSID: 0002E510-0000-0000-C000-000000000046" VIEWASTEXT>
<param name="DisplayTi tleBar" value="false">
<param name="DataType" value="HTMLData ">
<param name="HTMLData" value="&lt;html
xmlns:v=&quot;u rn:schemas-microsoft-com:vml&quot; xmlns:o=&quot;u rn:schemas-microsoft-com:office:offi ce&quot; xmlns :x=&quot;urn:sc hemas-microsoft-com:office:exce l&quot; xmlns= &quot;http://www.w3.org/TR/REC-html40&quot... &lt;style
id=&quot;Copy of Chart for
Website_23902_S tyles&quot;&gt; &lt;!--table {mso-displayed-decimal-separator:&quot ;\.&quot;; ms o-displayed-thousand-separator:&quot ;\,&quot;;} tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} .xl15 {mso-style-parent:style0; color:windowt ext; font-size:10.0pt; font-weight:400; f ont-style:normal; text-decoration:none ; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; ms o-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:lock ed
visible; whit e-space:nowrap; mso-rotate:0;} .xl 22 {mso-style-parent:style0; color:windowt ext; font-size:10.0pt; font-weight:400; f ont-style:normal; text-decoration:none ; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; ms o-number-format:&quot;\0 022$\0022\#\,\# \#0_\)\;\[Red\]\\\(\0022$\0022 \#\,\#\#0\\\)&q uot;; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:lock ed
visible; whit e-space:nowrap; mso-rotate:0;} .xl 23 {mso-style-parent:style0; color:windowt ext; font-size:10.0pt; font-weight:400; f ont-style:normal; text-decoration:none ; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; ms o-number-format:&quot;\0 022$\0022\#\,\# \#0\.00_\)\;\[Red\]\\\(\0022$\0022 \#\,\#\#0\.00\\ \)&quot;; tex t-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:lock ed
visible; whit e-space:nowrap; mso-rotate:0;} .xl 24 {mso-style-parent:style0; color:windowt ext; font-size:10.0pt; font-weight:400; f ont-style:normal; text-decoration:none ; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; ms o-number-format:0%; te xt-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:lock ed
visible; whit e-space:nowrap; mso-rotate:0;} .xl 25 {mso-style-parent:style0; color:windowt ext; font-size:10.0pt; font-weight:400; f ont-style:normal; text-decoration:none ; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; ms o-number-format:&quot;_\ (\0022$\0022*
\#\,\#\#0\.00_\ )\;_\(\0022$\00 22*
\\\(\#\,\#\#0\. 00\\\)\;_\(\002 2$\0022*
\0022-\0022??_\)\;_\( \@_\)&quot;; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:lock ed
visible; whit e-space:nowrap; mso-rotate:0;} .xl 26 {mso-style-parent:style0; color:windowt ext; font-size:10.0pt; font-weight:400; f ont-style:normal; text-decoration:unde rline; text-underline-style:single; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; ms o-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:lock ed
visible; whit e-space:nowrap; mso-rotate:0;} .xl 27 {mso-style-parent:style0; color:windowt ext; font-size:10.0pt; font-weight:400; f ont-style:normal; text-decoration:none ; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; ms o-number-format:0; tex t-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:lock ed
visible; whit e-space:nowrap; mso-rotate:0;} .xl 28 {mso-style-parent:style0; color:windowt ext; font-size:10.0pt; font-weight:400; f ont-style:normal; text-decoration:none ; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; ms o-number-format:&quot;_\ (\0022$\0022*
\#\,\#\#0_\)\;_ \(\0022$\0022* \\\(\#\,\#\#0\\ \)\;_\(\0022$\0 022*
\0022-\0022_\)\;_\(\@ _\)&quot;; te xt-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:lock ed
visible; whit e-space:nowrap; mso-rotate:0;} .xl 29 {mso-style-parent:style0; color:windowt ext; font-size:10.0pt; font-weight:400; f ont-style:normal; text-decoration:none ; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; ms o-number-format:&quot;\# \,\#\#0\.000_\) \;\\\(\#\,\#\#0 \.000\\\)&quot; ; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:lock ed
visible; whit e-space:nowrap; mso-rotate:0;} .xl 30 {mso-style-parent:style0; color:windowt ext; font-size:10.0pt; font-weight:400; f ont-style:normal; text-decoration:none ; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; ms o-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:lock ed
visible; whit e-space:normal; mso-rotate:0;} --&gt; &lt;/style&gt; &lt;/head&gt; &lt ;body&gt; &lt; !--[if
gte mso 9]&gt;&lt;xml&gt; &lt;x:ExcelWork book&gt;
&lt;x:Spreadshe etAutoFit/&gt;
&lt;x:MaxHeight &gt;80%&lt;/x:MaxHeight&gt;
&lt;x:MaxWidth& gt;80%&lt;/x:MaxWidth&gt;
&lt;x:ExcelWork sheets&gt;
&lt;x:ExcelWork sheet&gt;
&lt;x:Worksheet Options&gt;
&lt;x:TopRowVis ible&gt;0&lt;/x:TopRowVisible &gt;
&lt;x:LeftColum nVisible&gt;0&l t;/x:LeftColumnVis ible&gt;
&lt;x:ProtectCo ntents&gt;False &lt;/x:ProtectConten ts&gt;
&lt;x:ProtectOb jects&gt;False& lt;/x:ProtectObject s&gt;
&lt;x:ProtectSc enarios&gt;Fals e&lt;/x:ProtectScenar ios&gt;
&lt;/x:WorksheetOpti ons&gt;
&lt;/x:ExcelWorkshee t&gt;
&lt;/x:ExcelWorkshee ts&gt;
&lt;/x:ExcelWorkbook &gt; &lt;/xml&gt;&lt;![endif]--&gt; &lt;tab le
x:str border=0 cellpadding=0 cellspacing=0 width=629
style='border-collapse:
collapse;table-layout:fixed;wi dth:472pt'&gt; &lt;col
width=255
style='mso-width-source:userset; mso-width-alt:9325;width: 191pt'&gt;
&lt;col width=79
style='mso-width-source:userset; mso-width-alt:2889;width: 59pt'&gt;
&lt;col width=64 span=2 style='width:48 pt'&gt; &lt;col
width=93
style='mso-width-source:userset; mso-width-alt:3401;width: 70pt'&gt;
&lt;col width=74
style='mso-width-source:userset; mso-width-alt:2706;width: 56pt'&gt;
&lt;tr height=51 style='height:3 8.25pt'&gt; &lt;td
class=xl26 width=255 style='width:19 1pt' x:str=&quot;Inp ut
&quot;&gt;In put &lt;/td&gt; &lt;td class=xl15 width=79
style='width:59 pt'&gt;&lt;/td&gt; &lt;td class=xl15 width=64
style='width:48 pt'&gt;&lt;/td&gt; &lt;td class=xl15 width=64
style='width:48 pt'&gt;Year&lt;/td&gt; &lt;td class=xl15
width=93 style='width:70 pt'&gt;Electric ty Cost&lt;/td&gt;
&lt;td class=xl30 width=74 style='width:56 pt'&gt;After Tax Loan
Payment&lt;/td&gt; &lt;/tr&gt; &lt;tr height=17
style='height:1 2.75pt'&gt; &lt;td class=xl15&gt;A verage
Monthly Electric Bill&lt;/td&gt; &lt;td class=xl22
x:num=&quot;200 &quot;&gt;&l t;/td&gt; &lt;td height=17
class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;200 6&quot;&gt;&l t;/td&gt; &lt;td
class=xl23 x:num=&quot;250 &quot;
x:fmla=&quot;=B 2*1.25&quot;&gt ;&lt;/td&gt; &lt;td class=xl28
x:num=&quot;216 .9382700907907& quot;
x:fmla=&quot;=I F((D2-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D2-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt; &lt;td
class=xl22&gt;& lt;/td&gt; &lt;td
class=xl15&gt;& lt;/td&gt; &lt;td class=xl15
x:num=&quot;200 7&quot;
x:fmla=&quot;=D 2+1&quot;&gt;&l t;/td&gt; &lt;td class=xl25
x:num=&quot;265 &quot;
x:fmla=&quot;=E 2*(1+$B$10)&quo t;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;218 .80947376269731 &quot;
x:fmla=&quot;=I F((D3-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D3-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl26&gt;C onstants&lt;/td&gt; &lt;td height=17
colspan=2 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;200 8&quot;
x:fmla=&quot;=D 3+1&quot;&gt;&l t;/td&gt; &lt;td class=xl25
x:num=&quot;280 .9&quot;
x:fmla=&quot;=E 3*(1+$B$10)&quo t;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;220 .79294965491829 &quot;
x:fmla=&quot;=I F((D4-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D4-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;P rice of Electicity&lt;/td&gt; &lt;td
class=xl23 x:num=&quot;00. 2&quot;&gt;&l t;/td&gt; &lt;td
height=17 class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;200 9&quot;
x:fmla=&quot;=D 4+1&quot;&gt;&l t;/td&gt; &lt;td class=xl25
x:num=&quot;297 .75400000000008 &quot;
x:fmla=&quot;=E 4*(1+$B$10)&quo t;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;222 .89543410067256 &quot;
x:fmla=&quot;=I F((D5-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D5-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;I nterest Rate&lt;/td&gt; &lt;td class=xl24
x:num=&quot;00. 06&quot;&gt;&lt ;/td&gt; &lt;td height=17
class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;201 0&quot;
x:fmla=&quot;=D 5+1&quot;&gt;&l t;/td&gt; &lt;td class=xl25
x:num=&quot;315 .6192400000001& quot;
x:fmla=&quot;=E 5*(1+$B$10)&quo t;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;225 .12406761317209 &quot;
x:fmla=&quot;=I F((D6-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D6-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;T erm (years)&lt;/td&gt; &lt;td class=xl15
x:num=&quot;20& quot;&gt;&lt;/td&gt; &lt;td height=17
class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;201 1&quot;
x:fmla=&quot;=D 6+1&quot;&gt;&l t;/td&gt; &lt;td class=xl25
x:num=&quot;334 .5563944000001& quot;
x:fmla=&quot;=E 6*(1+$B$10)&quo t;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;227 .48641913642157 &quot;
x:fmla=&quot;=I F((D7-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D7-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;S ystem Cost (/W AC)&lt;/td&gt; &lt;td
class=xl25 x:num=&quot;9&q uot;&gt;&lt;/td&gt; &lt;td
height=17 class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;201 2&quot;
x:fmla=&quot;=D 7+1&quot;&gt;&l t;/td&gt; &lt;td class=xl25
x:num=&quot;354 .62977806400011 &quot;
x:fmla=&quot;=E 7*(1+$B$10)&quo t;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;229 .99051175106604 &quot;
x:fmla=&quot;=I F((D8-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D8-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;P roduction (kWh / W AC)&lt;/td&gt; &lt;td
class=xl29 x:num=&quot;1.8 &quot;&gt;&l t;/td&gt; &lt;td
height=17 class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;201 3&quot;
x:fmla=&quot;=D 8+1&quot;&gt;&l t;/td&gt; &lt;td class=xl25
x:num=&quot;375 .90756474784013 &quot;
x:fmla=&quot;=E 8*(1+$B$10)&quo t;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;232 .64484992258917 &quot;
x:fmla=&quot;=I F((D9-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D9-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;E lectricity Price Inflation&lt;/td&gt; &lt;td
class=xl24 x:num=&quot;00. 06&quot;&gt;&lt ;/td&gt; &lt;td
height=17 class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;201 4&quot;
x:fmla=&quot;=D 9+1&quot;&gt;&l t;/td&gt; &lt;td class=xl25
x:num=&quot;398 .46201863271057 &quot;
x:fmla=&quot;=E 9*(1+$B$10)&quo t;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;235 .45844838440368 &quot;
x:fmla=&quot;=I F((D10-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D10-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;R ebate&lt;/td&gt; &lt;td class=xl25
x:num=&quot;2.8 &quot;&gt;&l t;/td&gt; &lt;td height=17
class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;201 5&quot;
x:fmla=&quot;=D 10+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;422 .3697397506732& quot;
x:fmla=&quot;=E 10*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;238 .44086275392706 &quot;
x:fmla=&quot;=I F((D11-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D11-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;T ax Credit&lt;/td&gt; &lt;td class=xl28
x:num=&quot;200 0&quot;&gt;&l t;/td&gt; &lt;td height=17
class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;201 6&quot;
x:fmla=&quot;=D 11+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;447 .71192413571362 &quot;
x:fmla=&quot;=E 11*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;241 .60222198562184 &quot;
x:fmla=&quot;=I F((D12-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D12-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;M arginal Tax Rate&lt;/td&gt; &lt;td class=xl24
x:num=&quot;00. 35&quot;&gt;&lt ;/td&gt; &lt;td height=17
class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;201 7&quot;
x:fmla=&quot;=D 12+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;474 .57463958385648 &quot;
x:fmla=&quot;=E 12*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;244 .95326277121833 &quot;
x:fmla=&quot;=I F((D13-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D13-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;201 8&quot;
x:fmla=&quot;=D 13+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;503 .0491179588879& quot;
x:fmla=&quot;=E 13*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;248 .5053660039506& quot;
x:fmla=&quot;=I F((D14-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D14-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl26&gt;I ntermediate Calculations&lt ;/td&gt; &lt;td
height=17 colspan=2 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;201 9&quot;
x:fmla=&quot;=D 14+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;533 .2320650364212& quot;
x:fmla=&quot;=E 14*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;252 .27059543064684 &quot;
x:fmla=&quot;=I F((D15-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D15-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;R equried System Size (W AC)&lt;/td&gt; &lt;td
class=xl27 x:num=&quot;666 6.6666666666661 &quot;
x:fmla=&quot;=$ B$2/$B$5*12/$B$9&quot;&gt;& lt;/td&gt; &lt;td
height=17 class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;202 0&quot;
x:fmla=&quot;=D 15+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;565 .22598893860652 &quot;
x:fmla=&quot;=E 15*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;256 .26173862294479 &quot;
x:fmla=&quot;=I F((D16-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D16-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;S ystem Cost&lt;/td&gt; &lt;td class=xl28
x:num=&quot;600 00&quot;
x:fmla=&quot;=$ B$16*$B$8&quot; &gt;&lt;/td&gt; &lt;td
height=17 class=xl15 style='height:1 2.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;202 1&quot;
x:fmla=&quot;=D 16+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;599 .13954827492296 &quot;
x:fmla=&quot;=E 16*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;260 .49235040678064 &quot;
x:fmla=&quot;=I F((D17-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D17-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;S ystem Cost After Rebate and Tax
Credit&lt;/td&gt; &lt;td class=xl28
x:num=&quot;393 33.333333333328 &quot;
x:fmla=&quot;=$ B$17-$B$11*$B$16-$B$12&quot;&gt; &lt;/td&gt;
&lt;td height=17 class=xl15
style='height:1 2.75pt'&gt;&lt;/td&gt; &lt;td class=xl15
x:num=&quot;202 2&quot;
x:fmla=&quot;=D 17+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;635 .08792117141832 &quot;
x:fmla=&quot;=E 17*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;264 .97679889764663 &quot;
x:fmla=&quot;=I F((D18-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D18-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;M onthly Payment&lt;/td&gt; &lt;td class=xl28
x:num=&quot;285 .77160342412401 &quot;
x:fmla=&quot;=-PMT($B$6,$B$7,$ B$18)/12&quot;&gt;&lt ;/td&gt;
&lt;td height=17 class=xl15
style='height:1 2.75pt'&gt;&lt;/td&gt; &lt;td class=xl15
x:num=&quot;202 3&quot;
x:fmla=&quot;=D 18+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;673 .19319644170344 &quot;
x:fmla=&quot;=E 18*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;269 .73031429796458 &quot;
x:fmla=&quot;=I F((D19-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D19-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td
class=xl15&gt;A fter Tax Monthly Payment (Year 1)&lt;/td&gt;
&lt;td class=xl28 x:num=&quot;216 .9382700907907& quot;
x:fmla=&quot;=$ B$19+IPMT($B$10 ,1,$B$7,$B$18)* $B$13/12&quot;&gt;&lt ;/td&gt;
&lt;td height=17 class=xl15
style='height:1 2.75pt'&gt;&lt;/td&gt; &lt;td class=xl15
x:num=&quot;202 4&quot;
x:fmla=&quot;=D 19+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;713 .58478822820564 &quot;
x:fmla=&quot;=E 19*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;274 .76904062230165 &quot;
x:fmla=&quot;=I F((D20-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D20-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;202 5&quot;
x:fmla=&quot;=D 20+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;756 .39987552189802 &quot;
x:fmla=&quot;=E 20*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;280 .11009052609887 &quot;
x:fmla=&quot;=I F((D21-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D21-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;202 6&quot;
x:fmla=&quot;=D 21+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;801 .7838680532119& quot;
x:fmla=&quot;=E 21*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&q uot;
x:fmla=&quot;=I F((D22-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D22-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;202 7&quot;
x:fmla=&quot;=D 22+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;849 .89090013640464 &quot;
x:fmla=&quot;=E 22*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&q uot;
x:fmla=&quot;=I F((D23-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D23-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;202 8&quot;
x:fmla=&quot;=D 23+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;900 .884354144589&q uot;
x:fmla=&quot;=E 23*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&q uot;
x:fmla=&quot;=I F((D24-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D24-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;202 9&quot;
x:fmla=&quot;=D 24+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;954 .93741539326436 &quot;
x:fmla=&quot;=E 24*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&q uot;
x:fmla=&quot;=I F((D25-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D25-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;203 0&quot;
x:fmla=&quot;=D 25+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;101 2.2336603168603 &quot;
x:fmla=&quot;=E 25*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&q uot;
x:fmla=&quot;=I F((D26-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D26-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;203 1&quot;
x:fmla=&quot;=D 26+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;107 2.967679935872& quot;
x:fmla=&quot;=E 26*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&q uot;
x:fmla=&quot;=I F((D27-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D27-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;203 2&quot;
x:fmla=&quot;=D 27+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;113 7.3457407320243 &quot;
x:fmla=&quot;=E 27*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&q uot;
x:fmla=&quot;=I F((D28-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D28-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;203 3&quot;
x:fmla=&quot;=D 28+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;120 5.5864851759459 &quot;
x:fmla=&quot;=E 28*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&q uot;
x:fmla=&quot;=I F((D29-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D29-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;203 4&quot;
x:fmla=&quot;=D 29+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;127 7.9216742865026 &quot;
x:fmla=&quot;=E 29*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&q uot;
x:fmla=&quot;=I F((D30-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D30-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:1 2.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:1 2.75pt;mso-ignore:colspan' &gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;203 5&quot;
x:fmla=&quot;=D 30+1&quot;&gt;& lt;/td&gt; &lt;td class=xl25
x:num=&quot;135 4.5969747436927 &quot;
x:fmla=&quot;=E 30*(1+$B$10)&qu ot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&q uot;
x:fmla=&quot;=I F((D31-2006)&amp;lt;$B $7,$B$19+IPMT($ B$6,(D31-2005),$B$7,$B$1 8)/12*$B$13,
0)&quot;&gt;&lt ;/td&gt;
&lt;/tr&gt; &lt;/table&gt; &l t;/body&gt; &lt ;/html&gt; ">
</object>

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

Thanks,
Srinivas.M

Oct 22 '05 #4
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
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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
5047
by: quikquic | last post by:
If there is javascript in a html file, for example, <html> <body> <script language="JavaScript"> document.write("Hello"); </script> </body> </html>
2
1985
by: nivas.meda | last post by:
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...
0
1721
by: Alan | last post by:
I'm just starting out in C# so this is really a basic question. I have an Excel cell reference for which I need to generate offsets It seems to me that the best way is to start off with a string e.g. "A1" I need to generate an offset such as "C1" or "A5". What would be the best way of doing it? Should I use string.format? Can I something like (Cell + 3) to change "A1" to "D1" ? Thanks
2
2683
by: David Virgil Hobbs | last post by:
Loading text strings containing HTML code into an HTML parser in a Javascript/Jscript I would like to know, how one would go about loading a text string containing HTML code, so as to be able to use javascript or Jscript to work with the HTML code in the text string, in the same way that one works with XML code in a text string using the XML parser. If I was able to load the text string containing the HTML code succesfully, I would be...
0
2235
by: nickyr | last post by:
Hi, I want to get the data from one excel cell to a textbox. Nothing more than that. What I have now is this: Dim myxl As Object Dim strdata As String myxl = GetObject ("d:\test.xls")
0
1403
by: payelit21 | last post by:
Hi Friends, can any body help me to convert excel cell from date to general and passinfg value to min value and max value of axis in chart through VB. Thanks Payel
1
2594
by: datttanand | last post by:
how to add drop down list in excel cell using javascript code?
10
3492
by: paulie | last post by:
Hi, I have been experiencing an issue when trying to use AJAX to reload a DIV area using a timer of 2000ms, which contains a html page with another DIV and javascript. Scenario ------------- I have perl script which simply runs a ps on a Solaris server and generates a static html page with all of the code perfectly and this html page works fine when viewing it statically or with a META REFRESH header tag. The idea is to give the user...
1
4512
by: rameshmandapati | last post by:
hi i have a problem with Excel. iam adding data to a cell in Excel using java script var excel = new ActiveXObject ("Excel.Application"); but i want image also i search in google i didnt find any thing regarding this
0
9798
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
10767
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
10422
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...
1
7980
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7137
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
5807
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6008
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4230
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3242
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.