search

awalker89 / openxlsx

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

Add support for RTD (Real Time Data) function creation #532

Open allanvc opened 3 years ago

allanvc commented 3 years ago

Thank you for this excellent package. Would it be possible to add support for creating cells with the RTD function?

Example:

form <- 'RTD("rtdtrading.rtdserver";; "ASSET_B_0"; "ULT")' class(form) <- c(class(form), "formula") wb <- createWorkbook() addWorksheet(wb, "RTD") writeData(wb, sheet = 1, x = form)

In the current version of openxlsx, excel does not recognize the RTD function created in openxlsx.

sessionInfo()

R version 4.0.3 (2020-10-10) Platform: x86_64-pc-linux-gnu (64-bit) Running under: Ubuntu 20.04.1 LTS

Matrix products: default BLAS: /usr/lib/x86_64-linux-gnu/blas/libblas.so.3.9.0 LAPACK: /usr/lib/x86_64-linux-gnu/lapack/liblapack.so.3.9.0

locale: [1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C LC_TIME=en_US.UTF-8
[4] LC_COLLATE=en_US.UTF-8 LC_MONETARY=en_US.UTF-8 LC_MESSAGES=en_US.UTF-8
[7] LC_PAPER=en_US.UTF-8 LC_NAME=C LC_ADDRESS=C
[10] LC_TELEPHONE=C LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C

attached base packages: [1] stats graphics grDevices utils datasets methods base

other attached packages: [1] openxlsx_4.2.3 LS_0.1.0 shiny_1.5.0

loaded via a namespace (and not attached): [1] zoo_1.8-8 tidyselect_1.1.0 urca_1.3-0 purrr_0.3.4 lattice_0.20-41
[6] colorspace_1.4-1 vctrs_0.3.6 generics_0.1.0 egcm_1.0.12 htmltools_0.5.1
[11] pracma_2.2.9 rlang_0.4.10 later_1.1.0.1 pillar_1.4.7 glue_1.4.2
[16] withr_2.3.0 DBI_1.1.0 RColorBrewer_1.1-2 TTR_0.24.2 lifecycle_1.0.0
[21] quantmod_0.4.17 munsell_0.5.0 gtable_0.3.0 zip_2.1.1 tseries_0.10-47
[26] fastmap_1.0.1 httpuv_1.5.4 parallel_4.0.3 curl_4.3 xts_0.12.1
[31] Rcpp_1.0.5 xtable_1.8-4 promises_1.1.1 scales_1.1.1 jsonlite_1.7.2
[36] mime_0.9 ggplot2_3.3.2 digest_0.6.27 stringi_1.5.3 dplyr_1.0.5
[41] grid_4.0.3 quadprog_1.5-8 tools_4.0.3 magrittr_2.0.1 tibble_3.0.4
[46] crayon_1.3.4 pkgconfig_2.0.3 MASS_7.3-53 ellipsis_0.3.1 rsconnect_0.8.16
[51] assertthat_0.2.1 rstudioapi_0.13 R6_2.5.0 nlme_3.1-151 compiler_4.0.3

ycphs commented 2 years ago

Could you please create an issue at ycphs/openxlsx?

This is the active fork of the package.