openxlsx
openxlsx copied to clipboard
loadWorkbook method does not make workbook object
Hello. When I tried to load my workbook into R, I met error message which I show below.
Expected Behavior
To load the workkbook in environment
Actual Behavior
wb_ex <- openxlsx::loadWorkbook("Daily Report_190503.xlsx") Error in substring(x[ind], so, eo) : invalid multibyte string at '<9d><20>怨좊뵓"/>'
Steps to Reproduce the Problem
(please attach an example xlsx file if possible)
-
install.package - openxlsx
-
load package - openxlsx
-
load workbook
sessionInfo()
-
Session info ------------------------------------------------------------------------- setting value
version R version 3.5.3 (2019-03-11) os Windows 10 x64
system x86_64, mingw32
ui RStudio
language (EN)
collate Korean_Korea.949
ctype Korean_Korea.949
tz Asia/Seoul
date 2019-05-17- Version of openxlsx: 4.1.0
- Version of R: R version 3.5.3 (2019-03-11)
Hi, did you have any ideas?