下载需要的依赖包
pip install openpyxl python-docx flask
main.py文件
word">from flask word">import Flask, request, render_template
word">from openpyxl word">import load_workbook
word">from docx word">import Document
app = Flask(__name__, template_folder='templates')
@app.route('/')
word">def index():
word">return render_template('index.html')
@app.route('/upload', methods=['POST'])
word">def upload():
word">if 'file' word">not word">in request.files:
word">return "No file part"
file = request.files['file']
word">if file.filename == '':
word">return "No selected file"
word">if file:
excel_data = read_excel(file)
generate_word(excel_data)
word">return "Word file generated successfully"
word">def read_excel(file):
workbook = load_workbook(file)
sheet = workbook.active
excel_data = [list(row) word">for row word">in sheet.iter_rows(values_only=True)]
word">return excel_data
word">def generate_word(excel_data):
document = Document()
table = document.add_table(rows=1, cols=len(excel_data[0]))
word">for i, header word">in enumerate(excel_data[0]):
table.cell(0, i).text = str(header)
word">for row_data word">in excel_data[1:]:
row_cells = table.add_row().cells
word">for i, cell_value word">in enumerate(row_data):
row_cells[i].text = str(cell_value)
document.save('output.docx')
word">if __name__ == '__main__':
app.run(debug=True)
template文件夹下index.html文件
<!-- index.html -->
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Excel to Word</title>
</head>
<body>
<form method="POST" enctype="multipart/form-data" action="/upload">
<input type="file" name="file" accept=".xlsx, .xls">
<button type="submit">Generate Word</button>
</form>
</body>
</html>
