代码搬运

最新推荐文章于 2024-10-27 14:10:13 发布

原创最新推荐文章于 2024-10-27 14:10:13 发布 · 501 阅读

0 ·

CC 4.0 BY-SA版权

Python 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一个Python脚本，该脚本从Excel文件中读取数据并验证指定路径下的文件是否存在及其大小是否符合要求。此工具适用于自动化文件检查流程。

import xlrd
import os.path

def get_data_from_excel(file_path, sheet_index):
	try:
		data = xlrd.open_workbook(file_path)
	except Exception,e:
		print(str(e))

	table = data.sheets()[sheet_index]
	
	data_list = []
	for rownum in range(1, table.nrows):
		row = table.row_values(rownum)
		if row:
			data_list.append((row[0], row[1], row[2]))
	return data_list

def check_package(data_list, pre_path):
	'''
	OK, return True, else return False
	'''
	rst = True
	for data in data_list:
		all_path = os.path.join(pre_path, data[0])
		if not os.path.exists(all_path):
			print('%s not exist.' % data[0])
			rst = False
			continue
		file_size = os.stat(all_path).st_size
		if data[1] != '' and file_size < int(data[1]) * 1000:
			print('%s size invalid! file size < %d' % (data[0], data[1]))
			rst = False
			continue
		if data[1] != '' and file_size > int(data[2]) * 1000:
			print('%s size invalid! file size > %d' % (data[0], data[2]))
			rst = False
			continue

#get os type
if __name__ == '__main__':
	file_path = 'filelist.xlsx'
	print(get_data_from_excel(file_path, 0))

	#step1:unzip all the package
	#step2:depend the os type,get the required files list
	#step3:check file validation

	#ps:1.delete the orbix files  2.change the convert.xlsx