Outputting A Coloured Excel File, Python Mới Update

To output a colored Excel file using Python, you can use the openpyxl library. Here’s an example code snippet to get you started:

python
import openpyxl
from openpyxl.styles import Font, Color, PatternFill, Alignment
from openpyxl.utils import get_column_letter

# Create a new workbook
wb = openpyxl.Workbook()

# Select the active worksheet
ws = wb.active

# Set the font for the header row
header_font = Font(color="FFFFFF", bold=True)

# Set the fill color for the header row
header_fill = PatternFill(start_color="008080", end_color="008080", fill_type="solid")

# Set the alignment for the header row
header_align = Alignment(horizontal="center", vertical="center")

# Add headers to the worksheet
headers = ["Name", "Age", "Gender"]
for col_num, header in enumerate(headers, 1):
    col_letter = get_column_letter(col_num)
    cell = ws.cell(row=1, column=col_num, value=header)
    cell.font = header_font
    cell.fill = header_fill
    cell.alignment = header_align

# Add some sample data to the worksheet
data = [
    ["Alice", 25, "Female"],
    ["Bob", 30, "Male"],
    ["Charlie", 35, "Male"],
]

for row_num, row_data in enumerate(data, 2):
    for col_num, cell_data in enumerate(row_data, 1):
        cell = ws.cell(row=row_num, column=col_num, value=cell_data)

# Save the workbook
wb.save("output.xlsx")

In this example, we’re creating a new Excel workbook and adding some sample data to it. We’re also setting the font, fill color, and alignment for the header row to make it stand out. Finally, we’re saving the workbook to a file named output.xlsx. You can customize this code to suit your needs, including changing the font, fill color, alignment, and data in the worksheet.