技术分享

编程 更多

Python openpyxl 读取Excel

Python openpyxl 读取Excel excel_path = os.getcwd() + '/resources/v6.xlsx' ws = openpyxl.load_workbook(excel_path) sheetnames = ws.sheetnames读取第一个Sheet内容,从第2行开始读,读到100行: sheet = ws[sheet