Skip to main content

###Features

* Built around Xlsxwriter and Pandas.

* Create Excel worksheets using either dictionaries or dataframes.

* Worksheet columns are automatically sized.

* Attractive default style.

###Create an Excel object

```python
from cheesefactory-Excel import Excel

excel = Excel(
output_file='my_excel.xlsx'
)
```

`output_file` (str): The path and name of the Excel file to create.

###Create a worksheet using a dictionary or Pandas Dataframe

```python
excel.create_worksheet(
worksheet_name='Sheet1',
content='my_content',
header='header_data'
)
```

`worksheet_name` (str): The worksheet name. It's limited to 31 characters. Default = `'Worksheet'`

`content` (dict or pd.Dataframe): A dictionary or dataframe of the worksheet's content.

`header` (List[str]): The worksheet's header. Default = `None`

###Write the Excel file

```python
excel.close()
```

Keywords: cheesefactory excel dataframe pandas development
Platform: UNKNOWN
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: BSD License
Classifier: Programming Language :: Python :: 3.7

Metadata

Release files for cheesefactory-excel 0.5

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

Source distribution (sdist)

Source distribution for cheesefactory-excel 0.5
File Size Uploaded
cheesefactory-excel-0.5.tar.gz 6.5 kB Details

Release files / cheesefactory-excel-0.5.tar.gz

Download URL cheesefactory-excel-0.5.tar.gz
Size 6.5 kB
Tags Source
SHA-256 checksum
How to use checksums
5498abb5a444f9399d8586205f1a072c3a1e46dbe8bf3e8b5086d3d6c067aae6
BLAKE2b-256 checksum
How to use checksums
e5df9e8c1b5584937b3a98bc252ee80460397ab8c8b4b3a30be8efa4a6f7ebd3
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/39.1.0 requests-toolbelt/0.8.0 tqdm/4.25.0 CPython/3.6.6

Release history Release notifications | RSS feed

This release

0.5 This release

1 release file

0.4

1 release file

0.3

1 release file

0.2

1 release file

0.1

1 release file

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