Closed CyberSecDef closed 4 years ago
worksheet.set_column('A:A', 50) worksheet.set_column('B:B', 25) worksheet.set_column('C:C', 25) worksheet.set_column('D:D', 50) worksheet.set_column('E:E', 15) ... to for col,width in { 'A': 50, 'B': 25, ...}.items(): worksheet.set_column(f'{col}:{col}', width)
worksheet.set_column('A:A', 50) worksheet.set_column('B:B', 25) worksheet.set_column('C:C', 25) worksheet.set_column('D:D', 50) worksheet.set_column('E:E', 15) ... to for col,width in { 'A': 50, 'B': 25, ...}.items(): worksheet.set_column(f'{col}:{col}', width)