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
90%
Does it follow best practices?
Impact
100%
1.56xAverage score across 17 eval scenarios
Advisory
Suggest reviewing before use
Properties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index: int) -> Range__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyProperty Accessors (parameterized — must be called as method):
_Default(Index: int) -> RangeItem(Index: int) -> RangeProperties:
Application: ApplicationAuthor: AnyCreator: XlCreatorParent: AnyShape: ShapeVisible: AnyMethods:
Delete() -> NoneNext() -> CommentPrevious() -> CommentText(Text?, Start?, Overwrite?) -> strProperties:
Application: ApplicationAuthor: AuthorCreator: XlCreatorDate: AnyParent: AnyReplies: CommentsThreadedResolved: AnyMethods:
AddReply(Text?) -> CommentThreadedDelete() -> NoneNext() -> CommentThreadedPrevious() -> CommentThreadedText(Text?, Start?, Overwrite?) -> strProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index: int) -> Comment__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyItem(Index: int) -> CommentProperty Accessors (parameterized — must be called as method):
_Default(Index: int) -> CommentProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index: int) -> CommentThreaded__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyItem(Index: int) -> CommentThreadedProperty Accessors (parameterized — must be called as method):
_Default(Index: int) -> CommentThreadedProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index) -> CustomProperty__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyAdd(Name: str, Value) -> CustomPropertyProperty Accessors (parameterized — must be called as method):
_Default(Index) -> CustomPropertyItem(Index) -> CustomPropertyProperties:
Application: ApplicationCreator: XlCreatorName: AnyParent: AnyValue: AnyMethods:
__call__() -> AnyDelete() -> NoneProperties:
Application: ApplicationCreator: XlCreatorIgnore: AnyParent: AnyValue: AnyMethods:
__call__() -> AnyProperties:
Application: ApplicationCreator: XlCreatorParent: AnyMethods:
__call__(Index) -> Error__getitem__(key) -> AnyProperty Accessors (parameterized — must be called as method):
_Default(Index) -> ErrorItem(Index) -> ErrorProperties:
Address: AnyApplication: ApplicationCreator: XlCreatorEmailSubject: AnyName: AnyParent: AnyRange: RangeScreenTip: AnyShape: ShapeSubAddress: AnyTextToDisplay: AnyType: AnyMethods:
AddToFavorites() -> NoneCreateNewDocument(Filename: str, EditNow: bool, Overwrite: bool) -> NoneDelete() -> NoneFollow(NewWindow?, AddHistory?, ExtraInfo?, Method?, HeaderInfo?) -> NoneProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index) -> Hyperlink__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyAdd(Anchor: Dispatch, Address: str, SubAddress?, ScreenTip?, TextToDisplay?) -> DispatchDelete() -> NoneProperty Accessors (parameterized — must be called as method):
_Default(Index) -> HyperlinkItem(Index) -> HyperlinkProperties:
Application: ApplicationCategory: AnyCategoryLocal: AnyComment: AnyCreator: XlCreatorIndex: AnyMacroType: XlXLMMacroTypeName: AnyNameLocal: AnyParent: AnyRefersTo: AnyRefersToLocal: AnyRefersToR1C1: AnyRefersToR1C1Local: AnyRefersToRange: RangeShortcutKey: AnyValidWorkbookParameter: AnyValue: AnyVisible: AnyWorkbookParameter: AnyMethods:
__call__() -> AnyDelete() -> NoneProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index?, IndexLocal?, RefersTo?) -> Name__getitem__(key) -> Any__len__() -> Any__nonzero__() -> Any_Default(Index?, IndexLocal?, RefersTo?) -> NameAdd(Name?, RefersTo?, Visible?, MacroType?, ShortcutKey?, Category?, NameLocal?, RefersToLocal?, CategoryLocal?, RefersToR1C1?, RefersToR1C1Local?) -> NameItem(Index?, IndexLocal?, RefersTo?) -> NameProperties:
Alignment: AnyApplication: ApplicationCharacterType: AnyCreator: XlCreatorFont: FontParent: AnyText: AnyVisible: AnyProperties:
Alignment: AnyApplication: ApplicationCharacterType: AnyCount: AnyCreator: XlCreatorFont: FontLength: AnyParent: AnyStart: AnyText: AnyVisible: AnyMethods:
__call__(Index: int) -> Dispatch__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyAdd(Start: int, Length: int, Text: str) -> NoneDelete() -> NoneProperty Accessors (parameterized — must be called as method):
_Default(Index: int) -> DispatchItem(Index: int) -> DispatchProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index) -> ValueChange__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyAdd(Tuple: str, Value: float, AllocationValue?, AllocationMethod?, AllocationWeightExpression?) -> ValueChangeProperty Accessors (parameterized — must be called as method):
_Default(Index) -> ValueChangeItem(Index) -> ValueChangeProperties:
Application: ApplicationCreator: XlCreatorParent: AnyMethods:
Hide(XlQuickAnalysisMode: XlQuickAnalysisMode?) -> NoneShow(XlQuickAnalysisMode: XlQuickAnalysisMode?) -> NoneProperties:
AddIndent: AnyAddress: AnyAddressLocal: AnyAllowEdit: AnyApplication: ApplicationAreas: AreasBorders: BordersCells: RangeCharacters: CharactersColumn: AnyColumns: RangeColumnWidth: AnyComment: CommentCommentThreaded: CommentThreadedCount: AnyCountLarge: AnyCreator: XlCreatorCurrentArray: RangeCurrentRegion: RangeDependents: RangeDirectDependents: RangeDirectPrecedents: RangeDisplayFormat: DisplayFormatEntireColumn: RangeEntireRow: RangeErrors: ErrorsFont: FontFormatConditions: FormatConditionsFormula: AnyFormula2: AnyFormula2Local: AnyFormula2R1C1: AnyFormula2R1C1Local: AnyFormulaArray: AnyFormulaHidden: AnyFormulaLabel: XlFormulaLabelFormulaLocal: AnyFormulaR1C1: AnyFormulaR1C1Local: AnyHasArray: AnyHasFormula: AnyHasRichDataType: AnyHasSpill: AnyHeight: AnyHidden: AnyHorizontalAlignment: AnyHyperlinks: HyperlinksID: AnyIndentLevel: AnyInterior: InteriorLeft: AnyLinkedDataTypeState: AnyListHeaderRows: AnyListObject: ListObjectLocationInTable: XlLocationInTableLocked: AnyMDX: AnyMergeArea: RangeMergeCells: AnyName: AnyNext: RangeNumberFormat: AnyNumberFormatLocal: AnyOffset: RangeOrientation: AnyOutlineLevel: AnyPageBreak: AnyParent: AnyPhonetic: PhoneticPhonetics: PhoneticsPivotCell: PivotCellPivotField: PivotFieldPivotItem: PivotItemPivotTable: PivotTablePrecedents: RangePrefixCharacter: AnyPrevious: RangeQueryTable: QueryTableReadingOrder: AnyResize: RangeRow: AnyRowHeight: AnyRows: RangeSavedAsArray: AnyServerActions: ActionsShowDetail: AnyShrinkToFit: AnySmartTags: SmartTagsSoundNote: SoundNoteSparklineGroups: SparklineGroupsSpillingToRange: RangeSpillParent: RangeStyle: AnySummary: AnyText: AnyTop: AnyUseStandardHeight: AnyUseStandardWidth: AnyValidation: ValidationValue: AnyValue2: AnyVerticalAlignment: AnyWidth: AnyWorksheet: WorksheetWrapText: AnyXPath: XPathMethods:
__call__(RowIndex?, ColumnIndex?) -> Any__getitem__(key) -> Any__len__() -> Any__nonzero__() -> Any_AutoFilter(Field, Criteria1, Operator: XlAutoFilterOperator?, Criteria2?, VisibleDropDown?) -> Any_BorderAround(LineStyle, Weight: XlBorderWeight?, ColorIndex: XlColorIndex?, Color?) -> Any_ExportAsFixedFormat(Type: XlFixedFormatType, Filename?, Quality?, IncludeDocProperties?, IgnorePrintAreas?, From?, To?, OpenAfterPublish?, FixedFormatExtClassPtr?) -> None_PasteSpecial(Paste: XlPasteType?, Operation: XlPasteSpecialOperation?, SkipBlanks?, Transpose?) -> Any_PrintOut(From?, To?, Copies?, Preview?, ActivePrinter?, PrintToFile?, Collate?, PrToFileName?) -> Any_PrintOut_(From?, To?, Copies?, Preview?, ActivePrinter?, PrintToFile?, Collate?) -> Any_Replace(What, Replacement, LookAt?, SearchOrder?, MatchCase?, MatchByte?, SearchFormat?, ReplaceFormat?) -> bool_Sort(Key1, Order1: XlSortOrder?, Key2, Type, Order2: XlSortOrder?, Key3, Order3: XlSortOrder?, Header: XlYesNoGuess?, OrderCustom, MatchCase, Orientation: XlSortOrientation?, SortMethod: XlSortMethod?, DataOption1: XlSortDataOption?, DataOption2: XlSortDataOption?, DataOption3: XlSortDataOption?) -> AnyActivate() -> AnyAddComment(Text?) -> CommentAddCommentThreaded(Text: str) -> CommentThreadedAdvancedFilter(Action: XlFilterAction, CriteriaRange?, CopyToRange?, Unique?) -> AnyAllocateChanges() -> NoneApplyNames(Names, IgnoreRelativeAbsolute, UseRowColumnNames, OmitColumn, OmitRow, Order: XlApplyNamesOrder?, AppendLast?) -> AnyApplyOutlineStyles() -> AnyAutoComplete(String: str) -> strAutoFill(Destination: Range, Type: XlAutoFillType?) -> AnyAutoFilter(Field, Criteria1, Operator: XlAutoFilterOperator?, Criteria2?, VisibleDropDown?, SubField?) -> AnyAutoFit() -> AnyAutoFormat(Format: XlRangeAutoFormat?, Number?, Font?, Alignment?, Border?, Pattern?, Width?) -> AnyAutoOutline() -> AnyBorderAround(LineStyle, Weight: XlBorderWeight?, ColorIndex: XlColorIndex?, Color?, ThemeColor?) -> AnyCalculate() -> AnyCalculateRowMajorOrder() -> AnyCheckSpelling(CustomDictionary?, IgnoreUppercase?, AlwaysSuggest?, SpellLang?) -> AnyClear() -> AnyClearComments() -> NoneClearContents() -> AnyClearFormats() -> AnyClearHyperlinks() -> NoneClearNotes() -> AnyClearOutline() -> AnyColumnDifferences(Comparison) -> RangeConsolidate(Sources?, Function?, TopRow?, LeftColumn?, CreateLinks?) -> AnyConvertToLinkedDataType(ServiceID: int, LanguageCulture: str) -> NoneCopy(Destination?) -> AnyCopyFromRecordset(Data, MaxRows?, MaxColumns?) -> intCopyPicture(Appearance: XlPictureAppearance?, Format: XlCopyPictureFormat?) -> AnyCreateNames(Top?, Left?, Bottom?, Right?) -> AnyCreatePublisher(Edition, Appearance: XlPictureAppearance?, ContainsPICT?, ContainsBIFF?, ContainsRTF?, ContainsVALU?) -> AnyCut(Destination?) -> AnyDataSeries(Rowcol, Type: XlDataSeriesType?, Date: XlDataSeriesDate?, Step?, Stop?, Trend?) -> AnyDataTypeToText() -> NoneDelete(Shift?) -> AnyDialogBox() -> AnyDirty() -> NoneDiscardChanges() -> NoneEditionOptions(Type: XlEditionType, Option: XlEditionOptionsOption, Name, Reference, Appearance: XlPictureAppearance?, ChartSize: XlPictureAppearance?, Format?) -> AnyExportAsFixedFormat(Type: XlFixedFormatType, Filename?, Quality?, IncludeDocProperties?, IgnorePrintAreas?, From?, To?, OpenAfterPublish?, FixedFormatExtClassPtr?, WorkIdentity?) -> NoneFillDown() -> AnyFillLeft() -> AnyFillRight() -> AnyFillUp() -> AnyFind(What, After, LookIn, LookAt, SearchOrder, SearchDirection: XlSearchDirection?, MatchCase?, MatchByte?, SearchFormat?) -> RangeFindNext(After?) -> RangeFindPrevious(After?) -> RangeFlashFill() -> NoneFunctionWizard() -> AnyGoalSeek(Goal, ChangingCell: Range) -> boolGroup(Start?, End?, By?, Periods?) -> AnyInsert(Shift?, CopyOrigin?) -> AnyInsertIndent(InsertAmount: int) -> NoneJustify() -> AnyListNames() -> AnyMerge(Across?) -> NoneNavigateArrow(TowardPrecedent?, ArrowNumber?, LinkNumber?) -> AnyNoteText(Text?, Start?, Length?) -> strParse(ParseLine?, Destination?) -> AnyPasteSpecial(Paste: XlPasteType?, Operation: XlPasteSpecialOperation?, SkipBlanks?, Transpose?) -> AnyPrintOut(From?, To?, Copies?, Preview?, ActivePrinter?, PrintToFile?, Collate?, PrToFileName?) -> AnyPrintPreview(EnableChanges?) -> AnyRefreshLinkedDataType(DomainID?) -> NoneRemoveDuplicates(Columns, Header: XlYesNoGuess?) -> NoneRemoveSubtotal() -> AnyReplace(What, Replacement, LookAt?, SearchOrder?, MatchCase?, MatchByte?, SearchFormat?, ReplaceFormat?, FormulaVersion?) -> boolRowDifferences(Comparison) -> RangeRun(Arg1?, Arg2?, Arg3?, Arg4?, Arg5?, Arg6?, Arg7?, Arg8?, Arg9?, Arg10?, Arg11?, Arg12?, Arg13?, Arg14?, Arg15?, Arg16?, Arg17?, Arg18?, Arg19?, Arg20?, Arg21?, Arg22?, Arg23?, Arg24?, Arg25?, Arg26?, Arg27?, Arg28?, Arg29?, Arg30?) -> AnySelect() -> AnySetCellDataTypeFromCell(SourceCell: Range) -> NoneSetPhonetic() -> NoneShow() -> AnyShowCard() -> NoneShowDependents(Remove?) -> AnyShowErrors() -> AnyShowPrecedents(Remove?) -> AnySort(Key1, Order1: XlSortOrder?, Key2, Type, Order2: XlSortOrder?, Key3, Order3: XlSortOrder?, Header: XlYesNoGuess?, OrderCustom, MatchCase, Orientation: XlSortOrientation?, SortMethod: XlSortMethod?, DataOption1: XlSortDataOption?, DataOption2: XlSortDataOption?, DataOption3: XlSortDataOption?, SubField1?) -> AnySortSpecial(SortMethod: XlSortMethod?, Key1, Order1: XlSortOrder?, Type, Key2, Order2: XlSortOrder?, Key3, Order3: XlSortOrder?, Header: XlYesNoGuess?, OrderCustom, MatchCase, Orientation: XlSortOrientation?, DataOption1: XlSortDataOption?, DataOption2: XlSortDataOption?, DataOption3: XlSortDataOption?) -> AnySpeak(SpeakDirection?, SpeakFormulas?) -> NoneSpecialCells(Type: XlCellType, Value?) -> RangeSubscribeTo(Edition: str, Format: XlSubscribeToFormat?) -> AnySubtotal(GroupBy: int, Function: XlConsolidationFunction, TotalList, Replace, PageBreaks, SummaryBelowData: XlSummaryRow?) -> AnyTable(RowInput?, ColumnInput?) -> AnyTextToColumns(Destination, DataType: XlTextParsingType?, TextQualifier: XlTextQualifier?, ConsecutiveDelimiter?, Tab?, Semicolon?, Comma?, Space?, Other?, OtherChar?, FieldInfo?, DecimalSeparator?, ThousandsSeparator?, TrailingMinusNumbers?) -> AnyUngroup() -> AnyUnMerge() -> NoneProperty Accessors (parameterized — must be called as method):
End(Direction: XlDirection) -> RangeGet_Default(RowIndex?, ColumnIndex?) -> AnyGetAddress(RowAbsolute, ColumnAbsolute, ReferenceStyle: XlReferenceStyle?, External?, RelativeTo?) -> strGetAddressLocal(RowAbsolute, ColumnAbsolute, ReferenceStyle: XlReferenceStyle?, External?, RelativeTo?) -> strGetCharacters(Start?, Length?) -> CharactersGetOffset(RowOffset?, ColumnOffset?) -> RangeGetResize(RowSize?, ColumnSize?) -> RangeGetValue(RangeValueDataType?) -> AnyItem(RowIndex, ColumnIndex?) -> AnyRange(Cell1, Cell2?) -> RangeSet_Default(RowIndex, ColumnIndex?, arg2) -> NoneSetItem(RowIndex, ColumnIndex, arg2) -> NoneSetValue(RangeValueDataType, arg1) -> NoneProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index) -> Range__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyProperty Accessors (parameterized — must be called as method):
_Default(Index) -> RangeItem(Index) -> RangeProperties:
Application: ApplicationCreator: XlCreatorDownloadURL: AnyName: AnyParent: AnyProperties: CustomPropertiesRange: RangeSmartTagActions: SmartTagActionsXML: AnyMethods:
__call__() -> AnyDelete() -> NoneProperties:
ActiveXControl: AnyApplication: ApplicationCheckboxState: AnyCreator: XlCreatorExpandHelp: AnyListSelection: AnyName: AnyParent: AnyPresentInPane: AnyRadioGroupSelection: AnyTextboxText: AnyType: XlSmartTagControlTypeMethods:
__call__() -> AnyExecute() -> NoneProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index) -> SmartTagAction__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyProperty Accessors (parameterized — must be called as method):
_Default(Index) -> SmartTagActionItem(Index) -> SmartTagActionProperties:
Application: ApplicationCreator: XlCreatorEnabled: AnyFullName: AnyParent: AnyprogID: AnyMethods:
__call__() -> AnyProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyRecognize: AnyMethods:
__call__(Index) -> SmartTagRecognizer__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyProperty Accessors (parameterized — must be called as method):
_Default(Index) -> SmartTagRecognizerItem(Index) -> SmartTagRecognizerProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index) -> SmartTag__len__() -> Any__nonzero__() -> AnyAdd(SmartTagType: str) -> SmartTagProperty Accessors (parameterized — must be called as method):
_Default(Index) -> SmartTagProperties:
AlertStyle: AnyApplication: ApplicationCreator: XlCreatorErrorMessage: AnyErrorTitle: AnyFormula1: AnyFormula2: AnyIgnoreBlank: AnyIMEMode: AnyInCellDropdown: AnyInputMessage: AnyInputTitle: AnyOperator: AnyParent: AnyShowError: AnyShowInput: AnyType: AnyValue: AnyMethods:
__call__() -> AnyAdd(Type: XlDVType, AlertStyle?, Operator?, Formula1?, Formula2?) -> NoneDelete() -> NoneModify(Type?, AlertStyle?, Operator?, Formula1?, Formula2?) -> NoneProperties:
AllocationMethod: XlAllocationMethodAllocationValue: XlAllocationValueAllocationWeightExpression: AnyApplication: ApplicationCreator: XlCreatorOrder: AnyParent: AnyPivotCell: PivotCellTuple: AnyValue: AnyVisibleInPivotTable: AnyMethods:
__call__() -> AnyDelete() -> NoneProperties:
Application: ApplicationCreator: XlCreatorParent: AnySource: AnyMethods:
Delete() -> NoneProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index) -> Watch__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyAdd(Source) -> WatchDelete() -> NoneProperty Accessors (parameterized — must be called as method):
_Default(Index) -> WatchItem(Index) -> WatchProperties:
Application: ApplicationCreator: XlCreatorMap: XmlMapParent: AnyRepeating: AnyValue: AnyMethods:
__call__() -> AnyClear() -> NoneSetValue(Map: XmlMap, XPath: str, SelectionNamespace?, Repeating?) -> NoneProperties:
Application: ApplicationCreator: XlCreatorParent: AnySourceUrl: AnyMethods:
__call__() -> AnyClearSettings() -> NoneLoadSettings(Url: str) -> NoneRefresh() -> XlXmlImportResultProperties:
AdjustColumnWidth: AnyAppendOnImport: AnyApplication: ApplicationCreator: XlCreatorDataBinding: XmlDataBindingIsExportable: AnyName: AnyParent: AnyPreserveColumnFilter: AnyPreserveNumberFormatting: AnyRootElementName: AnyRootElementNamespace: XmlNamespaceSaveDataSourceDefinition: AnySchemas: XmlSchemasShowImportExportValidationErrors: AnyWorkbookConnection: WorkbookConnectionMethods:
__call__() -> AnyDelete() -> NoneExport(Url: str, Overwrite?) -> XlXmlExportResultExportXml(Data: str?) -> XlXmlExportResultImport(Url: str, Overwrite?) -> XlXmlImportResultImportXml(XmlData: str, Overwrite?) -> XlXmlImportResultProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index) -> XmlMap__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyAdd(Schema: str, RootElementName?) -> XmlMapProperty Accessors (parameterized — must be called as method):
_Default(Index) -> XmlMapItem(Index) -> XmlMapProperties:
Application: ApplicationCreator: XlCreatorParent: AnyPrefix: AnyUri: AnyMethods:
__call__() -> AnyProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyValue: AnyMethods:
__call__(Index) -> XmlNamespace__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyInstallManifest(Path: str, InstallForAllUsers?) -> NoneProperty Accessors (parameterized — must be called as method):
_Default(Index) -> XmlNamespaceItem(Index) -> XmlNamespaceProperties:
Application: ApplicationCreator: XlCreatorName: AnyNamespace: XmlNamespaceParent: AnyXML: AnyProperties:
Application: ApplicationCount: AnyCreator: XlCreatorParent: AnyMethods:
__call__(Index) -> XmlSchema__getitem__(key) -> Any__len__() -> Any__nonzero__() -> AnyProperty Accessors (parameterized — must be called as method):
_Default(Index) -> XmlSchemaItem(Index) -> XmlSchema