python通过xlrd库来实现读写表格内容_mww123mtr的博客

from xlutils.copy import copy
import xlrd
import json
#在函数中参数化sheet名，行，列作为缺省参数写死
def excel_data(sheetNo,Numrow,row=1,col=2):
    excelDir = "../Data/dada_data.xlsx"
    #读表格中的数据
    workname = xlrd.open_workbook(excelDir)
    #que=workname.sheet_names()
    #print(que)
    worksheet =workname.sheet_by_index(sheetNo)
    #写入表格操作,copy出来新的表跟sheet，并返回
    newworkbook = copy(workname)
    newsheet = newworkbook.get_sheet(0)
    return worksheet.cell(Numrow,row).value,worksheet.cell(Numrow,col).value,newworkbook,newsheetfrom xlutils.copy import copy
import xlrd
impor