pywin32-excel-docs

Excel COM API Reference Skill

This skill provides an API reference for Microsoft Excel COM objects accessed via pywin32. It is primarily intended for use with the PyXLL Excel add-in, but applies equally to any Python code that drives Excel via COM.

Prerequisite: PyXLL Code

BEFORE writing any code that uses a PyXLL decorator, function, or config key (@xl_func, @xl_menu, @xl_macro, xl_app, pyxll.cfg, etc.) — invoke the fetch-pyxll-docs skill using the Skill tool. Do this before writing any code. PyXLL APIs are not covered by this skill; the live docs are the only authoritative source.

Rules for AI Agents

These rules are mandatory. Follow them before writing any Excel COM code.

1. Always read the relevant reference file before using any Excel COM class. Do not rely on training-data knowledge of the Excel COM API — method signatures, parameter names, and property types must be verified from the resources/ docs. The API is large and easy to misremember.

2. Before using any class, look it up in resources/index.md to find which file covers it, then read its section in that file. At minimum, check: which members are properties vs methods vs property accessors, and what the parameter names and types are.

3. Never guess a method or property name. If you cannot find a member in the docs, say so rather than inventing one. COM errors from wrong names surface only at runtime.

4. Property accessors (GetX / SetX) must be called as methods, not accessed as attributes. They appear under "Property Accessors" in the docs. Example: rng.GetOffset(1, 0) — NOT rng.Offset.

5. Always use win32com.client.constants.<name> for enum/constant values. Never use bare integer literals for constants. The constant name (e.g. xlCenter) is the authoritative identifier; its integer value can change across Excel versions. The integer values in resources/enums_xl.md are for reference only — use the named constant, not the number.