zdavatz
Workbook problem
from openpyxl import Workbook # Define column names COLUMN_NAMES = ['College Name', 'Call Letter', 'Email', 'Phone', 'State'] # Define data data = [ ['College A', 'ABC', '[email protected]', '1234567890', 'State A'], ['College B', 'DEF', '[email protected]', '9876543210', 'State B'], ['College C', 'GHI', '[email protected]', '4567890123', 'State C'] ] # Create a new workbook workbook = Workbook() # Select the active sheet sheet = workbook.active # Set column names for col_num, column_name in enumerate(COLUMN_NAMES, 1): cell = sheet.cell(row=1, column=col_num) cell.value = column_name # Set data for row_num, row_data in enumerate(data, 2): for col_num, cell_value in enumerate(row_data, 1): cell = sheet.cell(row=row_num, column=col_num) cell.value = cell_value # Save the workbook workbook.save('college_data.xlsx')
