py_excel.py 文件源码

def qidongceshi(cishu,start):
    try:
        workbook=xlsxwriter.Workbook('????????.xlsx')
        worksheet=workbook.add_worksheet('time')
        bold=workbook.add_format({'bold':1})
        headings=['????','????']
        data=[cishu,start]
        worksheet.write_row('A1',headings,bold)
        worksheet.write_column('A2',data[0])
        worksheet.write_column('B2',data[1])
        chart1 = workbook.add_chart({'type': 'scatter',
                                'subtype': 'straight_with_markers'})
        chart1.add_series({
            'name':'=time!$B$1',
            'categories': '=time!$A$2:$A$%s'%(len(start)+1),
            'values': '=time!$B$2:$B$%s'%(len(start)+1),
            })
        chart1.set_title({'name':'????'})
        chart1.set_x_axis({'name':"????"})
        chart1.set_y_axis({'name':'????:ms'})
        chart1.set_style(11)
        worksheet.insert_chart('D2', chart1, {'x_offset': 25, 'y_offset': 10})
        workbook.close()
        LOG.info('????????')
    except:
        LOG.info('???????????:%s'%Exception)