本文共 926 字，大约阅读时间需要 3 分钟。

# coding=utf-8import mathimport xlrdimport xlwtimport sysreload(sys)sys.setdefaultencoding('utf-8')limit = 30 #每个Excel多少条数据save = r'C:\Users\86159\Desktop\test'workbook = xlrd.open_workbook(r'C:\Users\86159\Desktop\test\second.xls')worksheet = workbook.sheet_by_index(0)nrows = worksheet.nrowsncols = worksheet.ncolssheets = nrows/float(limit)if not isinstance(sheets,int):    sheets = math.ceil(sheets)title_row = worksheet.row_values(0)for i in range(0, int(sheets)):    writebook = xlwt.Workbook(encoding='utf-8')    writesheet = writebook.add_sheet('sheet1')    for col in range(0, ncols):        writesheet.write(0, col, title_row[col])    for row in range(1, limit+1):        newrow = row+limit*i        if newrow < nrows:            row_content = worksheet.row_values(newrow)            for col in range(0, ncols):                writesheet.write(row, col, row_content[col])    writebook.save(save+'\\'+str(i+1)+'.xls')

转载地址：https://blog.csdn.net/shunjianxaioshi/article/details/111353434 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！