python write to excel
from openpyxl import Workbook filename = 'Testwriteexcel.xlsx' sheettitle = 'Sheetname' wb = Workbook() wb['Sheet'].title = sheettitle sh1 = wb.active sh1['A1'].value = 'Numbers' sh1['B1'].value = 'Sqares' sh1['C1'].value = 'Column 3' for n in range(1, 1+10): sh1[f'A{1+n}'].value = n sh1[f'B{1+n}'].value = n**2 try: wb.save(filename) except PermissionError: print('File might be opened, please close it before writing')
