search

awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
364 stars 79 forks source link

fillMergedCells fails #339

Open mattantaliss opened 6 years ago

mattantaliss commented 6 years ago

Expected Behavior

dput(openxlsx::read.xlsx("MergedCell_Example.xlsx", fillMergedCells = TRUE)) (see attached file below) would give the following output (if stringsAsFactors = FALSE and check.names = FALSE are used when creating the data frame):

structure(list(Hello = "A", World = 1, World = 2, World = 3), .Names = c("Hello", "World", "World", "World"), row.names = c(NA, -1L), class = "data.frame")

Actual Behavior

Error in read.xlsx.default("MergedCell_Example.xlsx", fillMergedCells = TRUE) : Not implemented

Steps to Reproduce the Problem

  1. Put MergedCell_Example.xlsx in your working directory.

  2. Execute dput(openxlsx::read.xlsx("MergedCell_Example.xlsx", fillMergedCells = TRUE))

sessionInfo()

isabelgc commented 6 years ago

I encountered the same problem too