import streamlit as st import pandas as pd import numpy as np from pathlib import Path import time from openpyxl import load_workbook from filelock import FileLock import base64 # Configuration MAX_FILE_SIZE_MB = 100 DEFAULT_PREVIEW_ROWS = 50 # Define COLORS for highlighting COLORS = ['#ff6666', '#66b3ff', '#99ff99', '#ffcc99', '#cc99ff'] # Helper functions def get_subdirs(base_path): return [d for d in base_path.iterdir() if d.is_dir()] def process_excel_header(header): if not header: return...