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

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

cheesefactory-excel-0.5.tar.gz (6.5 kB view details)

Uploaded Source

File details

Details for the file cheesefactory-excel-0.5.tar.gz.

File metadata

  • Download URL: cheesefactory-excel-0.5.tar.gz
  • Upload date:
  • Size: 6.5 kB
  • Tags: Source
  • Uploaded using 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

File hashes

Hashes for cheesefactory-excel-0.5.tar.gz
Algorithm Hash digest
SHA256 5498abb5a444f9399d8586205f1a072c3a1e46dbe8bf3e8b5086d3d6c067aae6
MD5 3b54972fb20067885cb16c1e7468a574
BLAKE2b-256 e5df9e8c1b5584937b3a98bc252ee80460397ab8c8b4b3a30be8efa4a6f7ebd3

See more details on using hashes here.

Release history Release notifications | RSS feed

This release

0.5 This release

1 file

0.4

1 file

0.3

1 file

0.2

1 file

0.1

1 file

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page