search

DhanushNehru / Python-Scripts

A curated list of python scripts for automating your tasks
https://dhanushnehru.github.io/Python-Scripts/
MIT License
551 stars 259 forks source link

feat: Add CSV delimiter selection and cell styling to CSV to Excel script #312

Closed Stonebanks-js closed 1 month ago

Stonebanks-js commented 1 month ago

Description:

_This pull request adds two new features to the csvexcel.py script:

CSV Delimiter Detection: The script can now automatically detect the delimiter used in the CSV file, enhancing user-friendliness.

Excel Cell Styling: The output Excel sheet now includes basic styling (bold headers and alternating row colors), making the spreadsheet more readable and visually appealing.

Changes Made:

Added automatic CSV delimiter detection, so users are not required to input the separator manually.

Implemented basic Excel cell styling, including bold headers and alternating row background colors for improved readability. Modified input prompts and error handling accordingly.

Improved overall maintainability of the script by separating concerns and adding error checks.

Benefits:

User-Friendly: Users no longer need to specify the CSV delimiter unless they wish to override the detected one. Enhanced Readability: The Excel sheet now appears more structured with styled headers and alternate row colors, making it easier to read.

How to Test:

Clone the repository and run the csv_excel.py script. Provide a CSV file for testing. Check the output Excel file for correct formatting and styling.

Thank you by - Aradhya Chaudhary ( @Stonebanks-js )