obaid_shirwani
10 years agoContributor
Unable to find the APIs for COM / Excel
Hi all, I was looking for the API for COM/Excel but with no success. I actually want to know what other functions are exposed and what else can I do with Excel / COM. All the functions I...
- 10 years agoThe Excel COM API reference is here:
Excel developer reference
Excel object model
Sys.OleObject("Excel.Application") returns the Application object. It's the main object, from which you can access all other objects.
Using the COM API, you can do basically anything you can do through Excel's GUI. There're lots of VBScript examples online. Just search for "excel vbscript ...", for example, excel vbscript create chart. Even if you are using another scripting language, these examples can be useful.