phahn
November 15, 2022, 7:08pm
1
I read an excel file with parametrized rmd.
Running Rstudio Server Open Source
Can choose the file from a local directory with
params:
datum: "2022-11-14"
data:
label: "Input dataset:"
value: results.xls
accept: ".xls"
input: file
After modification (prediction from a model) I want to write the file back to the same location. Any ideas?
Thanks
Peter
xlsx::write.xlsx(x, file, sheetName = "Sheet1",
col.names = TRUE, row.names = TRUE, append = FALSE)
phahn
November 16, 2022, 8:47am
3
Thanks. That's not the problem.
As suggested I now save it locally, using openxlsx.
Two advantages: no Java, can modify the date format, which caused problems.
Then I use the export function within the file panel. Then I can use it within my server structure.
Peter
1 Like
system
Closed
December 7, 2022, 8:48am
4
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed. If you have a query related to it or one of the replies, start a new topic and refer back with a link.