#pdf 轉(zhuǎn) word
from pdf2docx import Converter

def convert_pdf_to_docx(pdf_path, docx_path):
    cv = Converter(pdf_path)
    cv.convert(docx_path, start=0, end=None)
    cv.close()

if __name__ == '__main__':
    pdf_path = 'C:/Users/wangkejun/Desktop/1/結(jié)果1.pdf'  # 輸入的 PDF 文件路徑
    docx_path = 'C:/Users/wangkejun/Desktop/1/結(jié)果2.docx' # 輸出的 Word 文檔路徑
    convert_pdf_to_docx(pdf_path, docx_path)
    print('轉(zhuǎn)換完成！')


# word 轉(zhuǎn) excel
import docx
from openpyxl import Workbook

# 打開 Word 文檔
doc = docx.Document(r'C:/Users/wangkejun/Desktop/1/結(jié)果2.docx')

# 創(chuàng)建一個新的 Excel 文件
workbook = Workbook()
sheet = workbook.active

# 遍歷 Word 文檔中的表格
for table in doc.tables:
    for row in table.rows:
        # 按行遍歷表格并將內(nèi)容寫入 Excel 文件
        data = []
        for cell in row.cells:
            data.append(cell.text)
        sheet.append(data)

# 保存 Excel 文件
workbook.save(r'C:/Users/wangkejun/Desktop/1/結(jié)果3.xlsx')

import os
from openpyxl import load_workbook

def replace_data_in_excel(input_file, output_folder):
    # 加載輸入的 Excel 表
    wb = load_workbook(input_file)
    sheet = wb.active
    
    # 獲取原始數(shù)據(jù)
    data = []
    for row in sheet.iter_rows(values_only=True):
        data.append(list(row))
    
    # 替換數(shù)據(jù)
    for i in range(1, 39):
        # 復(fù)制原始數(shù)據(jù)
        new_data = [row[:] for row in data]
        # 替換特定位置的數(shù)據(jù)
        new_data[1][1] = f"{i}/38"
        
        # 創(chuàng)建新的 Excel 表
        new_wb = load_workbook(input_file)
        new_sheet = new_wb.active
        
        # 更新新的 Excel 表的數(shù)據(jù)
        new_sheet.delete_rows(1, new_sheet.max_row)
        for row in new_data:
            new_sheet.append(row)
        
        # 保存新的 Excel 表
        output_file = os.path.join(output_folder, f"{i}.xlsx")
        new_wb.save(output_file)
    
    print("生成完成！")

if __name__ == '__main__':
    input_file = r'C:/Users/wangkejun/Desktop/1/結(jié)果3.xlsx'  # 輸入的 Excel 表路徑
    output_folder = r'C:/Users/wangkejun/Desktop/1'  # 輸出的文件夾路徑
    
    replace_data_in_excel(input_file, output_folder)

#excel 轉(zhuǎn) word
import os
import openpyxl
from docx import Document
from docx.enum.table import WD_CELL_VERTICAL_ALIGNMENT, WD_ALIGN_VERTICAL

def convert_excel_to_word(input_folder, output_folder):
    # 遍歷輸入文件夾下的所有 Excel 文件
    for file_name in os.listdir(input_folder):
        if file_name.endswith('.xlsx') or file_name.endswith('.xls'):
            # 構(gòu)造輸出文件路徑
            output_file = os.path.join(output_folder, f"{file_name.split('.')[0]}.docx")
            
            # 創(chuàng)建一個新的 Word 文檔
            doc = Document()
            
            # 打開 Excel 文件
            file_path = os.path.join(input_folder, file_name)
            workbook = openpyxl.load_workbook(file_path)
            sheet = workbook.active
            
            # 在 Word 文檔中創(chuàng)建一個表格
            table = doc.add_table(rows=1, cols=sheet.max_column)
            table.autofit = False
            
            # 設(shè)置表格樣式
            table.style = 'Table Grid'
            
            # 將 Excel 單元格數(shù)據(jù)寫入 Word 表格
            for row in sheet.iter_rows(values_only=True):
                new_row = table.add_row().cells
                for i, cell_value in enumerate(row):
                    new_row[i].text = str(cell_value)
            
            # 調(diào)整單元格樣式
            for row in table.rows:
                for cell in row.cells:
                    cell.vertical_alignment = WD_CELL_VERTICAL_ALIGNMENT.CENTER
                    cell.paragraphs[0].paragraph_format.alignment = WD_ALIGN_VERTICAL.CENTER
            
            # 保存 Word 文檔
            doc.save(output_file)
    
    print("轉(zhuǎn)換完成！")

if __name__ == '__main__':
    input_folder = r'C:/Users/wangkejun/Desktop/1/excel'  # 輸入的文件夾路徑
    output_folder = r'C:/Users/wangkejun/Desktop/1/word'  # 輸出的 Word 文件夾路徑
    
    convert_excel_to_word(input_folder, output_folder)


# #word 轉(zhuǎn) pdf
from docx2pdf import convert
import os

def batch_word_to_pdf(input_folder, output_folder):
    # 遍歷輸入文件夾下的所有 Word 文件
    for file_name in os.listdir(input_folder):
        if file_name.endswith('.docx'):
            # 構(gòu)造輸出文件路徑
            output_file = os.path.join(output_folder, f"{file_name.split('.')[0]}.pdf")
            
            # 調(diào)用 docx2pdf 庫的 convert 函數(shù)將 Word 文檔轉(zhuǎn)換為 PDF
            convert(os.path.join(input_folder, file_name), output_file)
    
    print("轉(zhuǎn)換完成！")

if __name__ == '__main__':
    input_folder = r'C:/Users/wangkejun/Desktop/1/word'  # 輸入的文件夾路徑
    output_folder = r'C:/Users/wangkejun/Desktop/1/pdf'  # 輸出的 PDF 文件夾路徑
    
    batch_word_to_pdf(input_folder, output_folder)