Required Libraries
The application depends on the following Python libraries (defined inrequirements.txt):
| Library | Version | Purpose |
|---|---|---|
streamlit | >=1.28.0 | Web framework for the UI |
pandas | >=2.0.0 | Data manipulation, filtering, and lookup logic |
openpyxl | >=3.1.0 | Reading .xlsx / .xls Excel files |
xlsxwriter | >=3.1.0 | Writing and formatting the final Excel outputs |
Built-in Python libraries (base64,io,sys,os,re,datetime) are also used but require no installation.
Installation
1. Clone the repositoryRunning the App
Local Development
http://localhost:8501 and open automatically in your browser.
Production Server
The app runs as a system daemon namedsahyogi on the Linux production server.
For server routing and Cloudflare tunnel details, refer to
server_commands.md.