题目1
自动化学习打卡day1
编写一个python程序:
1.找出当前目录下所有的.zip文件
2.将所有文件重命名,在原本的开头加上最后的修改时期
1.比如原来是projects.zip 则改为2019-09-10-projects.zip
3.创建一个新的文件夹名叫backup
4.将所有重命名后的文件都移动到backup文件夹里面
print('test.txt'.startswith('test'))
print('test.txt'.endswith('.txt'))
print(time.ctime(1588853694))
that_time = datetime.datetime.fromtimestamp(1588853694)
print(that_time)
print(that_time.hour,that_time.minute,that_time.second)
for file in os.scandir():
print(file.name,file.stat().st_size)
答题1:
import os,time
import datetime,shutil
import fnmatch
for file in os.scandir('./'):
if file.name.endswith('zip') == True:
if not os.path.exists('backup'):
os.mkdir('backup')
that_time = datetime.datetime.fromtimestamp(file.stat().st_atime)
date_time = '%s-%s-%s-' % (that_time.year,that_time.month,that_time.day)
os.rename(file.name,'%s%s'%(date_time,file.name))
data = ('%s%s' % (date_time, file.name))
shutil.move(data,'backup')
print('done......')
day2 Excel处理
row
sheet
load_workbook(filename=表格文件路径)
workbook.sheetnames 获取表格文件内的sheet名称
workbook.active
sheet['A1']
cell.value
.row 行数
.column
.coordinate
.rows
ex:
for row in sheet.rows:
print(row)
sell =(row=行数,column=列数)
.iter_rows(min_row=最低行数,max_row=最高行数,min_col=最低列数,max_col=最搞列数)
sells = sheet['A1:A5']
for col in sheet.iter_cols(min_row=2,max_row=10,min_col=1,max_col=4):
for cell in col:
print(cell)
题目2
编写一个python程序
1,打开XXXX文.xlsx Excel文件
2.找到空着的格子
3.输出这些格子的坐标,如A1,C10等
答题2
from openpyxl import load_workbook
思路:先打开表格,列出所有的表,for循环遍历判断如果是IF=None就输出坐标
workbook = load_workbook(filename='5.2testexect.xlsx')
sheet = workbook.active
for row in sheet.iter_rows():
for cell in row:
if cell.value==None:
print(cell)
--------------------------
from openpyxl import load_workbook
for row in sheet.iter_rows(min_row=1,max_row=40,min_col=1,max_col=7):
for cell in row:
if cell.value==None:
print(cell)