Workbook class does not work in 1.8

[lz1nwm]

It seems that Workbook class does not work in 1.8.

library(openxlsx2)
df <- data.frame(ID = c(1, 2, 3, 4, 5),
                 var1 = c('a', 'b', 'c', 'd', 'e'),
                 var2 = c(1, 1, 0, 0, 1))
wb <- wb_workbook()

# Working
wb$add_worksheet(sheet = 'A')
wb$add_data(sheet = 'A', x = df, na.strings = NULL)
xl_open(wb, interactive = T)

# Not working
wb <- wb_workbook()
wb_add_worksheet(wb, sheet = 'A')
wb_add_data(wb, sheet = 'A', x = df, na.strings = NULL)
#> Error: Can't add data to a workbook with no worksheet.
#> Did you forget to add a worksheet with `wb_add_worksheet()`?
xl_open(wb, interactive = T)
#> Warning: Workbook does not contain any worksheets. A worksheet will be added.

^{Created on 2024-07-18 with reprex v2.1.1}

Session info

sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#>  setting  value
#>  version  R version 4.3.3 (2024-02-29 ucrt)
#>  system   x86_64, mingw32
#>  ui       RTerm
#>  language (EN)
#>  collate  English_United States.utf8
#>  ctype    English_United States.utf8
#>  date     2024-07-18
#> 
#> ─ Packages ───────────────────────────────────────────────────────────────────
#>  package     * version date (UTC) lib source
#>  cli           3.6.3   2024-06-21 [1] CRAN (R 4.3.3)
#>  digest        0.6.36  2024-06-23 [1] CRAN (R 4.3.3)
#>  evaluate      0.24.0  2024-06-10 [1] CRAN (R 4.3.3)
#>  fastmap       1.2.0   2024-05-15 [1] CRAN (R 4.3.3)
#>  fs            1.6.4   2024-04-25 [1] CRAN (R 4.3.3)
#>  glue          1.7.0   2024-01-09 [1] CRAN (R 4.3.2)
#>  htmltools     0.5.8.1 2024-04-04 [1] CRAN (R 4.3.3)
#>  knitr         1.48    2024-07-07 [1] CRAN (R 4.3.3)
#>  lifecycle     1.0.4   2023-11-07 [1] CRAN (R 4.3.2)
#>  magrittr      2.0.3   2022-03-30 [1] CRAN (R 4.3.0)
#>  openxlsx2   * 1.8     2024-07-07 [1] CRAN (R 4.3.3)
#>  R6            2.5.1   2021-08-19 [1] CRAN (R 4.3.0)
#>  Rcpp          1.0.12  2024-01-09 [1] CRAN (R 4.3.2)
#>  reprex        2.1.1   2024-07-06 [1] CRAN (R 4.3.3)
#>  rlang         1.1.4   2024-06-04 [1] CRAN (R 4.3.3)
#>  rmarkdown     2.27    2024-05-17 [1] CRAN (R 4.3.3)
#>  rstudioapi    0.16.0  2024-03-24 [1] CRAN (R 4.3.3)
#>  sessioninfo   1.2.2   2021-12-06 [1] CRAN (R 4.3.0)
#>  stringi       1.8.4   2024-05-06 [1] CRAN (R 4.3.3)
#>  withr         3.0.0   2024-01-16 [1] CRAN (R 4.3.2)
#>  xfun          0.45    2024-06-16 [1] CRAN (R 4.3.3)
#>  yaml          2.3.9   2024-07-05 [1] CRAN (R 4.3.3)
#>  zip           2.3.1   2024-01-27 [1] CRAN (R 4.3.2)
#> ──────────────────────────────────────────────────────────────────────────────

[JanMarvin]

Hi @lz1nwm ,

you have to assign wrapper functions.

library(openxlsx2)
df <- data.frame(ID = c(1, 2, 3, 4, 5),
                 var1 = c('a', 'b', 'c', 'd', 'e'),
                 var2 = c(1, 1, 0, 0, 1))
wb <- wb_workbook()

# Working
wb$add_worksheet(sheet = 'A')
wb$add_data(sheet = 'A', x = df, na.strings = NULL)
xl_open(wb, interactive = T)

# Also working
wb <- wb_workbook()
wb <- wb_add_worksheet(wb, sheet = 'A')
wb <- wb_add_data(wb, sheet = 'A', x = df, na.strings = NULL)
xl_open(wb, interactive = T)

[lz1nwm]

@JanMarvin sorry for that, I've just replaced in my codes write_data() with wb_add_data() without adding <-...

[JanMarvin]

No worries. This is also mentioned in the basic vignette: https://janmarvin.github.io/openxlsx2/articles/openxlsx2.html

[lz1nwm]

Yes, but maybe this warning was somewhat misleading for me:

Warning message:
'write_data()' is deprecated.
Use 'wb_add_data()' instead.
See help("Deprecated") and help("openxlsx2-deprecated").

Although I knew I had to make an assignment, after reading it I just replaced the functions. write_data() works without assignment.

[JanMarvin]

Ah, got it. Well, it’s working after all!