r - R Shiny不读取文件路径

Question

标签： rshinyreadxl

Answer 1

The error here was in

# list of quarterly earnings worksheets
file_paths <- list.files('dashboard/data', pattern = 'xlsx', full.names = TRUE)

When the shiny app was running it was operating from the data folder as the working directory when running source("data/import_finance.R").

To accommodate simply

# list of quarterly earnings worksheets
file_paths <- list.files('data', pattern = 'xlsx', full.names = TRUE)