Open Meanodaddyo opened 7 months ago
from openpyxl import Workbook # Define column names COLUMN_NAMES = ['College Name', 'Call Letter', 'Email', 'Phone', 'State'] # Define data data = [ ['College A', 'ABC', 'collegea@example.com', '1234567890', 'State A'], ['College B', 'DEF', 'collegeb@example.com', '9876543210', 'State B'], ['College C', 'GHI', 'collegec@example.com', '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')
what is your problem?
zdavatz
commented
7 months ago zdavatz
commented
7 months ago
from openpyxl import Workbook # Define column names COLUMN_NAMES = ['College Name', 'Call Letter', 'Email', 'Phone', 'State'] # Define data data = [ ['College A', 'ABC', 'collegea@example.com', '1234567890', 'State A'], ['College B', 'DEF', 'collegeb@example.com', '9876543210', 'State B'], ['College C', 'GHI', 'collegec@example.com', '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')