Documentation

View all as PDF

View all as HTML

• Quick start
• Config file
  • PyXLL settings
  • Logging
  • Environment Variables
  • License key
• Writing User Defined Functions (UDFs)
  • Exposing functions as UDFs
  • Standard argument and return types
  • The var type
  • Using arrays
  • Using NumPy arrays
  • Passing errors as values
  • Custom types
  • Type conversion (New in PyXLL 1.3)
  • Passing cell metadata
  • Asynchronous functions
• Creating custom menu items
  • Basic menu items
  • New menus
  • Sub-menus
• Writing Excel macros
  • Exposing functions as macros
  • Calling macros from Excel
• Calling back into Excel from Python
  • Macro sheet and command functions
  • Other non-macro functions
  • Automation / COM
• PyXLL callbacks
• Developer Tools (New in PyXLL 1.3)
  • Reloading
  • Debugging
• Examples
  • Simple worksheet functions
  • Custom types
  • Menu functions
  • Macros and Excel Automation
  • PyXLL callbacks
  • Object cache
  • Developer Tools
    • Debugging with Eclipse and PyDev
    • Reloading and importing modules