PyXLL The Python Excel Add-In
  • Product
    • Features
    • Get Started
    • Request Demo
    • Download
  • Pricing
  • Resources
    • Documentation
    • Blog
    • Videos
    • FAQ
    • Learn Python
    • Customer Portal
    • About Us
  • Support
    • Documentation
    • Videos
    • FAQ
    • Contact Us
  • Contact Us
Table of Contents
  • PyXLL Documentation
  • Introduction to PyXLL
  • User Guide
    • Installing PyXLL
    • Configuring PyXLL
    • Worksheet Functions
    • Macro Functions
    • Real Time Data
    • Cell Formatting
    • Charts and Plotting
    • Custom Task Panes
    • ActiveX Controls
    • Using Pandas in Excel
    • Customizing the Ribbon
    • Context Menu Functions
    • Working with Tables
    • Python as a VBA Replacement
    • Menu Functions
    • Reloading and Rebinding
    • Error Handling
    • Deploying your add-in
    • Workbook Metadata
  • Video Guides and Tutorials
  • API Reference
  • What’s new in PyXLL 5
  • Changelog
Close

Workbook Metadata¶

Some PyXLL features will add XML metadata to the Excel workbook when saving.

Features that use this metadata are:

  • Recalculating On Open

  • Saving Objects in the Workbook

  • Cell Formatting [1]

Metadata used by PyXLL is added to the workbook as a CustomXMLPart, which is part of the workbook document.

The CustomXMLPart is saved in the workbook using an XML namespace specific to the PyXLL add-in so as not to conflict with data saved by other add-ins. If you have specified a name for your add-in using the name setting that will be used to avoid conflict with any other PyXLL add-ins you may have loaded.

If you prefer to specify the namespace to use instead of having PyXLL use it’s own namespace you can do so by setting metadata_custom_xml_namespace in the PYXLL section of your pyxll.cfg file.

[PYXLL]
metadata_custom_xml_namespace = urn:your_name:metadata

To disable writing any metadata you can set disable_saving_metadata = 1 in the PYXLL section of your pyxll.cfg file. Note that this will affect all PyXLL features that require metadata.

[PYXLL]
disable_saving_metadata = 1

Footnotes

[1]

Custom formatting only requires metadata when a custom formatter is applied to a Dynamic Array function.

« Deploying your add-in
Video Guides and Tutorials »
  • Home
  • Product
  • Features
  • Documentation
  • Download
  • Pricing
  • Support
  • Documentation
  • Videos
  • FAQ
  • Learn Python
  • Contact Us
  • About
  • About Us
  • Legal
  • Blog
© Copyright PyXLL Ltd