'''
Author: yanghaihong yanghaihong@feicun.com
Date: 2023-01-04 17:26:09
LastEditors: yanghaihong yanghaihong@feicun.com
LastEditTime: 2023-01-05 15:33:24
FilePath: /Python-excel-master/readExcel.py
Description: 这是默认设置,请设置`customMade`, 打开koroFileHeader查看配置 进行设置: https://github.com/OBKoro1/koro1FileHeader/wiki/%E9%85%8D%E7%BD%AE
'''
import xlrd
import xlwt
import os
import shutil
#!/usr/bin/env python
# -*- coding:utf-8 -*-
"""
@Author :xxxxx
@Contact :1223242863@qq.com
@File :zip.py
@Time :2021/8/17 11:27 PM
@Software :Pycharm
@Copyright (c) 2021,All Rights Reserved.
"""
import os
import zipfile
from loguru import logger
def getZipDir(dirpath, outFullName):
"""
压缩指定文件夹
:param dirpath: 目标文件夹路径
:param outFullName: 压缩文件保存路径+xxxx.zip
:return: 无
"""
zip = zipfile.ZipFile(outFullName, "w", zipfile.ZIP_BZIP2)
for path, dirnames, filenames in os.walk(dirpath):
# 去掉目标跟路径，只对目标文件夹下边的文件及文件夹进行压缩
fpath = path.replace(dirpath, '')
for filename in filenames:
zip.write(os.path.join(path, filename), os.path.join(fpath, filename))
zip.close()
logger.info("文件夹\"{0}\"已压缩为\"{1}\".".format(dirpath, outFullName))
# if __name__ == "__main__":
# getZipDir(dirpath=r"C:\Users\XZD\Documents\录音",
# outFullName=r"C:\Users\XZD\Documents\录音.zip")
import os
def mkdir(path):
folder = os.path.exists(path)
if not folder: #判断是否存在文件夹如果不存在则创建为文件夹
os.makedirs(path) #makedirs 创建文件时如果路径不存在会创建这个路径
print ("--- new folder... ---")
print ("--- OK ---")
else:
print ("--- There is this folder! ---")
# file = "G:\\xxoo\\test"
# mkdir(file) #调用函数
image_path = r'Y:\共享文件夹\_模型素材库\素材库'
# 遍历文件夹及其子文件夹中的文件，并存储在一个列表中
# 输入文件夹路径、空文件列表[]
# 返回 文件列表Filelist,包含文件名（完整路径）
def get_filelist(dir, Filelist, targetModelName):
newDir = dir
if os.path.isfile(dir):
dir = dir.lower()
# ttmp_idx2 = dir.find("fbx\\")
# ttmp_idx1 = dir.find(".fbx")
# ttmp_idx = dir.find("\\" + targetModelName + "\\")
# if ttmp_idx > -1 and ttmp_idx2 == -1 and ttmp_idx1 > -1:
# Filelist.append(dir)
# # 若只是要返回文件文，使用这个
# Filelist.append(os.path.basename(dir))
elif os.path.isdir(dir):
dir = dir.lower()
ttmp_idx1 = dir.find(".mayaswatches")
ttmp_idx2 = dir.find("fbx")
if ttmp_idx1 == -1 and ttmp_idx2 > -1 :
print("dir " + dir)
widx = dir.find("共享文件夹")
newstr = dir[widx:len(dir)]
targetZip = "E:\\" + newstr
if not os.path.exists(targetZip):
mkdir(targetZip)
getZipDir(dir,targetZip + ".zip")
for s in os.listdir(dir):
# 如果需要忽略某些文件夹，使用以下代码
#if s == "xxx":
#continue
newDir=os.path.join(dir,s)
get_filelist(newDir, Filelist, targetModelName)
return Filelist
xlsx_path = r'C:\Users\XZD\Documents\Tencent Files\2893764123\FileRecv\model.xlsx'
file_path = r'E:\models'
list = get_filelist(image_path, [],"")
# # 使用xlrd模块的open_workbook函数打开指定Excel文件并获得Book对象（工作簿）
# wb = xlrd.open_workbook(xlsx_path)
# # 通过Book对象的sheet_names方法可以获取所有表单名称
# sheetnames = wb.sheet_names()
# print(sheetnames)
# # 通过指定的表单名称获取Sheet对象（工作表）
# sheet = wb.sheet_by_name(sheetnames[0])
# # 通过Sheet对象的nrows和ncols属性获取表单的行数和列数
# # print(sheet.nrows, sheet.ncols)
# for row in range(sheet.nrows):
# for col in range(sheet.ncols):
# # 通过Sheet对象的cell方法获取指定Cell对象（单元格）
# # 通过Cell对象的value属性获取单元格中的值
# if row <= start_idx :
# continue
# value = sheet.cell(row, col).value
# if col == 3 and row > 0:
# value1 = sheet.cell(row, 0).value
# id_model = int(value1)
# print(id_model)
# list = get_filelist(image_path, [],value)
# # for file in list:
# # print("find: " + file)
# # source = file
# # target = file_path + "\\" + str(id_model) + ".fbx"
# # try:
# # shutil.copy(source, target)
# # except IOError as e:
# # print("Unable to copy file. %s" % e)
# # except:
# # print("Unexpected error:", sys.exc_info())
# # # 下载 重命名
# print()
# 将学生姓名和考试成绩写入单元格
# for row in range(len(scores)):
# sheet.write(row + 1, 0, student_names[row])
# for col in range(len(scores[row])):
# sheet.write(row + 1, col + 1, scores[row][col])
# # 保存Excel工作簿
# wb.save('考试成绩表.xlsx')
# 获取最后一个单元格的数据类型
# 0 - 空值，1 - 字符串，2 - 数字，3 - 日期，4 - 布尔，5 - 错误
# last_cell_type = sheet.cell_type(sheet.nrows - 1, sheet.ncols - 1)
# print(last_cell_type)
# 获取第一行的值（列表）
# print(sheet.row_values(0))
# 获取指定行指定列范围的数据（列表）
# 第一个参数代表行索引，第二个和第三个参数代表列的开始（含）和结束（不含）索引
# print(sheet.row_slice(3, 0, 5))
