python xlrd模块 获得单元格格式信息,pythonxlrd,我想获取一个excle单


我想获取一个excle单元格的格式来设置另外一个excle的格式,但不知道怎么获取excle的单元格格式信息。

workbook_A = xlrd.open_workbook(self.file_A,ragged_rows=True)table_A = workbook_A.sheet_by_name(self.sheetName)nrows_A = table_A.nrowsnclos_A = table_A.ncols
import xlrdfrom xlutils.filter import process, XLRDReader, XLWTWriterdef copy2(wb):    w = XLWTWriter()    process(XLRDReader(wb, 'unknown.xls'), w)    return w.output[0][1], w.style_listrb = xlrd.open_workbook('C:\\Users\\sa\\Desktop\\1.xls', formatting_info=True, on_demand=True)wb, s = copy2(rb)wbs = wb.get_sheet(0)rbs = rb.get_sheet(0)styles = s[rbs.cell_xf_index(0, 0)]rb.release_resources()  #关闭模板文件wbs.write(0, 0, 'aa', styles)wb.save("C:\\Users\\sa\\Desktop\\2.xls")

编橙之家文章,

评论关闭