###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
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
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
5498abb5a444f9399d8586205f1a072c3a1e46dbe8bf3e8b5086d3d6c067aae6
|
|
| MD5 |
3b54972fb20067885cb16c1e7468a574
|
|
| BLAKE2b-256 |
e5df9e8c1b5584937b3a98bc252ee80460397ab8c8b4b3a30be8efa4a6f7ebd3
|