473,246 Members | 1,587 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,246 software developers and data experts.

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 2881
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
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
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="&lt;html
xmlns:v=&quot;urn:schemas-microsoft-com:vml&quot; xmlns:o=&quot;urn:schemas-microsoft-com:office:office&quot; xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot; xmlns=&quot;http://www.w3.org/TR/REC-html40&quot... &lt;style
id=&quot;Copy of Chart for
Website_23902_Styles&quot;&gt; &lt;!--table {mso-displayed-decimal-separator:&quot;\.&quot;; mso-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:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked
visible; white-space:nowrap; mso-rotate:0;} .xl22 {mso-style-parent:style0; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:&quot;\0022$\0022\#\,\#\#0_\)\;\[Red\]\\\(\0022$\0022\#\,\#\#0\\\)&quot;; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked
visible; white-space:nowrap; mso-rotate:0;} .xl23 {mso-style-parent:style0; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:&quot;\0022$\0022\#\,\#\#0\.00_\)\;\[Red\]\\\(\0022$\0022\#\,\#\#0\.00\\\)&quot;; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked
visible; white-space:nowrap; mso-rotate:0;} .xl24 {mso-style-parent:style0; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:0%; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked
visible; white-space:nowrap; mso-rotate:0;} .xl25 {mso-style-parent:style0; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:&quot;_\(\0022$\0022*
\#\,\#\#0\.00_\)\;_\(\0022$\0022*
\\\(\#\,\#\#0\.00\\\)\;_\(\0022$\0022*
\0022-\0022??_\)\;_\(\@_\)&quot;; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked
visible; white-space:nowrap; mso-rotate:0;} .xl26 {mso-style-parent:style0; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:underline; text-underline-style:single; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked
visible; white-space:nowrap; mso-rotate:0;} .xl27 {mso-style-parent:style0; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:0; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked
visible; white-space:nowrap; mso-rotate:0;} .xl28 {mso-style-parent:style0; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:&quot;_\(\0022$\0022*
\#\,\#\#0_\)\;_\(\0022$\0022* \\\(\#\,\#\#0\\\)\;_\(\0022$\0022*
\0022-\0022_\)\;_\(\@_\)&quot;; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked
visible; white-space:nowrap; mso-rotate:0;} .xl29 {mso-style-parent:style0; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-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:locked
visible; white-space:nowrap; mso-rotate:0;} .xl30 {mso-style-parent:style0; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked
visible; white-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:ExcelWorkbook&gt;
&lt;x:SpreadsheetAutoFit/&gt;
&lt;x:MaxHeight&gt;80%&lt;/x:MaxHeight&gt;
&lt;x:MaxWidth&gt;80%&lt;/x:MaxWidth&gt;
&lt;x:ExcelWorksheets&gt;
&lt;x:ExcelWorksheet&gt;
&lt;x:WorksheetOptions&gt;
&lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
&lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
&lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
&lt;x:ProtectObjects&gt;False&lt;/x:ProtectObjects&gt;
&lt;x:ProtectScenarios&gt;False&lt;/x:ProtectScenarios&gt;
&lt;/x:WorksheetOptions&gt;
&lt;/x:ExcelWorksheet&gt;
&lt;/x:ExcelWorksheets&gt;
&lt;/x:ExcelWorkbook&gt; &lt;/xml&gt;&lt;![endif]--&gt; &lt;table
x:str border=0 cellpadding=0 cellspacing=0 width=629
style='border-collapse:
collapse;table-layout:fixed;width: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:48pt'&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:38.25pt'&gt; &lt;td
class=xl26 width=255 style='width:191pt' x:str=&quot;Input
&quot;&gt;Input &lt;/td&gt; &lt;td class=xl15 width=79
style='width:59pt'&gt;&lt;/td&gt; &lt;td class=xl15 width=64
style='width:48pt'&gt;&lt;/td&gt; &lt;td class=xl15 width=64
style='width:48pt'&gt;Year&lt;/td&gt; &lt;td class=xl15
width=93 style='width:70pt'&gt;Electricty Cost&lt;/td&gt;
&lt;td class=xl30 width=74 style='width:56pt'&gt;After Tax Loan
Payment&lt;/td&gt; &lt;/tr&gt; &lt;tr height=17
style='height:12.75pt'&gt; &lt;td class=xl15&gt;Average
Monthly Electric Bill&lt;/td&gt; &lt;td class=xl22
x:num=&quot;200&quot;&gt;&lt;/td&gt; &lt;td height=17
class=xl15 style='height:12.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;2006&quot;&gt;&lt;/td&gt; &lt;td
class=xl23 x:num=&quot;250&quot;
x:fmla=&quot;=B2*1.25&quot;&gt;&lt;/td&gt; &lt;td class=xl28
x:num=&quot;216.9382700907907&quot;
x:fmla=&quot;=IF((D2-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D2-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
class=xl15 style='height:12.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;2007&quot;
x:fmla=&quot;=D2+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;265&quot;
x:fmla=&quot;=E2*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;218.80947376269731&quot;
x:fmla=&quot;=IF((D3-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D3-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl26&gt;Constants&lt;/td&gt; &lt;td height=17
colspan=2 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2008&quot;
x:fmla=&quot;=D3+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;280.9&quot;
x:fmla=&quot;=E3*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;220.79294965491829&quot;
x:fmla=&quot;=IF((D4-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D4-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;Price of Electicity&lt;/td&gt; &lt;td
class=xl23 x:num=&quot;00.2&quot;&gt;&lt;/td&gt; &lt;td
height=17 class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2009&quot;
x:fmla=&quot;=D4+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;297.75400000000008&quot;
x:fmla=&quot;=E4*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;222.89543410067256&quot;
x:fmla=&quot;=IF((D5-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D5-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;Interest 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:12.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;2010&quot;
x:fmla=&quot;=D5+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;315.6192400000001&quot;
x:fmla=&quot;=E5*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;225.12406761317209&quot;
x:fmla=&quot;=IF((D6-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D6-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;Term (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:12.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;2011&quot;
x:fmla=&quot;=D6+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;334.5563944000001&quot;
x:fmla=&quot;=E6*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;227.48641913642157&quot;
x:fmla=&quot;=IF((D7-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D7-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;System Cost (/W AC)&lt;/td&gt; &lt;td
class=xl25 x:num=&quot;9&quot;&gt;&lt;/td&gt; &lt;td
height=17 class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2012&quot;
x:fmla=&quot;=D7+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;354.62977806400011&quot;
x:fmla=&quot;=E7*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;229.99051175106604&quot;
x:fmla=&quot;=IF((D8-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D8-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;Production (kWh / W AC)&lt;/td&gt; &lt;td
class=xl29 x:num=&quot;1.8&quot;&gt;&lt;/td&gt; &lt;td
height=17 class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2013&quot;
x:fmla=&quot;=D8+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;375.90756474784013&quot;
x:fmla=&quot;=E8*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;232.64484992258917&quot;
x:fmla=&quot;=IF((D9-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D9-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;Electricity 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:12.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2014&quot;
x:fmla=&quot;=D9+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;398.46201863271057&quot;
x:fmla=&quot;=E9*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;235.45844838440368&quot;
x:fmla=&quot;=IF((D10-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D10-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;Rebate&lt;/td&gt; &lt;td class=xl25
x:num=&quot;2.8&quot;&gt;&lt;/td&gt; &lt;td height=17
class=xl15 style='height:12.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;2015&quot;
x:fmla=&quot;=D10+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;422.3697397506732&quot;
x:fmla=&quot;=E10*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;238.44086275392706&quot;
x:fmla=&quot;=IF((D11-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D11-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;Tax Credit&lt;/td&gt; &lt;td class=xl28
x:num=&quot;2000&quot;&gt;&lt;/td&gt; &lt;td height=17
class=xl15 style='height:12.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;2016&quot;
x:fmla=&quot;=D11+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;447.71192413571362&quot;
x:fmla=&quot;=E11*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;241.60222198562184&quot;
x:fmla=&quot;=IF((D12-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D12-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;Marginal 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:12.75pt'&gt;&lt;/td&gt; &lt;td
class=xl15 x:num=&quot;2017&quot;
x:fmla=&quot;=D12+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;474.57463958385648&quot;
x:fmla=&quot;=E12*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;244.95326277121833&quot;
x:fmla=&quot;=IF((D13-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D13-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2018&quot;
x:fmla=&quot;=D13+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;503.0491179588879&quot;
x:fmla=&quot;=E13*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;248.5053660039506&quot;
x:fmla=&quot;=IF((D14-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D14-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl26&gt;Intermediate Calculations&lt;/td&gt; &lt;td
height=17 colspan=2 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2019&quot;
x:fmla=&quot;=D14+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;533.2320650364212&quot;
x:fmla=&quot;=E14*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;252.27059543064684&quot;
x:fmla=&quot;=IF((D15-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D15-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;Requried System Size (W AC)&lt;/td&gt; &lt;td
class=xl27 x:num=&quot;6666.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:12.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2020&quot;
x:fmla=&quot;=D15+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;565.22598893860652&quot;
x:fmla=&quot;=E15*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;256.26173862294479&quot;
x:fmla=&quot;=IF((D16-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D16-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;System Cost&lt;/td&gt; &lt;td class=xl28
x:num=&quot;60000&quot;
x:fmla=&quot;=$B$16*$B$8&quot;&gt;&lt;/td&gt; &lt;td
height=17 class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2021&quot;
x:fmla=&quot;=D16+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;599.13954827492296&quot;
x:fmla=&quot;=E16*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;260.49235040678064&quot;
x:fmla=&quot;=IF((D17-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D17-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;System Cost After Rebate and Tax
Credit&lt;/td&gt; &lt;td class=xl28
x:num=&quot;39333.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:12.75pt'&gt;&lt;/td&gt; &lt;td class=xl15
x:num=&quot;2022&quot;
x:fmla=&quot;=D17+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;635.08792117141832&quot;
x:fmla=&quot;=E17*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;264.97679889764663&quot;
x:fmla=&quot;=IF((D18-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D18-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;Monthly 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:12.75pt'&gt;&lt;/td&gt; &lt;td class=xl15
x:num=&quot;2023&quot;
x:fmla=&quot;=D18+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;673.19319644170344&quot;
x:fmla=&quot;=E18*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;269.73031429796458&quot;
x:fmla=&quot;=IF((D19-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D19-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td
class=xl15&gt;After 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:12.75pt'&gt;&lt;/td&gt; &lt;td class=xl15
x:num=&quot;2024&quot;
x:fmla=&quot;=D19+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;713.58478822820564&quot;
x:fmla=&quot;=E19*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;274.76904062230165&quot;
x:fmla=&quot;=IF((D20-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D20-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2025&quot;
x:fmla=&quot;=D20+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;756.39987552189802&quot;
x:fmla=&quot;=E20*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;280.11009052609887&quot;
x:fmla=&quot;=IF((D21-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D21-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2026&quot;
x:fmla=&quot;=D21+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;801.7838680532119&quot;
x:fmla=&quot;=E21*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&quot;
x:fmla=&quot;=IF((D22-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D22-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2027&quot;
x:fmla=&quot;=D22+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;849.89090013640464&quot;
x:fmla=&quot;=E22*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&quot;
x:fmla=&quot;=IF((D23-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D23-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2028&quot;
x:fmla=&quot;=D23+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;900.884354144589&quot;
x:fmla=&quot;=E23*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&quot;
x:fmla=&quot;=IF((D24-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D24-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2029&quot;
x:fmla=&quot;=D24+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;954.93741539326436&quot;
x:fmla=&quot;=E24*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&quot;
x:fmla=&quot;=IF((D25-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D25-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2030&quot;
x:fmla=&quot;=D25+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;1012.2336603168603&quot;
x:fmla=&quot;=E25*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&quot;
x:fmla=&quot;=IF((D26-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D26-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2031&quot;
x:fmla=&quot;=D26+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;1072.967679935872&quot;
x:fmla=&quot;=E26*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&quot;
x:fmla=&quot;=IF((D27-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D27-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2032&quot;
x:fmla=&quot;=D27+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;1137.3457407320243&quot;
x:fmla=&quot;=E27*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&quot;
x:fmla=&quot;=IF((D28-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D28-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2033&quot;
x:fmla=&quot;=D28+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;1205.5864851759459&quot;
x:fmla=&quot;=E28*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&quot;
x:fmla=&quot;=IF((D29-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D29-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2034&quot;
x:fmla=&quot;=D29+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;1277.9216742865026&quot;
x:fmla=&quot;=E29*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&quot;
x:fmla=&quot;=IF((D30-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D30-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr
height=17 style='height:12.75pt'&gt; &lt;td height=17
colspan=3 class=xl15
style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;
&lt;td class=xl15 x:num=&quot;2035&quot;
x:fmla=&quot;=D30+1&quot;&gt;&lt;/td&gt; &lt;td class=xl25
x:num=&quot;1354.5969747436927&quot;
x:fmla=&quot;=E30*(1+$B$10)&quot;&gt;&lt;/td&gt; &lt;td
class=xl28 x:num=&quot;0&quot;
x:fmla=&quot;=IF((D31-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D31-2005),$B$7,$B$18)/12*$B$13,
0)&quot;&gt;&lt;/td&gt;
&lt;/tr&gt; &lt;/table&gt; &lt;/body&gt; &lt;/html&gt; ">
</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
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
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
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...
0
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...
2
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...
0
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
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
by: datttanand | last post by:
how to add drop down list in excel cell using javascript code?
10
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 -------------...
1
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...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.