python 拆分excel工作表_python拆分excel脚本

因为需要将一个很大的excel按500条拆分为多个excel，手工操作实在太麻烦，就写了个python小脚本，现在是分为了多个sheet页，使用者可根据自己实际情况修改成多个文件的形式

#!/usr/bin/python

# -*- coding:utf-8 -*-

import xlrd

import xlwt

limit = raw_input('input limit number:')

readbook = raw_input('input excel read path:')

savebook = raw_input('input excel save path:')

if limit == '':

limit = 100 # 默认按100条拆分

print '拆分数量: ' + limit

limit = int(limit)

# '/Users/huqiang/Desktop/shoplist.xls'

data = xlrd.open_workbook(readbook)

# 获取sheet

table = data.sheets()[0]

# 行数

nrows = table.nrows

# 列数

ncols = table.ncols

sheets = nrows / limit

# print str(nrows) + ' ' + str(ncols)

# print table.cell(nrows - 1, ncols - 1).value

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

for i in range(0, sheets):

worksheet = workbook.add_sheet(str(i))

for row in range(0, limit):

row_content = table.row_values(row + (i * 10))

for col in range(0, ncols):

worksheet.write(row, col, row_content[col])

workbook.save(savebook)