Update the path to a spreadsheet specified in a workspace — spreadsheet_update_path • rjd3workspace

Update the path to a spreadsheet specified in a workspace

Usage

spreadsheet_update_path(jws, new_path, idx_sap = NULL, idx_sai = NULL)

Arguments

jws: workspace object
new_path: new path to the spreadsheet containing raw data
idx_sap: index (or indices) of the SA-Processing (s) to check
idx_sai: index (or indices) of the SA-Item(s) to check.

Value

This function returns either NULL if the update was successful, or an error.

Details

The spreadsheet file must be a .xlsx file. .xls file are not accepted in JDemetra+ v3.x.

Examples


# ws <- .jws_open(file = "ws_production.xml")
#
# # Update the entire second SA-Processing of the `ws` workspace with a new path
# spreadsheet_update_path(
#     jws = ws,
#     new_path = normalizePath("./data/IPI_nace4.xlsx", mustWork = TRUE),
#     idx_sap = 2L
# )