xlOil documentation
- xlOil
- xlOil Core
- xlOil Concepts
- xlOil Excel Events
- Introduction
- AfterCalculate
- WorkbookOpen
- NewWorkbook
- SheetSelectionChange
- SheetBeforeDoubleClick
- SheetBeforeRightClick
- SheetActivate
- SheetDeactivate
- SheetCalculate
- SheetChange
- WorkbookActivate
- WorkbookDeactivate
- WorkbookBeforeClose
- WorkbookBeforeSave
- WorkbookBeforePrint
- WorkbookAfterClose
- WorkbookNewSheet
- WorkbookAddinInstall
- WorkbookAddinUninstall
- CalcCancelled
- XllAdd
- XllRemove
- xlOil Core Functions
- xlOil C++
- 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
- xlOil SQL
- xlOil Utils
- xloBlock: creates an array from blocks
- xloFill: gives an array filled with a single value
- xloFillNA: replaces Empy or #N/A with a specified value
- xloSort: sorts an array by multiple columns
- xloPad: pads an array to have at least two rols and columns
- xloConcat: concatenates strings
- xloSplit: splits strings at a separator
- xloIndex: gets values or sub-arrays for arrays and ranges
- xlOil Development Guide