D:\>python test.pytest.py:5: DeprecationWarning: Call to deprecated function get_sheet_by_name (Use wb[sheetname]).sheet = wb.get_sheet_by_name('Sheet1')Traceback (most recent call last):File "test.py", line 12, in <module>print(sheet.get_highest_row())AttributeError: 'Worksheet' ...
Python制作简单表格 importxlsxwriter workbook=xlsxwriter.Workbook('chart.xlsx')sheet1=workbook.add_worksheet('chart')bold=workbook.add_format()bold.set_bold()title=['kemu','ke1','ke2','ke3','ke4']data=[['zhangsan',60,85,75,100],['lisi',78,89,67,30],['wangwu',77,66,89,98]]m...
import xlsxwriter workbook=xlsxwriter.Workbook('chart.xlsx') sheet1=workbook.add_worksheet('chart') bold=workbook.add_format() bold.set_bold() title=['kemu','...
'categories':['Sheet1',1,0,6,0], 'values':['Sheet1',1,2,6,2], }) # Add a chart title and some axis labels. chart1.set_title({'name':'Results of sample analysis'}) chart1.set_x_axis({'name':'Test number'}) chart1.set_y_axis({'name':'Sample length (mm)'}) # Set...