xlSlim
User Guide
Installation
Quickstart
Interactive Mode
Optional arguments
Passing simple data types
Passing lists
Passing Python objects
Passing Python dictionaries
Calling VBA and other Excel add-in functions
numpy Arrays
pandas Series
pandas DataFrames
Running Python in a background process
Advanced Module Importing
Dynamic Module Importing
Remote Module Importing
Streaming data
Replacing VBA with Python
Replacing VBA Event Handling with Python
Adding Context and Ribbon Menus
Licensing
Troubleshooting
DuckDB
Examples
Read JSON data from a URL
Read CSV data from a file
Using SQLite to analyse data
Loading Stock Prices from Yahoo! Finance
Principal Components Analysis of Index Prices
Monte Carlo Option Pricing
NLP with Excel and Python
Streaming from Kafka
Creating a Pivot Table using Python
US Equity Index Option Pricing
Reference
Python Environments
Excel Functions
Data Conversions Between Excel and Python
Magic Global Functions
Special Named Ranges
Licensing
Software Requirements
xlSlim
Docs
»
Index
Index
A
|
C
|
D
|
G
|
I
|
L
|
P
|
R
|
S
|
U
|
V
|
W
|
X
A
ActivateInteractiveMode() (built-in function)
ActivatePremiumLicense() (built-in function)
AddPyEventHandler() (built-in function)
C
ClearCacheItem() (built-in function)
ClearCaches() (built-in function)
ClearSavedPythonEnv() (built-in function)
CreatePyModule() (built-in function)
CreateRange() (built-in function)
D
DeactivateInteractiveMode() (built-in function)
DeactivatePremiumLicense() (built-in function)
DuckDbQuery() (built-in function)
G
GetAttr() (built-in function)
GetItem() (built-in function)
I
IsPremiumLicensed() (built-in function)
L
LicenseExpiry() (built-in function)
LinkPyFunctionToKeys() (built-in function)
LogLocation() (built-in function)
P
PythonDetails() (built-in function)
R
RegisterPyModule() (built-in function)
S
SchedulePyFunction() (built-in function)
U
UpdateContextMenu() (built-in function)
UpdateRibbonMenu() (built-in function)
V
ViewPyObject() (built-in function)
W
WorkbookLocation() (built-in function)
X
XLSLIM_CALLERFUNC() (built-in function)
XLSLIM_COMAPPFUNC() (built-in function)
XLSLIM_INWINDOWFUNC() (built-in function)
XLSLIM_UDFFUNC() (built-in function)
XlSlimVersion() (built-in function)