pyxlsb: Excel Binary Workbook (.xlsb) Parser

1.0.10 · active · verified Thu Apr 09

pyxlsb is a Python library for parsing Excel 2007-2010 Binary Workbook (.xlsb) files. It provides an API to read sheets, rows, and cells, converting various data types like numbers, strings, and dates. The library is actively maintained with a focus on bug fixes and stability, currently at version 1.0.10.

Warnings

gotcha Prior to version 1.0.10, users might encounter `DeprecationWarning` due to string-byte comparison issues on Python 3.
Fix: Upgrade to pyxlsb==1.0.10 or newer to resolve these warnings.
gotcha Versions before 1.0.8 had known resource leaks. For long-running processes or processing many files, this could lead to memory accumulation or file handle exhaustion.
Fix: Upgrade to pyxlsb==1.0.8 or newer. Ensure proper context management (`with open_workbook(...)`) to minimize resource holding.
gotcha Date and time conversions in versions prior to 1.0.9 could have rounding errors for specific values, leading to slight inaccuracies.
Fix: Upgrade to pyxlsb==1.0.9 or newer for improved date/time conversion accuracy.
gotcha Reading worksheets with mixed types (e.g., chart sheets alongside data sheets) could cause issues with sheet selection in versions before 1.0.7.
Fix: Upgrade to pyxlsb==1.0.7 or newer. If stuck on an older version, ensure you are selecting data sheets specifically by name if possible.

Install

pip install pyxlsb Install stable release

Imports

open_workbook
```
from pyxlsb import open_workbook
```

Quickstart

Demonstrates how to open an .xlsb file, access its first sheet, and iterate through rows to print cell values. Note that `pyxlsb` is a read-only library, so you'll need an existing `.xlsb` file (e.g., 'example.xlsb') for the code to execute successfully.

import os
from pyxlsb import open_workbook

# Create a dummy .xlsb file for demonstration if it doesn't exist
# In a real scenario, you would have your existing file.
# Note: pyxlsb can only read, not write .xlsb files.
# A simple way to get one is to create an Excel file and save as 'Excel Binary Workbook (*.xlsb)'
# For this example, let's assume 'example.xlsb' exists and has a sheet with data.
# If you don't have one, this example will likely fail or print nothing.

# For a real application, ensure 'example.xlsb' exists in the current directory
# or provide a full path.

file_path = os.path.join(os.getcwd(), 'example.xlsb') # Or provide an actual path
# You would typically have a real .xlsb file here.
# For a runnable example without manual file creation, this part is tricky as pyxlsb is read-only.
# For now, we assume a file named 'example.xlsb' exists.

try:
    with open_workbook(file_path) as wb:
        # Access the first sheet by index (1-based)
        # Or by name: with wb.get_sheet('Sheet1') as sheet:
        with wb.get_sheet(1) as sheet:
            print(f"Reading sheet: {sheet.name}")
            # Iterate through rows
            for row_index, row in enumerate(sheet.rows()):
                if row_index >= 5: # Limit output for quickstart
                    break
                row_values = [cell.v for cell in row if cell.v is not None]
                if row_values:
                    print(f"Row {row_index + 1}: {row_values}")
except FileNotFoundError:
    print(f"Warning: '{file_path}' not found. Please create an example.xlsb file to run this quickstart.")
except Exception as e:
    print(f"An error occurred: {e}")

view raw JSON →