Skip to main content

Simple Excel Writer

build-status-image codeql-image pypi-version pypi-downloads

Simple library to write excel files.

Examples

import xlsxwriter
from simple_excel_writer import SimpleExcelFileCreator

excel_header = ("Header 1", "Header 1")
excel_data = [["row 1 1", "row 1 2"], ["row 2 1", "row 2 2"]]
excel_sheetname: str = "Sheet 1"
excel_table_label: str | None = None
datetime_cell_format = {"num_format": "dd.mm.yyyy h:mm;@", "border": 1, "border_color": "#000000"}
date_cell_format = {"num_format": "dd.mm.yyyy", "border": 1, "border_color": "#000000"}
percent_cell_format = {"num_format": '0.00"%"', "border": 1, "border_color": "#000000"}
format_cell_border = {"border": 1, "border_color": "#000000", "text_wrap": True}
format_header_table = {"bold": True, "align": "center", "border": 1, "border_color": "#000000", "text_wrap": True}
table_label_format = {"italic": True, "font_size": 14}

excel_creator = SimpleExcelFileCreator(
    header=excel_header,
    data=excel_data,
    worksheet_label=excel_sheetname,
    table_label=excel_table_label,
    datetime_cell_format=datetime_cell_format,
    date_cell_format=date_cell_format,
    percent_cell_format=percent_cell_format,
    format_cell_border=format_cell_border,
    format_header_table=format_header_table,
    table_label_format=table_label_format,
)
excel_creator.get_excel_for_response()

Required

  • python >=3.11, <4.0
  • pillow >=9.2
  • xlsxwriter >=1.3.6
  • pytz >=2020.1

Installation

pip install simple-excel-writer

Metadata

Release files for simple-excel-writer 0.0.3

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for simple-excel-writer 0.0.3
File Size Uploaded Provenance Actions
simple_excel_writer-0.0.3.tar.gz 9.1 kB Without provenance Details for simple_excel_writer-0.0.3.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for simple-excel-writer 0.0.3
File Interpreter ABI Platform Actions
simple_excel_writer-0.0.3-py3-none-any.whl Python 3 none any Details for simple_excel_writer-0.0.3-py3-none-any.whl

Total release size: 18.6 kB

Release files / simple_excel_writer-0.0.3.tar.gz

Download URL simple_excel_writer-0.0.3.tar.gz
Size 9.1 kB
Tags Source
SHA-256 checksum
How to use checksums
132b9b70b92e101516cce016cb90c70c333e6a7d7137147f0786ecaae7c882d2
BLAKE2b-256 checksum
How to use checksums
26989762649bd0c987a1e28b427f7df9f534ca72b01f4787d06e513d7d6b852f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/2.4.1 CPython/3.12.3 Linux/6.17.0-1018-azure

Release files / simple_excel_writer-0.0.3-py3-none-any.whl

Download URL simple_excel_writer-0.0.3-py3-none-any.whl
Size 9.4 kB
Tags Python 3
SHA-256 checksum
How to use checksums
e033fd320478681e3feb32da95ca72ecaca977cf365ee885c34fa03d44391738
BLAKE2b-256 checksum
How to use checksums
dd03ec8ea33a19acb7705117e4527f529c71d07dcd056c061bc48e379563b574
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/2.4.1 CPython/3.12.3 Linux/6.17.0-1018-azure

Security for simple-excel-writer 0.0.3

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page