All the callbacks between Excel and your Python code are handled for you. Array functions can be made to automatically resize by setting the keyword argument auto_resize=true to xl_func, or it can be enabled for all array functions in the config file by setting auto_resize_arrays = Keyboard Shortcuts 1 Macros and menus written using xl_macro and xl_menu can now be assigned keyboard shortcuts using the shortcut keyword argument, or set in the config Customizing the Ribbon Ever wanted to write an addin that uses the Excel ribbon interface? Previously the only way to do this was to write a COM addin, which requires a lot of knowledge, skill and perseverance! Now you can do it with PyXLL by defining your ribbon as an XML document and adding it to your PyXLL config.
Automatic Array Resizing Keyboard Shortcuts Customizing the Ribbon RTD (Real Time Data) Functions Function Signatures and Type Annotation Default Keyword Arguments Easier Setup for Anaconda and Virtualenvs Deep Reloading Error Caching Python Functions for Reload and Rebind Better win32com and comtypes Support IntelliSense 1ĥ 1.1.1 Automatic Array Resizing 1 When returning an array PyXLL can automatically resize the range of the array formula in Excel so it expands or contracts to match the size of the array being returned. Internally a lot has changed to bring you these new features and ensure that PyXLL retains the high quality and reliability that you re used to from previous versions. 1.1 What s new in PyXLL 3 PyXLL 3 introduces a number of new features that make it even easier to make rich, interactive Excel spreadsheets in Python. If you don t find what you re looking for, or need any extra help please contact us. Oct 01, 2017Ģ CONTENTS 1 PyXLL Documentation What s new in PyXLL Automatic Array Resizing Keyboard Shortcuts Customizing the Ribbon RTD (Real Time Data) Functions Function Signatures and Type Annotation Default Keyword Arguments Easier Setup for Anaconda and Virtualenvs Deep Reloading Error Caching Python Functions for Reload and Rebind Better win32com and comtypes Support IntelliSense Getting Started Installing with Enthought Canopy Installing with other Python Distributions Calling a Python Function in Excel Next Steps User Guide Configuration Worksheet Functions Menu Functions Customizing the Ribbon Macro Functions Real Time Data API Reference Function Decorators Utility Functions Event Handlers Excel C API Functions Classes Examples Worksheet Functions Custom Types Menu Functions Macros and Excel Scripting Event Handlers Object Cache Developer Tools iĤ CHAPTER ONE PYXLL DOCUMENTATION Looking for the PyXLL 2.x docs? PyXLL 2 Documentation This documentation is for versions of PyXLL 3.0 and greater.
0 kommentar(er)
