import openpyxl
'''
wb = openpyxl.load_workbook('1910职业防护津贴.xlsx', read_only='r')
sheet = wb.get_sheet_by_name('Sheet1')
for i in range(1,8,2):
print(i,sheet.cell(row=i,column=2).value)
print(sheet.max_row)
print(sheet.max_column)
for i in range(1,sheet.max_row,1):
for j in range(1,sheet.max_column,1):
print(sheet.cell(i,j).value,end=',')
print('\n')
wb.save('1910职业防护津贴.xlsx')
'''
'''
wb = openpyxl.Workbook()
wb.create_sheet()
sheet = wb.active
sheet.row_dimensions[1].height = 70
sheet.column_dimensions['B'].width = 20
sheet.merge_cells('C5:Z5')
sheet.freeze_panes = 'A2'
wb.create_sheet(index=0,title='First Sheet')
wb.create_sheet(index=1,title='Middle Sheet')
wb.save('test1.xlsx')
wb.close()
'''
wb = openpyxl.Workbook()
sheet=wb.active
for i in range(1,11,1):
sheet['A'+str(i)] = i
refObj = openpyxl.chart.Reference(sheet,min_col=1,min_row=1,max_col=1,max_row=10)
seriesObj = openpyxl.chart.Series(refObj,title='First Series')
chartObj = openpyxl.chart.BarChart()
chartObj.title = 'My Chart'
chartObj.append(seriesObj)
sheet.add_chart(chartObj,'C5')
wb.save('sampleChart.xlsx')
