This Python script creates a structured Excel file using the xlsxwriter library. It populates a worksheet with detailed part information such as assembly components, revision numbers, material specifications, and approvals. This is useful for managing and exporting Bill of Materials (BoM), design specifications, or manufacturing records in a clean and professional Excel format.

• Creates a new Excel workbook and worksheet
• Writes custom headers and formats for documentation
• Supports structured entry of assembly part details
• Handles optional/missing fields gracefully
• Easy to customize or extend with more fields

• Python 3.x
• xlsxwriter

Install the required package using pip:

pip install xlsxwriter

1. Clone or download the script.
2. Run the script:

python create_excel.py

3. An Excel file named Creating Excel Task.xlsx will be generated in the current directory with a worksheet named "Sheet 1".

• Empty fields in the entry dictionary will appear as blank cells.
• The column headers can be adjusted to suit your specific document structure.
• Useful for documentation in engineering, manufacturing, or design workflows.