读取excel表格内容

import pandas as pd


def get_excel_data(file_path):
    try:
        # 读取 Excel 文件
        df = pd.read_excel(file_path)

        # 获取表头
        headers = df.columns.tolist()

        # 获取内容并转换为列表的字典，每一行对应一个字典
        content = df.to_dict(orient='records')

        return {'headers': headers, 'content': content}
    except Exception as e:
        print(f"读取文件时发生错误: {e}")
        return None


if __name__ == "__main__":
    file_path = 'example.xls'
    result = get_excel_data(file_path)
    if result is not None:
        print("表头:", result['headers'])
        print("\n内容:")
        for row in result['content']:
            print(row)

• 生成图片

  from PIL import Image, ImageColor, ImageDraw, ImageFont, ImageFilterdef create_image_with_text(size, color, text, font_path, font_size, text_color, shadow_color, output_path): """ Create a new image of specified size and color with centered text that has a border and shadow. :param size: A tuple con

  2025/01/23
  查看详情

• 获取指定目录下的所有图片信息

  1 获取指定目录下的所有图片信息// 获取指定目录下的所有图片信息 public function getImagesInfo($directory) { $images = []; // 创建递归目录迭代器 $iterator = new \RecursiveIteratorIterator( new \RecursiveDirectoryIterator($directory, \RecursiveDirectoryIterator::SKIP_DOTS), \RecursiveIteratorIterator::LEAVES_ONLY ); // 遍历目录中的每个文件 foreach (

  2024/08/20
  查看详情

• Thinkphp各版本的PHP要求

  ThinkPHP 8.0：运行环境要求PHP8.0+，兼容PHP8.3ThinkPHP 6.1：运行环境要求PHP7.2+，兼容PHP8.1ThinkPHP 6.0：运行环境要求PHP7.2+，兼容PHP8.1ThinkPHP 5.1：运行环境要求PHP5.6+，兼容PHP8.0ThinkPHP 5.0：运行环境要求PHP5.4+，兼容PHP7.3

  2024/08/02
  查看详情