python 拆分excel工作表_Python，简单高效！快速拆分excel表格为多sheet！

# -*- codi

ng: utf-8 -*-

"""

Created on Tue Sep 18 10:54:17 2018

@author: libbyo

"""

import os

import pandas as pd

import openpyxl

def read_excel(filename):

"""读入excel，返回dataFrame"""

df = pd.read_excel(filename, index_col=None, headers = 0, na_values=['NA'])

rows = df.shape[0] """获取行数"""

rw1 = 0

rw2 = 15999 """每个sheet表应分行数"""

i = 1

writer = pd.ExcelWriter(r'e:\testNew.xlsx/xls')"""保存新文件路径"""

for row in range(1,rows+1):

if row%16000==0:

sheetname = 'Sheet' + str(i)

df2=df.loc[rw1:rw2]

df2.to_excel(writer, sheetname)

rw1 += 16000

rw2 += 16000

i += 1

if rw2 >rows:

sheetname = 'Sheet' + str(i)

df2 = df[rw1:rows]

df2.to_excel(writer, sheetname)

writer.save()

return df

if __name__ == '__main__':

print('处理中...')

path = r'e:\test.xlsx/xls' """需处理文件路径"""

read_excel(path)

print('处理完成!')