{"library":"pyxlsx","title":"Fast XLSX Reader","description":"Pyxlsx is a fast and memory-efficient Python library designed for reading data from XLSX (Excel) files. It focuses on parsing core data, shared strings, and basic styling, making it suitable for high-performance data extraction. The current stable version is 1.1.3, and releases are typically made for bug fixes and minor improvements as needed.","language":"python","status":"active","last_verified":"Sun May 17","install":{"commands":["pip install pyxlsx"],"cli":null},"imports":["from pyxlsx import Reader"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import openpyxl\nimport os\nfrom pyxlsx import Reader\n\n# Create a dummy XLSX file for demonstration\nfile_path = \"example.xlsx\"\nworkbook = openpyxl.Workbook()\nsheet = workbook.active\nsheet['A1'] = \"Name\"\nsheet['B1'] = \"Age\"\nsheet['A2'] = \"Alice\"\nsheet['B2'] = 30\nsheet['A3'] = \"Bob\"\nsheet['B3'] = 24\nworkbook.save(file_path)\n\nprint(f\"Created dummy file: {file_path}\")\n\n# Use pyxlsx to read the file\ntry:\n    reader = Reader(file_path)\n    # pyxlsx iterators are one-pass; convert to list if you need to iterate multiple times\n    rows_data = list(reader.rows())\n    \n    if rows_data:\n        print(\"Header row:\", rows_data[0])\n        print(\"Data rows:\")\n        for row in rows_data[1:]:\n            print(row)\n    else:\n        print(\"No data found in the file.\")\n\nexcept FileNotFoundError:\n    print(f\"Error: The file {file_path} was not found. Please ensure it exists.\")\nexcept Exception as e:\n    print(f\"An unexpected error occurred: {e}\")\nfinally:\n    # Clean up the dummy file\n    if os.path.exists(file_path):\n        os.remove(file_path)\n        print(f\"Cleaned up dummy file: {file_path}\")","lang":"python","description":"This quickstart demonstrates how to create a simple XLSX file using `openpyxl` and then read its contents using `pyxlsx`. It shows basic row iteration and includes cleanup.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":{"tag":null,"tag_description":null,"last_tested":"2026-05-17","installed_version":"1.1.3","pypi_latest":"1.1.3","is_stale":false,"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":5.3,"avg_import_s":null,"wheel_type":"wheel"},"results":[{"runtime":"python:3.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"pyxlsx","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":"106.9M"},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"pyxlsx","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":5.3,"import_time_s":null,"mem_mb":null,"disk_size":"103M"},{"runtime":"python:3.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"pyxlsx","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":"118.2M"},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"pyxlsx","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":5.1,"import_time_s":null,"mem_mb":null,"disk_size":"114M"},{"runtime":"python:3.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"pyxlsx","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":"105.7M"},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"pyxlsx","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":4.9,"import_time_s":null,"mem_mb":null,"disk_size":"101M"},{"runtime":"python:3.13-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"pyxlsx","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":"105.2M"},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"pyxlsx","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":5.1,"import_time_s":null,"mem_mb":null,"disk_size":"101M"},{"runtime":"python:3.9-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"pyxlsx","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":null,"import_time_s":null,"mem_mb":null,"disk_size":"114.8M"},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"pyxlsx","exit_code":0,"wheel_type":"wheel","failure_reason":null,"import_side_effects":"broken","install_time_s":6.1,"import_time_s":null,"mem_mb":null,"disk_size":"113M"}]}}