用Python编写一个可以检测tiff文件页数、尺寸大小、分辨率、是否空白页，可以选择文件夹、输出Excel表的软件代码

在Python中，我们可以使用一些库如`tifffile`, `pandas` 和 `openpyxl` 来实现这个功能。以下是一个简单的示例，说明如何读取TIFF文件信息并将其写入Excel表格：

import os
import tifffile
import pandas as pd
from openpyxl import Workbook

def analyze_tiff_folder(folder_path):
    # 创建DataFrame用于存储结果
    data = {'File': [], 'Page Count': [], 'Width': [], 'Height': [], 'Resolution (dpi)': [], 'Blank Page?': []}

    for filename in os.listdir(folder_path):
        if filename.endswith(".tiff"):
            with tifffile.TiffFile(os.path.join(folder_path, filename)) as tif:
                page_count = len(tif.pages)
                sizes = [page.shape[::-1] for page in tif.pages]
                resolutions = [page.tags['XResolution'].value[0] * page.tags['YResolution'].value[0] for page in tif.pages]

                # 检查是否有空白页，假设所有非全黑像素为非空白
                is_blank = all(sum(page) == 0 for page in tif.pages)

                data['File'].append(filename)
                data['Page Count'].append(page_count)
                data['Width'].extend([size[0] for size in sizes])
                data['Height'].extend([size[1] for size in sizes])
                data['Resolution (dpi)'].extend(resolutions)
                data['Blank Page?'].append(is_blank)

    df = pd.DataFrame(data)
    
    # 创建Excel工作簿并写入数据
    wb = Workbook()
    ws = wb.active
    ws.append(df.columns.tolist())
    ws.append(df.values.tolist())

    output_file = f"{folder_path}_results.xlsx"
    wb.save(output_file)

# 使用函数，传入你要分析的文件夹路径
analyze_tiff_folder("/path/to/your/tiff/folder")