Python实践3：基于xlwings读写Excel表格，及except异常处理

代码如下：

import xlwings as xw


try:
    app=xw.App(visible=False, add_book=False)

    wb = app.books.open(r'C:\Users\005755\Desktop\工作日报-9月12日至18日---测试.xlsx')

    # 获取不同sheet的两种方法
    sht = wb.sheets(1)
    sht2 = wb.sheets('第一小组')  # sht = wb.sheets('Sheet1') 
    sht3 = wb.sheets(4)
    sht4 = wb.sheets[0]

    a1 = sht.range('c23').value # 获取某个单元格的值
    print(a1)


    a4 = sht.range('A23:J23').value
    for one in a4:
        print(one)

    a1 = sht.range('D11:E13').value   #输出D11~E13范围内的单元格范围的内容
    for m in a1:
        for n in m:
            print(n)

    a1 = sht.range((1,1),(3,3)).value   #输出a1~c3（第一行第一列至第三行第三列）范围内的3*3单元格范围的内容
    for m in a1:
        for n in m:
            print(n)


    sht.range('a3').value = '空空空空' # 修改某个单元格的值
    wb.save()


    sht4 = wb.sheets.add('test_sheet2')
    sht4.range((1,1),(3,3)).value = 'hhhh'
    print('已经添加了一个sheet')

    wb.save(r'c:\新建文档1.xlsx')  # 如果报错，则需要解除wps与xls文件的关联

except Exception as e:
    print('错误信息')
    print(e)
finally:
    print('总是执行')
    wb.save() 
    wb.close()
    app.kill()  # 或者app.quit()