Add Automatic CSV Header Formatting and Multiple CSV File Support

[Stonebanks-js]

Description:

This issue proposes adding two major features to the csv_excel.py script:

1. Automatic CSV Header Detection and Formatting Description:

Automatically detect the header row from the CSV file. Apply a specific formatting (e.g., bold, background color) to the header in the Excel file.

Benefit:

Improved readability of the Excel output. Easier to distinguish between headers and data, especially when working with large datasets.

2. Support for Multiple CSV Files Description:

Add support for selecting multiple CSV files as input.

Each CSV file should be written into a separate sheet within the same Excel file.

Benefit:

This feature will enhance productivity for users working with multiple CSV files by consolidating them into one Excel workbook. Makes the script more versatile for batch processing CSV files.

Acceptance Criteria:

Headers from the CSV file are automatically detected and formatted in bold with a background color. Multiple CSV files can be loaded, with each being added to a new sheet in the Excel file. Error handling for incorrect or empty CSV files is implemented for both features.

This issue is subjected to @Stonebanks-js -Aradhya Chaudhary

[Stonebanks-js]

@DhanushNehru Assign this issue to me and add hacktoberfest labels