代码搬运

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