Skip to main content

xlwings PRO delivers advanced functionality on top of xlwings CE

Project description

xlwings PRO

xlwings PRO is a commercial Python library that makes it easy to call Python from Excel and vice versa. In comparison to xlwings CE, it adds dedicated support and advanced features.

  • Scripting: Automate/interact with Excel from Python using a syntax that is close to VBA.
  • Macros: Replace your messy VBA macros with clean and powerful Python code.
  • UDFs: Write User Defined Functions (UDFs) in Python (Windows only).
  • REST API: Expose your Excel workbooks via REST API.

Numpy arrays and Pandas Series/DataFrames are fully supported. xlwings-powered workbooks are easy to distribute and work on Windows and Mac.

Installation

pip install xlwings-pro

NOTE: xlwings PRO requires a license key. To get a free trial license key, see the docs

Reports add-on

xlwings reports is an add-on to xlwings PRO for template based Excel and PDF reporting. It allows business users without Python knowledge to create & maintain Excel templates without having to go back to a Python developer for every change: xlwings reports separates the Python code (that gets and prepares all the data) from the Excel template (that defines which data goes where and how it should be formatted).

Excel template

Wherever you want to paste the values of your Python variables, just put a Jinja2 variable {{ myvar }} in that cell. This works equally well for strings, numbers, dicts, NumPy arrays, Pandas DataFrames, images or Matplotlib figures.

For example, create an Excel file called my_template.xlsx where you put in {{ title }} in cell A1 and {{ df }} in cell A3.

Create the report

To produce the Excel report run the following script:

from xlwings.reports import create_report
import pandas as pd
df = pd.DataFrame(data=[[1,2],[3,4]])
wb = create_report('my_template.xlsx', 'my_report.xlsx', title='MyTitle', df=df)

xlwings reports can dynamically shift rows by using Frames, for details see the reports docs.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for xlwings-pro, version 1.2.1
Filename, size File type Python version Upload date Hashes
Filename, size xlwings_pro-1.2.1-cp27-none-macosx_10_5_x86_64.whl (336.4 kB) File type Wheel Python version cp27 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp27-none-win32.whl (672.7 kB) File type Wheel Python version cp27 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp27-none-win_amd64.whl (672.7 kB) File type Wheel Python version cp27 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp35-none-macosx_10_5_x86_64.whl (340.7 kB) File type Wheel Python version cp35 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp35-none-win32.whl (677.0 kB) File type Wheel Python version cp35 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp35-none-win_amd64.whl (677.0 kB) File type Wheel Python version cp35 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp36-none-macosx_10_5_x86_64.whl (347.5 kB) File type Wheel Python version cp36 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp36-none-win32.whl (683.8 kB) File type Wheel Python version cp36 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp36-none-win_amd64.whl (683.8 kB) File type Wheel Python version cp36 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp37-none-macosx_10_5_x86_64.whl (325.6 kB) File type Wheel Python version cp37 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp37-none-win32.whl (661.9 kB) File type Wheel Python version cp37 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp37-none-win_amd64.whl (661.9 kB) File type Wheel Python version cp37 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp38-none-macosx_10_5_x86_64.whl (327.0 kB) File type Wheel Python version cp38 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp38-none-win32.whl (663.2 kB) File type Wheel Python version cp38 Upload date Hashes View hashes
Filename, size xlwings_pro-1.2.1-cp38-none-win_amd64.whl (663.3 kB) File type Wheel Python version cp38 Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page