python3.8常用脚本命令

1、jpg转png

from cv2 import imread, imwrite

image = imread("test.jpg", 1)
imwrite("test1.png", image)

2、pdf加密

import pikepdf

pdf = pikepdf.open("test.pdf")
pdf.save('test_encrypt.pdf', encryption=pikepdf.Encryption(owner="12345", user="12345", R=4))
pdf.close()

3、pdf解密

import pikepdf

pdf = pikepdf.open("test_encrypt.pdf", password='12345')
pdf.save("test_decrypt.pdf")
pdf.close()

4、解压文件

注：解压过程中会出现内容中文乱码，以下方法可解决

from zipfile import ZipFile

# 直接解压后的子目录中文文件会乱码
# unzip = ZipFile("file.zip", "r")
# unzip.extractall("output Folder")

# 解压无乱码(参考网址：https://blog.csdn.net/qq_21076851/article/details/122752196)
def support_gbk(zip_file: ZipFile):
    name_to_info = zip_file.NameToInfo
    # copy map first
    for name, info in name_to_info.copy().items():
        real_name = name.encode('cp437').decode('gbk')
        if real_name != name:
            info.filename = real_name
            del name_to_info[name]
            name_to_info[real_name] = info
        return zip_file

unzip = ZipFile("file.zip", "r")
with support_gbk(unzip) as zfp:
    zfp.extractall("output Folder")

5、excel合并

import pandas as pd

# 文件名
filename = "test.xlsx"
# 表格数量
T_sheets = 5

df = []
for i in range(0, T_sheets+1):
    sheet_data = pd.read_excel(filename, sheet_name=i, header=None, engine='openpyxl')
    df.append(sheet_data)

output = "test_merged.xlsx"
df = pd.concat(df)
df.to_excel(output)

6、电脑截屏

方式一：

from mss import mss

with mss() as screenshot:
    screenshot.shot(output='test_screen_shot.png')

方式二：

import PIL.ImageGrab

scr = PIL.ImageGrab.grab()
scr.save("test_screen_shot2.png")

*以上如遇异常需要导包的，请使用 “pip install 包名” 安装插件或依赖包