见代码
import xlrd
import pprint
from config import excel_dir, sheet_name, excel_report_dir
from xlutils.copy import copy
class Excel:
def __init__(self, excel_dir, sheet_name):
"""
:param excel_dir: Excel路径
:param sheet_name: 需要操作的sheet名称
"""
self.excel_dir = excel_dir
self.sheet_name = sheet_name
self.resultList = []
self.work_book = xlrd.open_workbook(self.excel_dir, formatting_info=True)
self.sheet = self.work_book.sheet_by_name(self.sheet_name)
def get_excel_data(self, start_row, end_row, *args):
"""
:param start_row: 开始的行(从0开始数)
:param end_row: 结束的行(从0开始数)
:param args: 需要获取的列
:return:返回一个列表,列表元素是每一行对应列的数据组成的元组[(),(),()]
"""
for one in range(start_row, end_row + 1):