xlOil Python
- xlOil Python Introduction
- xlOil Python Concepts
- xlOil Python Registering Functions
- xlOil Python Type Conversion
- xlOil Python: The Excel.Application object
- xlOil Python GUI Customisation
- xlOil Python Dynamic Runtime Interaction
- xlOil Python Package Support
- xlOil Built-in Worksheet Functions
- xlOil Jupyter Interaction
- xlOil Python Async/Rtd
- xlOil Python Debugging
- xlOil Python Distributing Addins
- xlOil Python Examples
- xlOil Python GUI Examples
- xlOil Python RTD Examples
- xlOil Python Questions
- ImportError: Typelib different than module
- Intellisense / Function Context Help
- Auto-reload doesn’t reload a module
- Dynamically Resized Arrays
- This application failed to start because it could not find or load the Qt platform plugin “windows”
- win32com / pythoncom: <some CLSID> has no attribute ‘CLSIDToClassMap’
- Could not connect COM: trying again in 1 second
- xlOil Python Module Reference
- Declaring Worksheet Functions
- Excel Object Model
- RTD Functions
- GUI Interaction
- Events
- Using the Event Class
- Python-only Events
- Examples
Event
pause()
allow()
AfterCalculate
WorkbookOpen
NewWorkbook
SheetSelectionChange
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetActivate
SheetDeactivate
SheetCalculate
SheetChange
WorkbookAfterClose
WorkbookRename
WorkbookActivate
WorkbookDeactivate
WorkbookBeforeClose
WorkbookBeforeSave
WorkbookAfterSave
WorkbookBeforePrint
WorkbookNewSheet
WorkbookAddinInstall
WorkbookAddinUninstall
XllAdd
XllRemove
ComAddinsUpdate
PyBye
UserException
- Everything else
ObjectCache
cache
call()
call_async()
core_addin()
excel_callback()
excel_state()
from_excel_date()
get_async_loop()
get_event_loop()
in_wizard()
linked_workbook()
run()
run_async()
source_addin()
source_addin()
date_formats
ExcelState
Addin
xloil_addins
_AddinsDict
_DateFormatList
_LogWriter
log
log_except()
use_debugger()
- External libraries