test.ipynb · 0_0请用洛必达/训练赛7

加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

文件

该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。

克隆/下载

test.ipynb 54.60 KB

{
 "cells": [
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-08-23T11:37:00.495793Z",
     "start_time": "2024-08-23T11:36:59.524232Z"
    }
   },
   "cell_type": "code",
   "source": [
    "import os\n",
    "import csv\n",
    "import win32com.client\n",
    "\n",
    "def extract_tables_and_answers(doc_path):\n",
    "    word = win32com.client.Dispatch(\"Word.Application\")\n",
    "    doc = word.Documents.Open(doc_path)\n",
    "    tables = doc.Tables\n",
    "    info = {}\n",
    "    \n",
    "    # 提取个人信息和测验结果\n",
    "    for table in tables:\n",
    "        if \"账号\" in table.Cell(1, 1).Range.Text:\n",
    "            info['账号'] = table.Cell(1, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['姓名'] = table.Cell(1, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['性别'] = table.Cell(1, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['出生日期'] = table.Cell(2, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['文化程度'] = table.Cell(2, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['机构'] = table.Cell(2, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "        \n",
    "        if \"名称\" in table.Cell(1, 1).Range.Text:\n",
    "            test_results = {}\n",
    "            for row in range(2, table.Rows.Count + 1):\n",
    "                test_name = table.Cell(row, 1).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                original_score = table.Cell(row, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                average_score = table.Cell(row, 3).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                test_results[test_name] = {\n",
    "                    \"原始分\": original_score,\n",
    "                    \"均分\": average_score\n",
    "                }\n",
    "            info['测验结果'] = test_results\n",
    "    \n",
    "    # 提取附答卷部分\n",
    "    answer_sheet = {}\n",
    "    capture_answers = False\n",
    "    current_section = \"\"\n",
    "\n",
    "    for paragraph in doc.Paragraphs:\n",
    "        text = paragraph.Range.Text.strip()\n",
    "\n",
    "        if text.startswith(\"附答卷\"):\n",
    "            capture_answers = True\n",
    "            continue\n",
    "        \n",
    "        if capture_answers:\n",
    "            if text.isdigit() and '.' in text:  # 检测到部分，如\"1.信息应用\"\n",
    "                current_section = text\n",
    "                answer_sheet[current_section] = {}\n",
    "            elif text and text[0].isdigit() and '答案' in text:  # 题目行带有答案\n",
    "                parts = text.split(\"答案：\")\n",
    "                if len(parts) == 2:\n",
    "                    question = parts[0].strip().split('.')[0]  # 提取题目编号\n",
    "                    answer = parts[1].strip().split('.')[0]    # 提取选项\n",
    "                    if current_section:\n",
    "                        answer_sheet[current_section][question] = answer\n",
    "                    else:\n",
    "                        # 处理如果没有当前部分的情况\n",
    "                        answer_sheet[question] = answer\n",
    "\n",
    "    info['附答卷'] = answer_sheet\n",
    "    \n",
    "    # 提取测试耗时信息\n",
    "    for paragraph in doc.Paragraphs:\n",
    "        text = paragraph.Range.Text.strip()\n",
    "        if text.startswith(\"测试耗时\"):\n",
    "            info['测试耗时'] = text.split(\"：\")[-1].strip()\n",
    "            break\n",
    "\n",
    "    doc.Close()\n",
    "    word.Quit()\n",
    "    return info\n",
    "\n",
    "def save_to_csv(info, original_filename):\n",
    "    # 获取文件名（不带扩展名）\n",
    "    base_filename = os.path.splitext(os.path.basename(original_filename))[0]\n",
    "    \n",
    "    # 定义三个不同的文件夹\n",
    "    basic_info_dir = os.path.join(os.getcwd(), \"基本信息\")\n",
    "    test_results_dir = os.path.join(os.getcwd(), \"测验结果\")\n",
    "    answers_dir = os.path.join(os.getcwd(), \"答卷\")\n",
    "\n",
    "    # 创建文件夹\n",
    "    os.makedirs(basic_info_dir, exist_ok=True)\n",
    "    os.makedirs(test_results_dir, exist_ok=True)\n",
    "    os.makedirs(answers_dir, exist_ok=True)\n",
    "\n",
    "    # 保存个人基本信息\n",
    "    basic_info_file = os.path.join(basic_info_dir, base_filename + \".csv\")\n",
    "    with open(basic_info_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"字段\", \"值\"])\n",
    "        for key, value in info.items():\n",
    "            if key != \"测验结果\" and key != \"附答卷\":\n",
    "                writer.writerow([key, value])\n",
    "\n",
    "    # 保存测验结果\n",
    "    test_results_file = os.path.join(test_results_dir, base_filename + \".csv\")\n",
    "    with open(test_results_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"名称\", \"原始分\", \"均分\"])\n",
    "        for key, value in info[\"测验结果\"].items():\n",
    "            writer.writerow([key, value[\"原始分\"], value[\"均分\"]])\n",
    "\n",
    "    # 保存附答卷\n",
    "    answers_file = os.path.join(answers_dir, base_filename + \".csv\")\n",
    "    with open(answers_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"题目编号\", \"选项\"])\n",
    "        for section, questions in info['附答卷'].items():\n",
    "            if isinstance(questions, dict):  # 检查是否为字典\n",
    "                for question, answer in questions.items():\n",
    "                    writer.writerow([question, answer])\n",
    "            else:\n",
    "                writer.writerow([section, questions])\n",
    "\n",
    "    print(f\"文件已分别保存到：\\n{basic_info_dir}\\n{test_results_dir}\\n{answers_dir}\")\n",
    "\n",
    "# 示例文件路径\n",
    "file_path = r'C:\\Users\\Zherui\\Desktop\\Project\\7\\第21题附件\\A组--69名测试者\\A001---职业成熟度量表.doc'\n",
    "info = extract_tables_and_answers(file_path)\n",
    "\n",
    "# 保存为csv文件\n",
    "save_to_csv(info, file_path)\n"
   ],
   "id": "6baf8014c5a9c1b8",
   "outputs": [
    {
     "ename": "com_error",
     "evalue": "(-2147352567, '发生意外。', (0, None, None, None, 0, -2147467259), None)",
     "output_type": "error",
     "traceback": [
      "\u001B[1;31m---------------------------------------------------------------------------\u001B[0m",
      "\u001B[1;31mcom_error\u001B[0m                                 Traceback (most recent call last)",
      "Cell \u001B[1;32mIn[14], line 120\u001B[0m\n\u001B[0;32m    118\u001B[0m \u001B[38;5;66;03m# 示例文件路径\u001B[39;00m\n\u001B[0;32m    119\u001B[0m file_path \u001B[38;5;241m=\u001B[39m \u001B[38;5;124mr\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mC:\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mUsers\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mZherui\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mDesktop\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mProject\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124m7\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124m第21题附件\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mA组--69名测试者\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mA001---大五人格量表.doc\u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m--> 120\u001B[0m info \u001B[38;5;241m=\u001B[39m extract_tables_and_answers(file_path)\n\u001B[0;32m    122\u001B[0m \u001B[38;5;66;03m# 保存为csv文件\u001B[39;00m\n\u001B[0;32m    123\u001B[0m save_to_csv(info, file_path)\n",
      "Cell \u001B[1;32mIn[14], line 26\u001B[0m, in \u001B[0;36mextract_tables_and_answers\u001B[1;34m(doc_path)\u001B[0m\n\u001B[0;32m     24\u001B[0m     test_name \u001B[38;5;241m=\u001B[39m table\u001B[38;5;241m.\u001B[39mCell(row, \u001B[38;5;241m1\u001B[39m)\u001B[38;5;241m.\u001B[39mRange\u001B[38;5;241m.\u001B[39mText\u001B[38;5;241m.\u001B[39mstrip()\u001B[38;5;241m.\u001B[39mreplace(\u001B[38;5;124m'\u001B[39m\u001B[38;5;130;01m\\r\u001B[39;00m\u001B[38;5;130;01m\\x07\u001B[39;00m\u001B[38;5;124m'\u001B[39m, \u001B[38;5;124m'\u001B[39m\u001B[38;5;124m'\u001B[39m)\n\u001B[0;32m     25\u001B[0m     original_score \u001B[38;5;241m=\u001B[39m table\u001B[38;5;241m.\u001B[39mCell(row, \u001B[38;5;241m2\u001B[39m)\u001B[38;5;241m.\u001B[39mRange\u001B[38;5;241m.\u001B[39mText\u001B[38;5;241m.\u001B[39mstrip()\u001B[38;5;241m.\u001B[39mreplace(\u001B[38;5;124m'\u001B[39m\u001B[38;5;130;01m\\r\u001B[39;00m\u001B[38;5;130;01m\\x07\u001B[39;00m\u001B[38;5;124m'\u001B[39m, \u001B[38;5;124m'\u001B[39m\u001B[38;5;124m'\u001B[39m)\n\u001B[1;32m---> 26\u001B[0m     average_score \u001B[38;5;241m=\u001B[39m table\u001B[38;5;241m.\u001B[39mCell(row, \u001B[38;5;241m3\u001B[39m)\u001B[38;5;241m.\u001B[39mRange\u001B[38;5;241m.\u001B[39mText\u001B[38;5;241m.\u001B[39mstrip()\u001B[38;5;241m.\u001B[39mreplace(\u001B[38;5;124m'\u001B[39m\u001B[38;5;130;01m\\r\u001B[39;00m\u001B[38;5;130;01m\\x07\u001B[39;00m\u001B[38;5;124m'\u001B[39m, \u001B[38;5;124m'\u001B[39m\u001B[38;5;124m'\u001B[39m)\n\u001B[0;32m     27\u001B[0m     test_results[test_name] \u001B[38;5;241m=\u001B[39m {\n\u001B[0;32m     28\u001B[0m         \u001B[38;5;124m\"\u001B[39m\u001B[38;5;124m原始分\u001B[39m\u001B[38;5;124m\"\u001B[39m: original_score,\n\u001B[0;32m     29\u001B[0m         \u001B[38;5;124m\"\u001B[39m\u001B[38;5;124m均分\u001B[39m\u001B[38;5;124m\"\u001B[39m: average_score\n\u001B[0;32m     30\u001B[0m     }\n\u001B[0;32m     31\u001B[0m info[\u001B[38;5;124m'\u001B[39m\u001B[38;5;124m测验结果\u001B[39m\u001B[38;5;124m'\u001B[39m] \u001B[38;5;241m=\u001B[39m test_results\n",
      "File \u001B[1;32m<COMObject <unknown>>:2\u001B[0m, in \u001B[0;36mCell\u001B[1;34m(self, Row, Column)\u001B[0m\n",
      "\u001B[1;31mcom_error\u001B[0m: (-2147352567, '发生意外。', (0, None, None, None, 0, -2147467259), None)"
     ]
    }
   ],
   "execution_count": 14
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-08-23T11:38:57.583292Z",
     "start_time": "2024-08-23T11:38:52.334903Z"
    }
   },
   "cell_type": "code",
   "source": [
    "import os\n",
    "import csv\n",
    "import win32com.client\n",
    "\n",
    "def extract_tables_and_answers(doc_path):\n",
    "    word = win32com.client.Dispatch(\"Word.Application\")\n",
    "    doc = word.Documents.Open(doc_path)\n",
    "    tables = doc.Tables\n",
    "    info = {}\n",
    "    \n",
    "    # 提取个人信息和测验结果\n",
    "    for table in tables:\n",
    "        if \"账号\" in table.Cell(1, 1).Range.Text:\n",
    "            info['账号'] = table.Cell(1, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['姓名'] = table.Cell(1, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['性别'] = table.Cell(1, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['出生日期'] = table.Cell(2, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['文化程度'] = table.Cell(2, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['机构'] = table.Cell(2, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "        \n",
    "        if \"名称\" in table.Cell(1, 1).Range.Text:\n",
    "            test_results = {}\n",
    "            for row in range(2, table.Rows.Count + 1):\n",
    "                test_name = table.Cell(row, 1).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                original_score = table.Cell(row, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                test_results[test_name] = {\n",
    "                    \"原始分\": original_score\n",
    "                }\n",
    "            info['测验结果'] = test_results\n",
    "    \n",
    "    # 提取附答卷部分\n",
    "    answer_sheet = {}\n",
    "    capture_answers = False\n",
    "    current_section = \"\"\n",
    "\n",
    "    for paragraph in doc.Paragraphs:\n",
    "        text = paragraph.Range.Text.strip()\n",
    "\n",
    "        if text.startswith(\"附答卷\"):\n",
    "            capture_answers = True\n",
    "            continue\n",
    "        \n",
    "        if capture_answers:\n",
    "            if text.isdigit() and '.' in text:  # 检测到部分，如\"1.神经质（N）\"\n",
    "                current_section = text\n",
    "                answer_sheet[current_section] = {}\n",
    "            elif text and text[0].isdigit() and '答案' in text:  # 题目行带有答案\n",
    "                parts = text.split(\"答案：\")\n",
    "                if len(parts) == 2:\n",
    "                    question = parts[0].strip().split('.')[0]  # 提取题目编号\n",
    "                    answer = parts[1].strip().split('.')[0]    # 提取选项\n",
    "                    if current_section:\n",
    "                        answer_sheet[current_section][question] = answer\n",
    "                    else:\n",
    "                        answer_sheet[question] = answer\n",
    "\n",
    "    info['附答卷'] = answer_sheet\n",
    "    \n",
    "    # 提取测试耗时信息\n",
    "    for paragraph in doc.Paragraphs:\n",
    "        text = paragraph.Range.Text.strip()\n",
    "        if text.startswith(\"测试耗时\"):\n",
    "            info['测试耗时'] = text.split(\"：\")[-1].strip()\n",
    "            break\n",
    "\n",
    "    doc.Close()\n",
    "    word.Quit()\n",
    "    return info\n",
    "\n",
    "def save_to_csv(info, original_filename):\n",
    "    # 获取文件名（不带扩展名）\n",
    "    base_filename = os.path.splitext(os.path.basename(original_filename))[0]\n",
    "    \n",
    "    # 定义三个不同的文件夹\n",
    "    basic_info_dir = os.path.join(os.getcwd(), \"基本信息\")\n",
    "    test_results_dir = os.path.join(os.getcwd(), \"测验结果\")\n",
    "    answers_dir = os.path.join(os.getcwd(), \"答卷\")\n",
    "\n",
    "    # 创建文件夹\n",
    "    os.makedirs(basic_info_dir, exist_ok=True)\n",
    "    os.makedirs(test_results_dir, exist_ok=True)\n",
    "    os.makedirs(answers_dir, exist_ok=True)\n",
    "\n",
    "    # 保存个人基本信息\n",
    "    basic_info_file = os.path.join(basic_info_dir, base_filename + \".csv\")\n",
    "    with open(basic_info_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"字段\", \"值\"])\n",
    "        for key, value in info.items():\n",
    "            if key != \"测验结果\" and key != \"附答卷\":\n",
    "                writer.writerow([key, value])\n",
    "\n",
    "    # 保存测验结果\n",
    "    test_results_file = os.path.join(test_results_dir, base_filename + \".csv\")\n",
    "    with open(test_results_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"名称\", \"原始分\"])\n",
    "        for key, value in info[\"测验结果\"].items():\n",
    "            writer.writerow([key, value[\"原始分\"]])\n",
    "\n",
    "    # 保存附答卷\n",
    "    answers_file = os.path.join(answers_dir, base_filename + \".csv\")\n",
    "    with open(answers_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"题目编号\", \"选项\"])\n",
    "        for section, questions in info['附答卷'].items():\n",
    "            if isinstance(questions, dict):  # 检查是否为字典\n",
    "                for question, answer in questions.items():\n",
    "                    writer.writerow([question, answer])\n",
    "            else:\n",
    "                writer.writerow([section, questions])\n",
    "\n",
    "    print(f\"文件已分别保存到：\\n{basic_info_dir}\\n{test_results_dir}\\n{answers_dir}\")\n",
    "\n",
    "# 示例文件路径\n",
    "file_path = r'C:\\Users\\Zherui\\Desktop\\Project\\7\\第21题附件\\A组--69名测试者\\A001---大五人格量表.doc'\n",
    "info = extract_tables_and_answers(file_path)\n",
    "\n",
    "# 保存为csv文件\n",
    "save_to_csv(info, file_path)\n"
   ],
   "id": "3cd9ac6314fdeb1b",
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n"
     ]
    }
   ],
   "execution_count": 15
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-08-23T11:57:30.309036Z",
     "start_time": "2024-08-23T11:57:23.106810Z"
    }
   },
   "cell_type": "code",
   "source": [
    "import os\n",
    "import csv\n",
    "import win32com.client\n",
    "\n",
    "def extract_tables_and_answers(doc_path):\n",
    "    word = win32com.client.Dispatch(\"Word.Application\")\n",
    "    doc = word.Documents.Open(doc_path)\n",
    "    tables = doc.Tables\n",
    "    info = {}\n",
    "    additional_results = {}\n",
    "\n",
    "    # 提取个人信息和测验结果\n",
    "    for table in tables:\n",
    "        if \"账号\" in table.Cell(1, 1).Range.Text:\n",
    "            info['账号'] = table.Cell(1, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['姓名'] = table.Cell(1, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['性别'] = table.Cell(1, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['出生日期'] = table.Cell(2, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['文化程度'] = table.Cell(2, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "            info['机构'] = table.Cell(2, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "\n",
    "        if \"名称\" in table.Cell(1, 1).Range.Text:\n",
    "            test_results = {}\n",
    "            for row in range(2, table.Rows.Count + 1):\n",
    "                columns = table.Rows(row).Cells.Count\n",
    "                test_name = table.Cell(row, 1).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                original_score = table.Cell(row, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "\n",
    "                if columns >= 3:\n",
    "                    average_score = table.Cell(row, 3).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                else:\n",
    "                    average_score = ''\n",
    "\n",
    "                if columns >= 4:\n",
    "                    reference_diagnosis = table.Cell(row, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                else:\n",
    "                    reference_diagnosis = ''\n",
    "\n",
    "                if columns >= 5:\n",
    "                    standard_deviation = table.Cell(row, 5).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                else:\n",
    "                    standard_deviation = ''\n",
    "\n",
    "                test_results[test_name] = {\n",
    "                    \"原始分\": original_score,\n",
    "                    \"均分\": average_score,\n",
    "                    \"参考诊断\": reference_diagnosis,\n",
    "                    \"均分±标准差\": standard_deviation\n",
    "                }\n",
    "            info['测验结果'] = test_results\n",
    "\n",
    "    # # 提取其他结果信息（如阴性项目数、阳性项目数、阳性项目平均分）\n",
    "    # for paragraph in doc.Paragraphs:\n",
    "    #     text = paragraph.Range.Text.strip()\n",
    "    # \n",
    "    #     if text.startswith(\"阴性项目数\"):\n",
    "    #         additional_results[\"阴性项目数\"] = text.split(\"阴性项目数\")[-1].strip()\n",
    "    #     elif text.startswith(\"阳性项目数\"):\n",
    "    #         additional_results[\"阳性项目数\"] = text.split(\"阳性项目数\")[-1].strip()\n",
    "    #     elif text.startswith(\"阳性项目平均分\"):\n",
    "    #         additional_results[\"阳性项目平均分\"] = text.split(\"阳性项目平均分\")[-1].strip()\n",
    "    # \n",
    "    # info['其他结果'] = additional_results\n",
    "    # \n",
    "    # print(additional_results)\n",
    "\n",
    "    # 提取附答卷部分\n",
    "    answer_sheet = {}\n",
    "    capture_answers = False\n",
    "    current_section = \"\"\n",
    "\n",
    "    for paragraph in doc.Paragraphs:\n",
    "        text = paragraph.Range.Text.strip()\n",
    "\n",
    "        if text.startswith(\"附答卷\"):\n",
    "            capture_answers = True\n",
    "            continue\n",
    "\n",
    "        if capture_answers:\n",
    "            if text.isdigit() and '.' in text:  # 检测到部分，如\"1.躯体化\"\n",
    "                current_section = text\n",
    "                answer_sheet[current_section] = {}\n",
    "            elif text and text[0].isdigit() and '答案' in text:  # 题目行带有答案\n",
    "                parts = text.split(\"答案：\")\n",
    "                if len(parts) == 2:\n",
    "                    question = parts[0].strip().split('.')[0]  # 提取题目编号\n",
    "                    answer = parts[1].strip().split('.')[0]    # 提取选项\n",
    "                    if current_section:\n",
    "                        answer_sheet[current_section][question] = answer\n",
    "                    else:\n",
    "                        answer_sheet[question] = answer\n",
    "\n",
    "    info['附答卷'] = answer_sheet\n",
    "\n",
    "    # 提取测试耗时信息\n",
    "    for paragraph in doc.Paragraphs:\n",
    "        text = paragraph.Range.Text.strip()\n",
    "        if text.startswith(\"测试耗时\"):\n",
    "            info['测试耗时'] = text.split(\"：\")[-1].strip()\n",
    "            break\n",
    "\n",
    "    doc.Close()\n",
    "    word.Quit()\n",
    "    return info\n",
    "\n",
    "def save_to_csv(info, original_filename):\n",
    "    # 获取文件名（不带扩展名）\n",
    "    base_filename = os.path.splitext(os.path.basename(original_filename))[0]\n",
    "\n",
    "    # 定义三个不同的文件夹\n",
    "    basic_info_dir = os.path.join(os.getcwd(), \"基本信息\")\n",
    "    test_results_dir = os.path.join(os.getcwd(), \"测验结果\")\n",
    "    answers_dir = os.path.join(os.getcwd(), \"答卷\")\n",
    "\n",
    "    # 创建文件夹\n",
    "    os.makedirs(basic_info_dir, exist_ok=True)\n",
    "    os.makedirs(test_results_dir, exist_ok=True)\n",
    "    os.makedirs(answers_dir, exist_ok=True)\n",
    "\n",
    "    # 保存个人基本信息\n",
    "    basic_info_file = os.path.join(basic_info_dir, base_filename + \".csv\")\n",
    "    with open(basic_info_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"字段\", \"值\"])\n",
    "        for key, value in info.items():\n",
    "            if key != \"测验结果\" and key != \"附答卷\" and key != \"其他结果\":\n",
    "                writer.writerow([key, value])\n",
    "\n",
    "    # 保存测验结果\n",
    "    test_results_file = os.path.join(test_results_dir, base_filename + \".csv\")\n",
    "    with open(test_results_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"名称\", \"原始分\", \"均分\", \"参考诊断\", \"均分±标准差\"])\n",
    "        for key, value in info[\"测验结果\"].items():\n",
    "            writer.writerow([key, value[\"原始分\"], value[\"均分\"], value[\"参考诊断\"], value[\"均分±标准差\"]])\n",
    "        \n",
    "        # 保存其他结果信息，仅保存一次\n",
    "        if \"其他结果\" in info:\n",
    "            for key, value in info['其他结果'].items():\n",
    "                writer.writerow([key, value])\n",
    "\n",
    "    # 保存附答卷\n",
    "    answers_file = os.path.join(answers_dir, base_filename + \".csv\")\n",
    "    with open(answers_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"题目编号\", \"选项\"])\n",
    "        for section, questions in info['附答卷'].items():\n",
    "            if isinstance(questions, dict):  # 检查是否为字典\n",
    "                for question, answer in questions.items():\n",
    "                    writer.writerow([question, answer])\n",
    "            else:\n",
    "                writer.writerow([section, questions])\n",
    "\n",
    "    print(f\"文件已分别保存到：\\n{basic_info_dir}\\n{test_results_dir}\\n{answers_dir}\")\n",
    "\n",
    "# 示例文件路径\n",
    "file_path = r'C:\\Users\\Zherui\\Desktop\\Project\\7\\第21题附件\\A组--69名测试者\\A001---SCL90.doc'\n",
    "info = extract_tables_and_answers(file_path)\n",
    "\n",
    "# 保存为csv文件\n",
    "save_to_csv(info, file_path)\n"
   ],
   "id": "208fa734f7ed9b14",
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n"
     ]
    }
   ],
   "execution_count": 22
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-08-23T12:12:21.967390Z",
     "start_time": "2024-08-23T12:07:10.946429Z"
    }
   },
   "cell_type": "code",
   "source": [
    "import os\n",
    "import csv\n",
    "import win32com.client\n",
    "\n",
    "def extract_tables_and_answers(doc_path, file_type):\n",
    "    word = win32com.client.Dispatch(\"Word.Application\")\n",
    "    doc = word.Documents.Open(doc_path)\n",
    "    tables = doc.Tables\n",
    "    info = {}\n",
    "\n",
    "    if file_type == \"职业成熟度量表\":\n",
    "        for table in tables:\n",
    "            if \"账号\" in table.Cell(1, 1).Range.Text:\n",
    "                info['账号'] = table.Cell(1, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['姓名'] = table.Cell(1, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['性别'] = table.Cell(1, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['出生日期'] = table.Cell(2, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['文化程度'] = table.Cell(2, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['机构'] = table.Cell(2, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "\n",
    "            if \"名称\" in table.Cell(1, 1).Range.Text:\n",
    "                test_results = {}\n",
    "                for row in range(2, table.Rows.Count + 1):\n",
    "                    test_name = table.Cell(row, 1).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                    original_score = table.Cell(row, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                    average_score = table.Cell(row, 3).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                    test_results[test_name] = {\n",
    "                        \"原始分\": original_score,\n",
    "                        \"均分\": average_score\n",
    "                    }\n",
    "                info['测验结果'] = test_results\n",
    "\n",
    "    elif file_type == \"大五人格量表\":\n",
    "        for table in tables:\n",
    "            if \"账号\" in table.Cell(1, 1).Range.Text:\n",
    "                info['账号'] = table.Cell(1, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['姓名'] = table.Cell(1, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['性别'] = table.Cell(1, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['出生日期'] = table.Cell(2, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['文化程度'] = table.Cell(2, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['机构'] = table.Cell(2, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "\n",
    "            if \"名称\" in table.Cell(1, 1).Range.Text:\n",
    "                test_results = {}\n",
    "                for row in range(2, table.Rows.Count + 1):\n",
    "                    test_name = table.Cell(row, 1).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                    original_score = table.Cell(row, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                    test_results[test_name] = {\n",
    "                        \"原始分\": original_score\n",
    "                    }\n",
    "                info['测验结果'] = test_results\n",
    "\n",
    "    elif file_type == \"SCL90\":\n",
    "        additional_results = {}\n",
    "        for table in tables:\n",
    "            if \"账号\" in table.Cell(1, 1).Range.Text:\n",
    "                info['账号'] = table.Cell(1, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['姓名'] = table.Cell(1, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['性别'] = table.Cell(1, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['出生日期'] = table.Cell(2, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['文化程度'] = table.Cell(2, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                info['机构'] = table.Cell(2, 6).Range.Text.strip().replace('\\r\\x07', '')\n",
    "\n",
    "            if \"名称\" in table.Cell(1, 1).Range.Text:\n",
    "                test_results = {}\n",
    "                for row in range(2, table.Rows.Count + 1):\n",
    "                    columns = table.Rows(row).Cells.Count\n",
    "                    test_name = table.Cell(row, 1).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                    original_score = table.Cell(row, 2).Range.Text.strip().replace('\\r\\x07', '')\n",
    "\n",
    "                    if columns >= 3:\n",
    "                        average_score = table.Cell(row, 3).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                    else:\n",
    "                        average_score = ''\n",
    "\n",
    "                    if columns >= 4:\n",
    "                        reference_diagnosis = table.Cell(row, 4).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                    else:\n",
    "                        reference_diagnosis = ''\n",
    "\n",
    "                    if columns >= 5:\n",
    "                        standard_deviation = table.Cell(row, 5).Range.Text.strip().replace('\\r\\x07', '')\n",
    "                    else:\n",
    "                        standard_deviation = ''\n",
    "\n",
    "                    test_results[test_name] = {\n",
    "                        \"原始分\": original_score,\n",
    "                        \"均分\": average_score,\n",
    "                        \"参考诊断\": reference_diagnosis,\n",
    "                        \"均分±标准差\": standard_deviation\n",
    "                    }\n",
    "                info['测验结果'] = test_results\n",
    "\n",
    "    # 提取附答卷部分\n",
    "    answer_sheet = {}\n",
    "    capture_answers = False\n",
    "    current_section = \"\"\n",
    "\n",
    "    for paragraph in doc.Paragraphs:\n",
    "        text = paragraph.Range.Text.strip()\n",
    "\n",
    "        if text.startswith(\"附答卷\"):\n",
    "            capture_answers = True\n",
    "            continue\n",
    "\n",
    "        if capture_answers:\n",
    "            if text.isdigit() and '.' in text:\n",
    "                current_section = text\n",
    "                answer_sheet[current_section] = {}\n",
    "            elif text and text[0].isdigit() and '答案' in text:\n",
    "                parts = text.split(\"答案：\")\n",
    "                if len(parts) == 2:\n",
    "                    question = parts[0].strip().split('.')[0]\n",
    "                    answer = parts[1].strip().split('.')[0]\n",
    "                    if current_section:\n",
    "                        answer_sheet[current_section][question] = answer\n",
    "                    else:\n",
    "                        answer_sheet[question] = answer\n",
    "\n",
    "    info['附答卷'] = answer_sheet\n",
    "\n",
    "    # 提取测试耗时信息\n",
    "    for paragraph in doc.Paragraphs:\n",
    "        text = paragraph.Range.Text.strip()\n",
    "        if text.startswith(\"测试耗时\"):\n",
    "            info['测试耗时'] = text.split(\"：\")[-1].strip()\n",
    "            break\n",
    "\n",
    "    doc.Close()\n",
    "    word.Quit()\n",
    "    return info\n",
    "\n",
    "def save_to_csv(info, original_filename, file_type):\n",
    "    base_filename = os.path.splitext(os.path.basename(original_filename))[0]\n",
    "    basic_info_dir = os.path.join(os.getcwd(), \"基本信息\")\n",
    "    test_results_dir = os.path.join(os.getcwd(), \"测验结果\")\n",
    "    answers_dir = os.path.join(os.getcwd(), \"答卷\")\n",
    "\n",
    "    os.makedirs(basic_info_dir, exist_ok=True)\n",
    "    os.makedirs(test_results_dir, exist_ok=True)\n",
    "    os.makedirs(answers_dir, exist_ok=True)\n",
    "\n",
    "    # 保存个人基本信息\n",
    "    basic_info_file = os.path.join(basic_info_dir, base_filename + \".csv\")\n",
    "    with open(basic_info_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"字段\", \"值\"])\n",
    "        for key, value in info.items():\n",
    "            if key not in [\"测验结果\", \"附答卷\", \"其他结果\"]:\n",
    "                writer.writerow([key, value])\n",
    "\n",
    "    # 保存测验结果\n",
    "    test_results_file = os.path.join(test_results_dir, base_filename + \".csv\")\n",
    "    with open(test_results_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        if file_type == \"SCL90\":\n",
    "            writer.writerow([\"名称\", \"原始分\", \"均分\", \"参考诊断\", \"均分±标准差\"])\n",
    "            for key, value in info[\"测验结果\"].items():\n",
    "                writer.writerow([key, value[\"原始分\"], value[\"均分\"], value[\"参考诊断\"], value[\"均分±标准差\"]])\n",
    "        elif file_type == \"职业成熟度量表\":\n",
    "            writer.writerow([\"名称\", \"原始分\", \"均分\"])\n",
    "            for key, value in info[\"测验结果\"].items():\n",
    "                writer.writerow([key, value[\"原始分\"], value[\"均分\"]])\n",
    "        elif file_type == \"大五人格量表\":\n",
    "            writer.writerow([\"名称\", \"原始分\"])\n",
    "            for key, value in info[\"测验结果\"].items():\n",
    "                writer.writerow([key, value[\"原始分\"]])\n",
    "\n",
    "    # 保存附答卷\n",
    "    answers_file = os.path.join(answers_dir, base_filename + \".csv\")\n",
    "    with open(answers_file, mode='w', newline='', encoding='utf-8') as file:\n",
    "        writer = csv.writer(file)\n",
    "        writer.writerow([\"题目编号\", \"选项\"])\n",
    "        for section, questions in info['附答卷'].items():\n",
    "            if isinstance(questions, dict):\n",
    "                for question, answer in questions.items():\n",
    "                    writer.writerow([question, answer])\n",
    "            else:\n",
    "                writer.writerow([section, questions])\n",
    "\n",
    "    print(f\"文件已分别保存到：\\n{basic_info_dir}\\n{test_results_dir}\\n{answers_dir}\")\n",
    "\n",
    "def process_folder(folder_path):\n",
    "    for filename in os.listdir(folder_path):\n",
    "        if filename.endswith(\".doc\") or filename.endswith(\".docx\"):\n",
    "            file_path = os.path.join(folder_path, filename)\n",
    "\n",
    "            if \"职业成熟度量表\" in filename:\n",
    "                file_type = \"职业成熟度量表\"\n",
    "            elif \"大五人格量表\" in filename:\n",
    "                file_type = \"大五人格量表\"\n",
    "            elif \"SCL90\" in filename:\n",
    "                file_type = \"SCL90\"\n",
    "            else:\n",
    "                print(f\"未识别的文件类型: {filename}\")\n",
    "                continue\n",
    "\n",
    "            info = extract_tables_and_answers(file_path, file_type)\n",
    "            save_to_csv(info, file_path, file_type)\n",
    "\n",
    "# 示例文件夹路径\n",
    "folder_path = r'C:\\Users\\Zherui\\Desktop\\Project\\7\\第21题附件\\A组--69名测试者'\n",
    "process_folder(folder_path)\n"
   ],
   "id": "c3e39534f0bea331",
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n",
      "文件已分别保存到：\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\基本信息\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\测验结果\n",
      "C:\\Users\\Zherui\\Desktop\\Project\\7\\答卷\n"
     ]
    },
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001B[1;31m---------------------------------------------------------------------------\u001B[0m",
      "\u001B[1;31mKeyboardInterrupt\u001B[0m                         Traceback (most recent call last)",
      "Cell \u001B[1;32mIn[24], line 203\u001B[0m\n\u001B[0;32m    201\u001B[0m \u001B[38;5;66;03m# 示例文件夹路径\u001B[39;00m\n\u001B[0;32m    202\u001B[0m folder_path \u001B[38;5;241m=\u001B[39m \u001B[38;5;124mr\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mC:\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mUsers\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mZherui\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mDesktop\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mProject\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124m7\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124m第21题附件\u001B[39m\u001B[38;5;124m\\\u001B[39m\u001B[38;5;124mA组--69名测试者\u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m--> 203\u001B[0m process_folder(folder_path)\n",
      "Cell \u001B[1;32mIn[24], line 198\u001B[0m, in \u001B[0;36mprocess_folder\u001B[1;34m(folder_path)\u001B[0m\n\u001B[0;32m    195\u001B[0m     \u001B[38;5;28mprint\u001B[39m(\u001B[38;5;124mf\u001B[39m\u001B[38;5;124m\"\u001B[39m\u001B[38;5;124m未识别的文件类型: \u001B[39m\u001B[38;5;132;01m{\u001B[39;00mfilename\u001B[38;5;132;01m}\u001B[39;00m\u001B[38;5;124m\"\u001B[39m)\n\u001B[0;32m    196\u001B[0m     \u001B[38;5;28;01mcontinue\u001B[39;00m\n\u001B[1;32m--> 198\u001B[0m info \u001B[38;5;241m=\u001B[39m extract_tables_and_answers(file_path, file_type)\n\u001B[0;32m    199\u001B[0m save_to_csv(info, file_path, file_type)\n",
      "Cell \u001B[1;32mIn[24], line 124\u001B[0m, in \u001B[0;36mextract_tables_and_answers\u001B[1;34m(doc_path, file_type)\u001B[0m\n\u001B[0;32m    122\u001B[0m \u001B[38;5;66;03m# 提取测试耗时信息\u001B[39;00m\n\u001B[0;32m    123\u001B[0m \u001B[38;5;28;01mfor\u001B[39;00m paragraph \u001B[38;5;129;01min\u001B[39;00m doc\u001B[38;5;241m.\u001B[39mParagraphs:\n\u001B[1;32m--> 124\u001B[0m     text \u001B[38;5;241m=\u001B[39m paragraph\u001B[38;5;241m.\u001B[39mRange\u001B[38;5;241m.\u001B[39mText\u001B[38;5;241m.\u001B[39mstrip()\n\u001B[0;32m    125\u001B[0m     \u001B[38;5;28;01mif\u001B[39;00m text\u001B[38;5;241m.\u001B[39mstartswith(\u001B[38;5;124m\"\u001B[39m\u001B[38;5;124m测试耗时\u001B[39m\u001B[38;5;124m\"\u001B[39m):\n\u001B[0;32m    126\u001B[0m         info[\u001B[38;5;124m'\u001B[39m\u001B[38;5;124m测试耗时\u001B[39m\u001B[38;5;124m'\u001B[39m] \u001B[38;5;241m=\u001B[39m text\u001B[38;5;241m.\u001B[39msplit(\u001B[38;5;124m\"\u001B[39m\u001B[38;5;124m：\u001B[39m\u001B[38;5;124m\"\u001B[39m)[\u001B[38;5;241m-\u001B[39m\u001B[38;5;241m1\u001B[39m]\u001B[38;5;241m.\u001B[39mstrip()\n",
      "File \u001B[1;32mC:\\ProgramData\\anaconda3\\Lib\\site-packages\\win32com\\client\\dynamic.py:628\u001B[0m, in \u001B[0;36mCDispatch.__getattr__\u001B[1;34m(self, attr)\u001B[0m\n\u001B[0;32m    624\u001B[0m debug_attr_print(\n\u001B[0;32m    625\u001B[0m     \u001B[38;5;124m\"\u001B[39m\u001B[38;5;124mGetting property Id 0x\u001B[39m\u001B[38;5;132;01m%x\u001B[39;00m\u001B[38;5;124m from OLE object\u001B[39m\u001B[38;5;124m\"\u001B[39m \u001B[38;5;241m%\u001B[39m retEntry\u001B[38;5;241m.\u001B[39mdispid\n\u001B[0;32m    626\u001B[0m )\n\u001B[0;32m    627\u001B[0m \u001B[38;5;28;01mtry\u001B[39;00m:\n\u001B[1;32m--> 628\u001B[0m     ret \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_oleobj_\u001B[38;5;241m.\u001B[39mInvoke(retEntry\u001B[38;5;241m.\u001B[39mdispid, \u001B[38;5;241m0\u001B[39m, invoke_type, \u001B[38;5;241m1\u001B[39m)\n\u001B[0;32m    629\u001B[0m \u001B[38;5;28;01mexcept\u001B[39;00m pythoncom\u001B[38;5;241m.\u001B[39mcom_error \u001B[38;5;28;01mas\u001B[39;00m details:\n\u001B[0;32m    630\u001B[0m     \u001B[38;5;28;01mif\u001B[39;00m details\u001B[38;5;241m.\u001B[39mhresult \u001B[38;5;129;01min\u001B[39;00m ERRORS_BAD_CONTEXT:\n\u001B[0;32m    631\u001B[0m         \u001B[38;5;66;03m# May be a method.\u001B[39;00m\n",
      "\u001B[1;31mKeyboardInterrupt\u001B[0m: "
     ]
    }
   ],
   "execution_count": 24
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}

一键复制编辑原始数据按行查看历史

提交于 2024-08-23 22:46 . 1

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

https://gitee.com/zhangzherui666/training-competition-7.git

git@gitee.com:zhangzherui666/training-competition-7.git

zhangzherui666

training-competition-7

训练赛7

master

0_0请用洛必达/训练赛7

简介

发行版

贡献者

近期动态

0_0请用洛必达/训练赛7 .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

0_0请用洛必达/训练赛7