Formats cells to blue and turns on filter function

[marireeves]

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.

2. Using .shpfile here

3. Help me make a table with plain, bold text in row 4 and some Italics in row 2.

sessionInfo()

• Version of openxlsx: openxlsx_4.2.5.1
• Version of R: R version 4.2.2

sessionInfo()
R version 4.2.2 (2022-10-31 ucrt)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 19044)

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