This internal function processes a single Excel file containing case reports. The function dynamically adapts to the structure of the file based on its type and year.
.jpinfect_read_excel(
file_path,
year = NULL,
sheet_range = NULL,
...,
skip_size_check = FALSE
)A data frame containing processed case reports from the specified file.
A character string specifying the path to the Excel file.
An optional integer specifying the year of the data. If NULL, the year is inferred from the file name.
A vector of integers specifying the sheet range to process. If NULL, it is inferred based on the year.
The function reads data from the specified sheet range using read_excel. It handles specific data formatting
for "sex" and "place" datasets based on file patterns and column structures.
Supported file patterns:
"sex"Files with names containing "11.xls" or "01_1.xls".
"place"Files with names containing "02_1.xls".