python拆分excel报表_python拆分excel

import xlrd

import xlwt

import math

limit =999

readbook ='netSignDetail.xlsx'

saveBook ='/Users/clairyang/PycharmProjects/untitled/test/netSignNew.xlsx'

saveRoad ='/Users/clairyang/PycharmProjects/untitled/test/netSignNew'

data = xlrd.open_workbook(readbook)

table = data.sheets()[0]

#行数

nrows = table.nrows

#列数

ncols = table.ncols

sheets =  math.ceil(nrows/limit)

workbook =xlwt.Workbook(encoding='ascii')

title =  table.row_values(0)

# print("表头：",title)

for i in range(0,sheets):#每个表

worksheet = workbook.add_sheet('表'+str(i+1))

for rowin range(0,limit):#表里的行数

if (row + limit + (limit-1)*(i-1) < nrows+1):

if (row ==0):#每个表的第一行都是表头