Jscript/ActiveXObject API question
Messages   Related Types
This message was discovered on microsoft.public.dotnet.languages.jscript.

Post a new message to this list...

anonymous@discussions.microsoft.com
I understand how I can communicate with Excel
from with a Jscript (see example below.
But where is the documentation (API) of what messages I
can send to such an instance ExcelSheet

var ExcelSheet;
ExcelApp = new ActiveXObject("Excel.Application");
ExcelSheet = new ActiveXObject("Excel.Sheet");

// Make Excel visible through the Application object.
ExcelSheet.Application.Visible = true;
// Place some text in the first cell of the sheet.
ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column
A, row 1";
// Save the sheet.
ExcelSheet.SaveAs("C:\\Temp\\TEST.XLS");
// Close Excel with the Quit method on the Application
object.
ExcelSheet.Application.Quit();
Reply to this message...
 
    
Martin Honnen
Click here to reveal e-mail address wrote:

[Original message clipped]

If you have Excel try its help section, it should documentate the API,
using VBA but the properties and methods of course apply to JScript as well.

--

    Martin Honnen
    http://JavaScript.FAQTs.com/

Reply to this message...
 
 




Ad
MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
 
 Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com