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");
Share
Improve this question
asked Mar 20, 2012 at 1:49
user582485user582485
5493 gold badges15 silver badges24 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
2 Answers
Reset to default 5The 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.)