Create Excel files from Dataframes or dictionaries.
Project description
###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
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.