pyxll/pyxll-agent-skills
A curated collection of Agent Skills for working with PYXLL, to help AI agents write and understand code using the PyXLL Excel add-in.
99
1.56x
Quality
90%
Does it follow best practices?
Impact
100%
1.56xAverage score across 17 eval scenarios
Securityby
Advisory
Suggest reviewing before use
index.mdskills/pywin32-excel-docs/resources/
Excel COM API Reference Index
Microsoft Excel 16.0 Object Library — COM API reference for use with pywin32.
Files
| File | Description | Classes |
|---|---|---|
| application.md | Application | 14 |
| workbook.md | Workbook & Workbooks | 24 |
| worksheet.md | Worksheet & Worksheets | 26 |
| range.md | Range, Names & Cells | 37 |
| formatting.md | Formatting | 36 |
| charts.md | Charts & Chart Objects | 48 |
| pivot.md | PivotTables | 37 |
| shapes.md | Shapes & Drawing | 78 |
| tables.md | Tables (ListObjects) | 23 |
| model.md | Data Model | 29 |
| window.md | Windows & Views | 7 |
| addins.md | Add-ins, Dialogs & Legacy UI | 29 |
| enums_xl.md | Excel Enumerations (Xl* constants) | 280 |
All Classes
| Class | File |
|---|---|
AboveAverage | formatting.md |
Action | addins.md |
Actions | addins.md |
AddIn | addins.md |
AddIns | addins.md |
AddIns2 | addins.md |
Adjustments | shapes.md |
AllowEditRange | workbook.md |
AllowEditRanges | workbook.md |
Application | application.md |
_Application | application.md |
Arc | shapes.md |
Arcs | shapes.md |
Areas | range.md |
Author | addins.md |
AutoCorrect | addins.md |
AutoFilter | worksheet.md |
AutoRecover | application.md |
Axes | charts.md |
Axis | charts.md |
AxisTitle | charts.md |
Border | formatting.md |
Borders | formatting.md |
Button | shapes.md |
Buttons | shapes.md |
CalculatedFields | pivot.md |
CalculatedItems | pivot.md |
CalculatedMember | pivot.md |
CalculatedMembers | pivot.md |
CalloutFormat | shapes.md |
CategoryCollection | charts.md |
CellFormat | formatting.md |
Characters | formatting.md |
Chart | charts.md |
_Chart | charts.md |
ChartArea | charts.md |
ChartCategory | charts.md |
ChartColorFormat | charts.md |
ChartFillFormat | charts.md |
ChartFormat | charts.md |
ChartGroup | charts.md |
ChartGroups | charts.md |
ChartObject | charts.md |
ChartObjects | charts.md |
Charts | charts.md |
ChartSeriesGradientStopData | charts.md |
ChartTitle | charts.md |
ChartView | charts.md |
CheckBox | shapes.md |
CheckBoxes | shapes.md |
ColorFormat | shapes.md |
ColorScale | formatting.md |
ColorScaleCriteria | formatting.md |
ColorScaleCriterion | formatting.md |
ColorStop | formatting.md |
ColorStops | formatting.md |
Comment | range.md |
Comments | range.md |
CommentsThreaded | range.md |
CommentThreaded | range.md |
ConditionValue | formatting.md |
Connections | workbook.md |
ConnectorFormat | shapes.md |
ControlFormat | shapes.md |
Corners | charts.md |
CubeField | pivot.md |
CubeFields | pivot.md |
CustomProperties | range.md |
CustomProperty | range.md |
CustomView | workbook.md |
CustomViews | workbook.md |
Databar | formatting.md |
DataBarBorder | formatting.md |
DataFeedConnection | tables.md |
DataLabel | charts.md |
DataLabels | charts.md |
DataTable | charts.md |
DefaultPivotTableLayoutOptions | addins.md |
DefaultWebOptions | application.md |
Diagram | shapes.md |
DiagramNode | shapes.md |
DiagramNodeChildren | shapes.md |
DiagramNodes | shapes.md |
Dialog | addins.md |
DialogFrame | shapes.md |
Dialogs | addins.md |
DialogSheet | worksheet.md |
DialogSheets | worksheet.md |
DialogSheetView | worksheet.md |
DisplayFormat | formatting.md |
DisplayUnitLabel | charts.md |
DownBars | charts.md |
Drawing | shapes.md |
DrawingObjects | shapes.md |
Drawings | shapes.md |
DropDown | shapes.md |
DropDowns | shapes.md |
DropLines | charts.md |
EditBox | shapes.md |
EditBoxes | shapes.md |
Error | range.md |
ErrorBars | charts.md |
ErrorCheckingOptions | application.md |
Errors | range.md |
FileExportConverter | addins.md |
FileExportConverters | addins.md |
FillFormat | shapes.md |
Filter | worksheet.md |
Filters | worksheet.md |
Floor | charts.md |
Font | formatting.md |
FormatColor | formatting.md |
FormatCondition | formatting.md |
FormatConditions | formatting.md |
FreeformBuilder | shapes.md |
FullSeriesCollection | charts.md |
Global | application.md |
_Global | application.md |
Graphic | shapes.md |
Gridlines | charts.md |
GroupBox | shapes.md |
GroupBoxes | shapes.md |
GroupObject | shapes.md |
GroupObjects | shapes.md |
GroupShapes | shapes.md |
HeaderFooter | addins.md |
HiLoLines | charts.md |
HPageBreak | worksheet.md |
HPageBreaks | worksheet.md |
Hyperlink | range.md |
Hyperlinks | range.md |
Icon | formatting.md |
IconCriteria | formatting.md |
IconCriterion | formatting.md |
IconSet | formatting.md |
IconSetCondition | formatting.md |
IconSets | formatting.md |
Interior | formatting.md |
_IOLEObject | shapes.md |
_IQueryTable | tables.md |
Label | shapes.md |
Labels | shapes.md |
LeaderLines | charts.md |
Legend | charts.md |
LegendEntries | charts.md |
LegendEntry | charts.md |
LegendKey | charts.md |
Line | shapes.md |
LinearGradient | formatting.md |
LineFormat | shapes.md |
Lines | shapes.md |
LinkFormat | shapes.md |
ListBox | shapes.md |
ListBoxes | shapes.md |
ListColumn | tables.md |
ListColumns | tables.md |
ListDataFormat | tables.md |
ListObject | tables.md |
ListObjects | tables.md |
ListRow | tables.md |
ListRows | tables.md |
Mailer | workbook.md |
Menu | addins.md |
MenuBar | addins.md |
MenuBars | addins.md |
MenuItem | addins.md |
MenuItems | addins.md |
Menus | addins.md |
Model | model.md |
Model3DFormat | shapes.md |
ModelChanges | model.md |
ModelColumnChange | model.md |
ModelColumnChanges | model.md |
ModelColumnName | model.md |
ModelColumnNames | model.md |
ModelConnection | model.md |
ModelFormatBoolean | model.md |
ModelFormatCurrency | model.md |
ModelFormatDate | model.md |
ModelFormatDecimalNumber | model.md |
ModelFormatGeneral | model.md |
ModelFormatPercentageNumber | model.md |
ModelFormatScientificNumber | model.md |
ModelFormatWholeNumber | model.md |
ModelMeasure | model.md |
ModelMeasureName | model.md |
ModelMeasureNames | model.md |
ModelMeasures | model.md |
ModelRelationship | model.md |
ModelRelationships | model.md |
ModelTable | model.md |
ModelTableColumn | model.md |
ModelTableColumns | model.md |
ModelTableNameChange | model.md |
ModelTableNameChanges | model.md |
ModelTableNames | model.md |
ModelTables | model.md |
Module | worksheet.md |
Modules | worksheet.md |
ModuleView | worksheet.md |
MultiThreadedCalculation | application.md |
Name | range.md |
NamedSheetView | worksheet.md |
NamedSheetViewCollection | worksheet.md |
Names | range.md |
NegativeBarFormat | formatting.md |
ODBCConnection | tables.md |
ODBCError | tables.md |
ODBCErrors | tables.md |
OLEDBConnection | tables.md |
OLEDBError | tables.md |
OLEDBErrors | tables.md |
OLEFormat | shapes.md |
OLEObject | shapes.md |
_OLEObject | shapes.md |
OLEObjects | shapes.md |
OptionButton | shapes.md |
OptionButtons | shapes.md |
Outline | worksheet.md |
Oval | shapes.md |
Ovals | shapes.md |
Page | addins.md |
Pages | addins.md |
PageSetup | worksheet.md |
Pane | window.md |
Panes | window.md |
Parameter | tables.md |
Parameters | tables.md |
Phonetic | range.md |
Phonetics | range.md |
Picture | shapes.md |
PictureFormat | shapes.md |
Pictures | shapes.md |
PivotAxis | pivot.md |
PivotCache | pivot.md |
PivotCaches | pivot.md |
PivotCell | pivot.md |
PivotField | pivot.md |
PivotFields | pivot.md |
PivotFilter | pivot.md |
PivotFilters | pivot.md |
PivotFormula | pivot.md |
PivotFormulas | pivot.md |
PivotItem | pivot.md |
PivotItemList | pivot.md |
PivotItems | pivot.md |
PivotLayout | pivot.md |
PivotLine | pivot.md |
PivotLineCells | pivot.md |
PivotLines | pivot.md |
PivotTable | pivot.md |
PivotTableChangeList | range.md |
PivotTables | pivot.md |
PivotValueCell | pivot.md |
PlotArea | charts.md |
Point | charts.md |
Points | charts.md |
ProtectedViewWindow | window.md |
ProtectedViewWindows | window.md |
Protection | workbook.md |
PublishedDoc | workbook.md |
PublishedDocs | workbook.md |
PublishObject | workbook.md |
PublishObjects | workbook.md |
Queries | workbook.md |
QueryTable | tables.md |
_QueryTable | tables.md |
QueryTables | tables.md |
QuickAnalysis | range.md |
Range | range.md |
Ranges | range.md |
RecentFile | addins.md |
RecentFiles | addins.md |
Rectangle | shapes.md |
Rectangles | shapes.md |
RectangularGradient | formatting.md |
Research | application.md |
RoutingSlip | workbook.md |
RTD | model.md |
Scenario | workbook.md |
Scenarios | workbook.md |
ScrollBar | shapes.md |
ScrollBars | shapes.md |
Series | charts.md |
SeriesCollection | charts.md |
SeriesGradientStopColorFormat | charts.md |
SeriesLines | charts.md |
ServerViewableItems | workbook.md |
ShadowFormat | shapes.md |
Shape | shapes.md |
ShapeNode | shapes.md |
ShapeNodes | shapes.md |
ShapeRange | shapes.md |
Shapes | shapes.md |
Sheets | worksheet.md |
SheetViews | window.md |
Slicer | pivot.md |
SlicerCache | pivot.md |
SlicerCacheLevel | pivot.md |
SlicerCacheLevels | pivot.md |
SlicerCaches | pivot.md |
SlicerItem | pivot.md |
SlicerItems | pivot.md |
SlicerPivotTables | pivot.md |
Slicers | pivot.md |
SmartTag | range.md |
SmartTagAction | range.md |
SmartTagActions | range.md |
SmartTagOptions | workbook.md |
SmartTagRecognizer | range.md |
SmartTagRecognizers | range.md |
SmartTags | range.md |
Sort | worksheet.md |
SortField | worksheet.md |
SortFields | worksheet.md |
SoundNote | addins.md |
SparkAxes | shapes.md |
SparkColor | shapes.md |
SparkHorizontalAxis | shapes.md |
Sparkline | shapes.md |
SparklineGroup | shapes.md |
SparklineGroups | shapes.md |
SparkPoints | shapes.md |
SparkVerticalAxis | shapes.md |
Speech | application.md |
SpellingOptions | application.md |
Spinner | shapes.md |
Spinners | shapes.md |
Style | formatting.md |
Styles | formatting.md |
Tab | worksheet.md |
TableObject | tables.md |
TableStyle | formatting.md |
TableStyleElement | formatting.md |
TableStyleElements | formatting.md |
TableStyles | formatting.md |
TextBox | shapes.md |
TextBoxes | shapes.md |
TextConnection | tables.md |
TextEffectFormat | shapes.md |
TextFrame | shapes.md |
TextFrame2 | shapes.md |
ThreeDFormat | shapes.md |
TickLabels | charts.md |
TimelineState | pivot.md |
TimelineViewState | pivot.md |
Toolbar | addins.md |
ToolbarButton | addins.md |
ToolbarButtons | addins.md |
Toolbars | addins.md |
Top10 | formatting.md |
TreeviewControl | addins.md |
Trendline | charts.md |
Trendlines | charts.md |
UniqueValues | formatting.md |
UpBars | charts.md |
UsedObjects | application.md |
UserAccess | workbook.md |
UserAccessList | workbook.md |
Validation | range.md |
ValueChange | range.md |
VPageBreak | worksheet.md |
VPageBreaks | worksheet.md |
Walls | charts.md |
Watch | range.md |
Watches | range.md |
WebOptions | application.md |
Window | window.md |
Windows | window.md |
Workbook | workbook.md |
_Workbook | workbook.md |
WorkbookConnection | workbook.md |
WorkbookQuery | workbook.md |
Workbooks | workbook.md |
Worksheet | worksheet.md |
_Worksheet | worksheet.md |
WorksheetDataConnection | tables.md |
WorksheetFunction | application.md |
Worksheets | worksheet.md |
WorksheetView | worksheet.md |
XmlDataBinding | range.md |
XmlMap | range.md |
XmlMaps | range.md |
XmlNamespace | range.md |
XmlNamespaces | range.md |
XmlSchema | range.md |
XmlSchemas | range.md |
XPath | range.md |
Object Hierarchy
Application
└─ Workbooks -> Workbook
├─ Worksheets -> Worksheet
│ ├─ Range (Cells, Rows, Columns, ...)
│ │ ├─ Font, Interior, Borders
│ │ ├─ FormatConditions
│ │ └─ Hyperlinks, Comments, Names
│ ├─ Shapes -> Shape
│ ├─ ListObjects -> ListObject
│ │ ├─ ListColumns, ListRows
│ ├─ PageSetup
│ └─ AutoFilter, Sort
├─ Charts -> Chart
│ ├─ ChartArea, PlotArea
│ ├─ Axes -> Axis
│ ├─ SeriesCollection -> Series
│ └─ Legend
├─ Names (workbook-level named ranges)
└─ PivotCaches -> PivotCache
└─ (PivotTable references)