javascript - excel application methods and properties via activexobject - Stack Overflow

admin管理员组

文章数量:1356253

is there a list of methods and properties that an excel object created via

new ActiveXObject("Excel.Application");

has?

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

is there a list of methods and properties that an excel object created via

new ActiveXObject("Excel.Application");

has?

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

• javascript

Share Improve this question Follow asked Mar 20, 2012 at 1:49 user582485user582485 54933 gold badges1515 silver badges2424 bronze badges 3

• You could always print them: for (var key in excel) { document.body.innerHTML += key + "<br />"; } – aroth Commented Mar 20, 2012 at 2:02
• Try this : msdn.microsoft./en-us/library/ie/7sw4ddf8(v=vs.94).aspx – DayTimeCoder Commented Feb 8, 2013 at 16:44
• 1 @aroth Since the objects created via ActiveXObject aren't standard Javascript objects, you cannot iterate over them in this way. – Zev Spitz Commented Jun 13, 2018 at 11:11

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 5

The Excel object model is fully documented on MSDN. Here is the Excel 2010 Application object. Use the links in the left navigator to view properties and members.

http://msdn.microsoft./en-us/library/ff194565.aspx

Move up the navigator tree to Reference to see all the objects.

http://msdn.microsoft./en-us/library/ff846392.aspx

In addition to the Microsoft documentation, there are also Typescript definitions for Excel available on DefinitelyTyped.

You can use an editor like VS Code that can leverage Typescript definitions in Javascript to get Intellisense for these types in Javascript.

(Disclaimer: I am the author of the Typescript definitions for Excel.)

本文标签： javascriptexcel application methods and properties via activexobjectStack Overflow