import os, xlrd, xlsxwriter
from datetime import datetime
from xlrd import xldate_as_tuple
#from openpyxl import load_workbook
#olddir = raw_input("the old path: ")
#newdir = raw_input("the new path and filename: ")
olddir = r'f:\datas'
newdir = r'f:\datas1'
paths = []
col_week_ending_day = 3 #日期所在列
col_state = 4 #国家所在列
col_category = 5 #品类所在列
col_saler = 10 #销量所在列
for root, dirs, files in os.walk(olddir): #获取文件夹下所有文件路径
for file in files:
paths.append(os.path.join(root, file).decode('gbk')) #支持中文名称
for path in paths:
workbook = xlrd.open_workbook(path) #根据路径打开工作簿
booksheet = workbook.sheets()[0] #打开工作簿里的工作表
nrows = booksheet.nrows #获取工作表数据行数
ncols = booksheet.ncols #获取工作表数据列数
filenames = []
for i in range(nrows):
if i == 0:
continue #忽略首行
week_ending_day = booksheet.row_values(i)[col_week_ending_day]
date = datetime(*xldate_as_tuple(week_ending_day,0))
week_ending_d
Python将xlsx文件中的数据按某几列拆分成多个新的xlsx文件
最新推荐文章于 2025-06-29 16:31:18 发布