how to interact interactive html excel cell in javascript

N

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
 
M

mscir

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
Click to expand...

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
 
E

Evertjan.

wrote on 22 okt 2005 in comp.lang.javascript:
Please tell me how to interact the cells in this html page through
javascript.
Click to expand...

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

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="&lt;html
xmlns:v=&quot;urn:schemas-microsoft-com:vml&quot;
xmlns:eek:=&quot;urn:schemas-microsoft-com:eek:ffice:eek:ffice&quot;
xmlns:x=&quot;urn:schemas-microsoft-com:eek:ffice:excel&quot;
xmlns=&quot;http://www.w3.org/TR/REC-html40&quot;&gt;

&lt;head&gt;
&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
 
S

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
 
S

srinivas

Hi mscir,

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

Thanks,
Srinivas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to interact interactive html excell cell in javascript 1
I want to Display Excel As HTML In js 2
Canvas drawing HTML Javascript on elementor 1
Collect Excel Data from Website 5
How to create a JSON array with values from DOM(HTML TABLE) when I click a button using JQuery/Javascript? 0
I want to make such a page in which i can put my excel file. 1
How to create a JSON array with values from DOM(HTML TABLE) when I click a button using JQuery/Javascript? 0
How to have two html audio players on one page? 0

Members online

No members online now.
Total: 42 (members: 1, guests: 41)
Robots: 106

Forum statistics

Threads
473,997
Messages
2,570,240
Members
46,830
Latest member
HeleneMull

Latest Threads

Top