{"library":"pylightxl","title":"pylightxl","description":"pylightxl is a lightweight, zero-dependency Python library designed for reading and writing Microsoft Excel files (.xlsx, .xlsm) and CSV files. It supports Python 2.7.18 and 3+, focusing on basic cell data manipulation without supporting complex features like formatting, graphs, or macros. The library is actively maintained, with its current version being 1.61, and releases occur regularly to address bugs and add features.","language":"python","status":"active","last_verified":"Sun May 17","install":{"commands":["pip install pylightxl"],"cli":null},"imports":["import pylightxl as xl"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import pylightxl as xl\nimport os\n\n# Create a dummy Excel file for reading example\ndb_write = xl.Database()\ndb_write.add_ws(ws='Sheet1')\ndb_write.ws(ws='Sheet1').update_index(row=1, col=1, val='Header 1')\ndb_write.ws(ws='Sheet1').update_index(row=1, col=2, val='Header 2')\ndb_write.ws(ws='Sheet1').update_index(row=2, col=1, val=100)\ndb_write.ws(ws='Sheet1').update_index(row=2, col=2, val='=A2*2')\n\noutput_file = 'example_output.xlsx'\nxl.writexl(db_write, output_file)\nprint(f\"Created '{output_file}' for reading example.\")\n\n# Read from the Excel file\nif os.path.exists(output_file):\n    db_read = xl.readxl(fn=output_file)\n    print(f\"\\nReading data from '{output_file}':\")\n    \n    # Access data by address\n    cell_a1_val = db_read.ws(ws='Sheet1').address(address='A1')\n    print(f\"Cell A1 (value): {cell_a1_val}\")\n    \n    # Access formula by index\n    cell_b2_formula = db_read.ws(ws='Sheet1').index(row=2, col=2, output='f')\n    print(f\"Cell B2 (formula): {cell_b2_formula}\")\n    \n    # Iterate through rows\n    print(\"\\nAll data in Sheet1:\")\n    for row in db_read.ws(ws='Sheet1').rows:\n        print(row)\nelse:\n    print(f\"Error: '{output_file}' not found.\")\n\n# Clean up the created file\nif os.path.exists(output_file):\n    os.remove(output_file)\n    print(f\"Cleaned up '{output_file}'.\")","lang":"python","description":"This quickstart demonstrates how to create a simple Excel file, write data including a formula, and then read data back from it using cell addresses, indices, and row iteration. It also shows how to access cell formulas.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":{"tag":null,"tag_description":null,"last_tested":"2026-05-17","installed_version":"1.61","pypi_latest":"1.61","is_stale":false,"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":2.5,"avg_import_s":0.11,"wheel_type":"sdist"},"results":[{"runtime":"python:3.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"pylightxl","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.13,"mem_mb":5.4,"disk_size":"19.4M"},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"pylightxl","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":2.1,"import_time_s":0.11,"mem_mb":5.4,"disk_size":"20M"},{"runtime":"python:3.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"pylightxl","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.14,"mem_mb":5.6,"disk_size":"21.9M"},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"pylightxl","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":2.2,"import_time_s":0.12,"mem_mb":5.6,"disk_size":"22M"},{"runtime":"python:3.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"pylightxl","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.12,"mem_mb":5.5,"disk_size":"11.8M"},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"pylightxl","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":3.1,"import_time_s":0.12,"mem_mb":5.5,"disk_size":"12M"},{"runtime":"python:3.13-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"pylightxl","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.14,"mem_mb":5.5,"disk_size":"11.6M"},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"pylightxl","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":2.9,"import_time_s":0.1,"mem_mb":5.3,"disk_size":"12M"},{"runtime":"python:3.9-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"pylightxl","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.09,"mem_mb":5.2,"disk_size":"19.0M"},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"pylightxl","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":2.4,"import_time_s":0.07,"mem_mb":5.2,"disk_size":"20M"}]}}