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 »
  • Search

© Copyright 2022-2024, Russel Webber

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