最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

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

programmeradmin0浏览0评论

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
Add a ment  | 

2 Answers 2

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.)

发布评论

评论列表(0)

  1. 暂无评论