Wrox Home  
Search P2P Archive for: Go

  Return to Index  

javascript_howto thread: writing data in XL


Message #1 by "Priya" <priya_sivaraman2001@y...> on Mon, 3 Mar 2003 05:43:21
Hi Majid,
  Thanks a lot the code which u hava sent works fine,thanks

Priya
> Hi Priya,

See if the following example is helpful. Don't forget to complete the 
script
tag..

I am using a value from a text field, however you can pick the value from
other elements as well.


<SCRI__  LANGUAGE="JavaScript">

        function addExcel(){

        var oExApp = new ActiveXObject("Excel.Application");

        var oBook= oExApp.Workbooks.Open("D:/Temp/test.xls");

        oBook.worksheets("sheet1").range("B5") =
document.myform.mytextfiled.value;

        oExApp.visible = true;

}

</SCRIPT>



Majid Qazi









----- Original Message -----
From: "Priya" <priya_sivaraman2001@y...>
To: "JavaScript HowTo" <javascript_howto@p...>
Sent: Monday, March 03, 2003 5:43 AM
Subject: [javascript_howto] writing data in XL


> hai everybody,
> i have a problem.i am able to open XL spread sheet from JavaScript but 
how
> do we write data present in a table into that sheet, on a button click
> event.Can anyone help me out,plz do suggest me a link where i can get
> related info.
>
> Thanks in advance
> Priya
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or
> to unsubscribe send a blank email to



  Return to Index