xlwings REPORTS

Template based Excel and PDF reports.

Connect to any data source with Python.

YouTube blocked? Watch the video here

Note: xlwings REPORTS is a commerical add-on to xlwings. See Pricing.

Excel, the tool every business user loves

These days you can choose from a wide range of reporting and BI solutions like SAP Crystal Reports, Microsoft Power BI, Tableau, Alteryx or QlikView. However, they are expensive, come with a steep learning curve and are therefore usually handled by a dedicated team.

By using xlwings REPORTS as your reporting tool, business users can design and maintain their own reports directly within Excel without being dependent on a dedicated reporting team or Python programmer.

If you need to provide the data behind the report, it's already there - no need to click that "Export to Excel button" in your favorite BI system.

Many believe that Excel can't be used to produce high quality PDF reports. However, Excel charts are vector graphics and Excel accepts pictures (e.g. for logos) as svg files: This leads to pixel perfect reports that guarantee high quality printing.

See for yourself and download the sample report. Want to see the template and Python code? Check out the repository on GitHub.

xlwings REPORTS runs on Windows and macOS.

xlwings-report

Flexibility with Excel templates

While it's easy to use xlwings CE to automate reporting, it's a hassle to keep the Excel template and the Python code in sync. xlwings REPORTS fixes this.

Instead of assigning your data to a specific Excel cell in your Python code, you simply use placeholders like {{ reference_date }} directly in your spreadsheet. It doesn't matter if that placeholder refers to a Pandas DataFrame or just a single word in a text block.

You never have to adjust your code again when you redesign your report. Business users can change their templates and create new ones without depending on a Python developer every time they insert a new row somewhere.

closeup cell diffs

Connect to any data source with Python

Python has become one of the most wildly used programming languages today. It has a big ecosystem so you can connect to literally anything you like whether that's SQL/noSQL databases or text and Excel files.

You can also connect to your big data solution and you can even use web scraping to get to your data. Also, chances are that your internal systems either offer a Python SDK or will otherwise be accessible via REST API.

Instead of using slow and complex Pivot tables, you can leverage Python's rich ecosystem. For example, Pandas allows for fast and easy data wrangling via DataFrames.

python logo

Start simple, customize for advanced usage

Need some extra control over your reporting process? You can always use xlwings CE together with xlwings REPORTS to achieve whatever you need.

Need to produce reports with different date formats? Just provide a selection for the user to choose from.

Does the report need to be behave differently depending on which day it is produced? Simply code the logic in Python - whatever you need it to be.

closeup cell diffs

© 2019 Zoomer Analytics LLC. All rights reserved.