美文网首页
python读取excel

python读取excel

作者: 沙漠狼神 | 来源:发表于2020-01-17 22:51 被阅读0次

    工具准备

    excel读取

    import xlrd
    xlsx = xlrd.open_workbook(filename)
    table = xlsx.sheet_by_index(0)
    table = xlsx.sheet_by_name(sheetname)
    table.cell_value(1,2)
    table.cell(1,2).value
    table.row(1)[2].value
    

    excel 写入

    import xlwt
    new_workbook = xlwt.Workbook()
    work_sheet = new_workbook.add_sheet('new_sheet')
    work_sheet.write(0,0,'This is a test')
    new_workbook.save(filename)
    

    格式写入

    from xlutils.copy import copy
    import xlrd
    import xlwt
    
    tem_excel = xlrd.open_workbook(filename,formating_info = Ture)
    tem_sheet = tem_excel.sheet_by_index(0)
    
    new_excel = copy(tem_excel)
    new_sheet = new_excel.get_sheet(0)
    

    相关文章

      网友评论

          本文标题:python读取excel

          本文链接:https://www.haomeiwen.com/subject/yhbhzctx.html