摘要：import jsonimport pandas as pdfrom openpyxl import Workbookfrom openpyxl.drawing.image import Imageexcel_col_map={ 1:"A", 2:"B", 3:"C", 4:"D", 5:"E", 阅读全文

摘要：import xlrd def get_wb(path): wb = xlrd.open_workbook(path) return wb def get_wb(path): wb = xlrd.open_workbook(path) return wb def get_hyperlink(wb,s 阅读全文

摘要：import json # import pandas as pd from openpyxl import Workbook from openpyxl.drawing.image import Image excel_col_map = { 1: "A", 2: "B", 3: "C", 4: 阅读全文

摘要：import xlrd def read_xls(file): # 打开xls文件 data = xlrd.open_workbook(file) # 打开所有表 tables = data.sheets() for table in tables: # 获取表的行数 nrows = table.n 阅读全文