Dockerfile

FROM rocker/r-ver:4.3.2

EXPOSE 7860
ENV PORT=7860

RUN apt-get update && apt-get install -y \
    libcurl4-openssl-dev \
    libssl-dev \
    libxml2-dev \
    && rm -rf /var/lib/apt/lists/*

RUN R -e "install.packages(c('shiny','readxl','dlookr','rpivotTable'), repos='https://cloud.r-project.org')"

WORKDIR /app

COPY app.R /app/app.R
COPY STATUS1.xlsx /app/STATUS1.xlsx

CMD ["R", "-e", "shiny::runApp('/app', host='0.0.0.0', port=as.numeric(Sys.getenv('PORT', 7860)))"]