Error: openxlsx can only read .xlsx files while reading .xslm file in R

Question

library(tidyverse)
library(openxlsx)
library(lubridate)
library(readxl)

source("global_config.R")


inputFile <- "../data/census.xlsm"
peopleData <-read.xlsx(inputFile, sheet = "peopleData", startRow = 16 )
view(peopleData)

I am getting the following error Error: openxlsx can only read .xlsx files openxls version 4.2.4 readxl version 1.3.1

Refer to this : https://stackoverflow.com/questions/11215381/does-the-xlsx-package-work-for-xlsm-files-in-r — A DUBEY, Aug 06 '21 at 13:17
Can't we use openxslx package for reading .xslm file @ADUBEY — RasK, Aug 06 '21 at 13:32

score 0 · Answer 1 · answered Aug 06 '21 at 13:16

0

Try using the read.xlsx2() function, described in more detail here: http://cran.r-project.org/web/packages/xlsx/xlsx.pdf

answered Aug 06 '21 at 13:16

DormantAscospore

1

Error: openxlsx can only read .xlsx files while reading .xslm file in R

1 Answers1