First of all, thank you so much for writing this package! It is really helping me in my work. I am using version 4.2.5.1.
I wrote the code here to parse ESRI shapefiles and export their geospatial data to a bunch of Excel files, named by the attributes in the table. I actually wanted the first row of row labels (row 4 in my case) to be bold (lines 98-102 in code).
As an aside, I would like to be able to put part of line 2 in italics (ln. 86 in code), and can't figure that one out either.
Actual Behavior
When these export, the row labels (starting on row 4) are blue, and default to having the "filter" option turned on, for example:
Maui.xlsx
Expected Behavior
First of all, thank you so much for writing this package! It is really helping me in my work. I am using version 4.2.5.1.
I wrote the code here to parse ESRI shapefiles and export their geospatial data to a bunch of Excel files, named by the attributes in the table. I actually wanted the first row of row labels (row 4 in my case) to be bold (lines 98-102 in code).
As an aside, I would like to be able to put part of line 2 in italics (ln. 86 in code), and can't figure that one out either.
Actual Behavior
When these export, the row labels (starting on row 4) are blue, and default to having the "filter" option turned on, for example: Maui.xlsx
Steps to Reproduce the Problem
(please attach an example xlsx file if possible)
1.Run code here.
Using .shpfile here
sessionInfo()
Matrix products: default
locale: [1] LC_COLLATE=English_United States.utf8 [2] LC_CTYPE=English_United States.utf8
[3] LC_MONETARY=English_United States.utf8 [4] LC_NUMERIC=C
[5] LC_TIME=English_United States.utf8
attached base packages: [1] stats graphics grDevices utils datasets methods base
other attached packages: [1] rrtable_0.3.0 openxlsx_4.2.5.1 sf_1.0-9
[4] rmarkdown_2.18 markdown_1.4 knitr_1.41
[7] lattice_0.20-45 RColorBrewer_1.1-3 forcats_0.5.2
[10] stringr_1.5.0 dplyr_1.0.10 purrr_0.3.5
[13] readr_2.1.3 tidyr_1.2.1 tibble_3.1.8
[16] ggplot2_3.4.0 tidyverse_1.3.2
loaded via a namespace (and not attached): [1] googledrive_2.0.0 colorspace_2.0-3 ggsignif_0.6.4
[4] ellipsis_0.3.2 class_7.3-20 rio_0.5.29
[7] sjlabelled_1.2.0 rprojroot_2.0.3 flextable_0.8.3
[10] base64enc_0.1-3 fs_1.5.2 rstudioapi_0.14
[13] proxy_0.4-27 ggpubr_0.5.0 DT_0.26
[16] fansi_1.0.3 lubridate_1.9.0 xml2_1.3.3
[19] cachem_1.0.6 sjmisc_2.8.9 jsonlite_1.8.3
[22] broom_1.0.1 dbplyr_2.2.1 png_0.1-8
[25] shiny_1.7.3 compiler_4.2.2 httr_1.4.4
[28] backports_1.4.1 assertthat_0.2.1 Matrix_1.5-1
[31] fastmap_1.1.0 gargle_1.2.1 cli_3.4.1
[34] later_1.3.0 moonBook_0.3.1 htmltools_0.5.3
[37] tools_4.2.2 gtable_0.3.1 glue_1.6.2
[40] rappdirs_0.3.3 Rcpp_1.0.9 carData_3.0-5
[43] cellranger_1.1.0 jquerylib_0.1.4 vctrs_0.5.1
[46] insight_0.18.8 xfun_0.35 rvest_1.0.3
[49] timechange_0.1.1 mime_0.12 miniUI_0.1.1.1
[52] lifecycle_1.0.3 devEMF_4.1-1 rstatix_0.7.1
[55] googlesheets4_1.0.1 scales_1.2.1 hms_1.1.2
[58] promises_1.2.0.1 yaml_2.3.6 curl_4.3.3
[61] reticulate_1.26 gdtools_0.2.4 sass_0.4.4
[64] stringi_1.7.8 e1071_1.7-12 zip_2.2.2
[67] rlang_1.0.6 pkgconfig_2.0.3 systemfonts_1.0.4
[70] evaluate_0.18 rvg_0.3.0 htmlwidgets_1.5.4
[73] tidyselect_1.2.0 here_1.0.1 editData_0.1.8
[76] magrittr_2.0.3 R6_2.5.1 generics_0.1.3
[79] DBI_1.1.3 pillar_1.8.1 haven_2.5.1
[82] foreign_0.8-83 withr_2.5.0 units_0.8-0
[85] abind_1.4-5 ztable_0.2.3 car_3.1-1
[88] modelr_0.1.10 crayon_1.5.2 shinyWidgets_0.7.5 [91] uuid_1.1-0 KernSmooth_2.23-20 utf8_1.2.2
[94] tzdb_0.3.0 officer_0.4.4 grid_4.2.2
[97] readxl_1.4.1 data.table_1.14.6 reprex_2.0.2
[100] digest_0.6.30 classInt_0.4-8 xtable_1.8-4
[103] httpuv_1.6.6 munsell_0.5.0 bslib_0.4.1