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)

© Copyright 2022-2024, Russel Webber

Built with Sphinx using a theme provided by Read the Docs.