在flask服务中远程读取该Excel的内容:
from flask import Flask, jsonify
import requests
import pandas as pd
import os
import tempfile
app = Flask(__name__)
@app.route('/read_excel', methods=['GET'])
def read_excel():
excel_url = 'https://xxx.xxx.xlsx'
response = requests.get(excel_url)
if response.status_code != 200:
return jsonify({'error': 'Failed to retrieve Excel file'}), 400
with tempfile.NamedTemporaryFile(delete=False) as tmp:
tmp.write(response.content)
tmp_file_path = tmp.name
try:
df = pd.read_excel(tmp_file_path)
data = df.to_json(orient='records')
return jsonify(data)
except Exception as e:
return jsonify({'error': str(e)}), 500
finally:
os.remove(tmp_file_path)
if __name__ == '__main__':
app.run(debug=True)