pip install flask flask-cors pandas openpyxl from flask import Flask, jsonify from flask_cors import CORS import pandas as pd app = Flask(__name__) CORS(app) FILE = 'GG_INBOUND_WIP-_2025.xlsx' def load(sheet): df = pd.read_excel(FILE, sheet_name=sheet, header=1).iloc[1:] df.columns = ['CUSTOMER','TYPE','CONTAINER_NUM','CUSTOMER_REF','TOTAL_BOXES', 'TOTAL_SEPARATIONS','LUMPERS_NEEDED','LUMPERS_REQUESTED','PACKING_LIST_RECEIVED', 'EDI_943_RECEIVED_DATE','FIRST_ALERT','FIRST_AVAILABLE_DATE','LAST_FREE_DATE', 'APPT_DATE','SEAL_NUMBER','RECEIVED_DATE','RECEIVING_COMPLETE','EDI_944_SENT', 'SENT_TO_BILLING','BILLING_COMPLETE','COMMENTS'] for c in df.select_dtypes('datetime64').columns: df[c] = df[c].dt.strftime('%Y-%m-%d') df['STATUS'] = sheet return df.fillna('').to_dict('records') @app.route('/data') def data(): return jsonify(load('OPEN') + load('COMPLETE')) if __name__ == '__main__': app.run(port=5050)