pycharm实现上传excel生成word

下载需要的依赖包

pip install openpyxl python-docx flask

main.py文件

from flask import Flask, request, render_templatefrom openpyxl import load_workbookfrom docx import Documentapp = Flask(__name__, template_folder='templates')@app.route('/')def index():    return render_template('index.html')@app.route('/upload', methods=['POST'])def upload():    if 'file' not in request.files:        return "No file part"    file = request.files['file']    if file.filename == '':        return "No selected file"    if file:        excel_data = read_excel(file)        generate_word(excel_data)        return "Word file generated successfully"def read_excel(file):    workbook = load_workbook(file)    sheet = workbook.active    excel_data = [list(row) for row in sheet.iter_rows(values_only=True)]    return excel_datadef generate_word(excel_data):    document = Document()    table = document.add_table(rows=1, cols=len(excel_data[0]))    for i, header in enumerate(excel_data[0]):        table.cell(0, i).text = str(header)    for row_data in excel_data[1:]:        row_cells = table.add_row().cells        for i, cell_value in enumerate(row_data):            row_cells[i].text = str(cell_value)    document.save('output.docx')if __name__ == '__main__':    app.run(debug=True)

template���件夹下index.html文件

（）

            Excel to Word                    Generate Word    

（）