Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Javascript > how to interact interactive html excel cell in javascript

Reply
Thread Tools

how to interact interactive html excel cell in javascript

 
 
nivas.meda@gmail.com
Guest
Posts: n/a
 
      10-22-2005
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

 
Reply With Quote
 
 
 
 
mscir
Guest
Posts: n/a
 
      10-22-2005
http://www.velocityreviews.com/forums/(E-Mail Removed) 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
 
Reply With Quote
 
 
 
 
Evertjan.
Guest
Posts: n/a
 
      10-22-2005
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)

 
Reply With Quote
 
srinivas
Guest
Posts: n/a
 
      10-22-2005
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=&quot;urn:schemas-microsoft-comfficeffice&quot; xmlns=&quot;urn:schemas-microsoft-comffice:excel&quot; xmlns=&quot;http://www.w3.org/TR/REC-html40&quot;&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;xrotectContents&gt;False&lt;/xrotectContents&gt;
&lt;xrotectObjects&gt;False&lt;/xrotectObjects&gt;
&lt;xrotectScenarios&gt;False&lt;/xrotectScenarios&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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1*$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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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$1/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

 
Reply With Quote
 
srinivas
Guest
Posts: n/a
 
      10-22-2005
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

 
Reply With Quote
 
srinivas
Guest
Posts: n/a
 
      10-22-2005
Hi mscir,

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

Thanks,
Srinivas

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
how to interact interactive html excell cell in javascript nivas.meda@gmail.com Javascript 1 10-24-2005 04:16 AM
Interactive/Non-interactive ASPX ? WJ ASP .Net 2 02-26-2005 02:54 AM
non Interactive and Interactive AAH Computer Support 0 01-09-2005 04:09 PM
Interactive and non interactive AAH Computer Support 1 01-09-2005 04:01 PM



Advertisments