Metadata-Version: 2.1
Name: df2file
Version: 2.0.0
Summary: A utility for appending DataFrames to Excel/CSV files.
Home-page: https://github.com/arjunlimat/df2file
Author: Tamilselvan Arjunan
Author-email: nishantamil@gmail.com
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: pandas
Requires-Dist: openpyxl

### Project : df2file:
A Python utility designed for efficiently appending Pandas DataFrames to a single Excel file, each in a separate sheet.

#### Features:

- **Convenient Dataframe Appending:** Easily append Pandas DataFrames to an existing Excel file, with each DataFrame creating a new sheet within the workbook.

- **Sheet Customization:** Specify sheet names, starting row positions, and other options to customize the placement of each DataFrame within the Excel file.

- **Excel File Management:** If the specified Excel file does not exist, the utility will create it. If it does exist, the utility will append DataFrames to existing sheets or create new sheets as needed.


### Installation:
url = https://pypi.org/project/df-to-excel-appender/

#### Install the package using pip:

1.pip install df2file

2.from df2file.df_to_file import append_df_to_excel

3.from df2file.df_to_file import append_df_to_csv

#### Use the function to append a DataFrame to an Excel file:
#### Example usage:
output_file = 'output.xlsx'
your_dataframe = pd.DataFrame({'Column1': [1, 2, 3], 'Column2': ['A', 'B', 'C']})
append_df_to_excel(output_file, your_dataframe, sheet_name='Sheet1', index=False)

#### Run the script from the command line:

df_to_excel_appender input.csv -o output.xlsx
 

#### Options:

-i, --input: Input CSV file.

-o, --output: Output Excel file.

#### Dependencies:
pandas

openpyxl

#### Contributing:

If you find any issues or have suggestions for improvements, please open an issue or create a pull request.

#### License:
This project is licensed under the MIT License - see the LICENSE file for details.
