openxlsx icon indicating copy to clipboard operation
openxlsx copied to clipboard

loadWorkbook method does not make workbook object

Open RiceAndWheat opened this issue 6 years ago • 1 comments

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)

  1. install.package - openxlsx

  2. load package - openxlsx

  3. 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)

RiceAndWheat avatar May 17 '19 04:05 RiceAndWheat

Hi, did you have any ideas?

huxinwen65 avatar Feb 19 '20 01:02 huxinwen65