Vectorised parameters start_row and start_col in add_data (and in other similar functions)?

[olivier7121]

Hi,

In the documentation of add_data, it is written for start_row (same applies, mutatis mutandis, to start_col):

A vector specifying the starting row to write x to.

Strictly (mathematically) speaking, start_row and start_col are no vectors, but rather scalars; technically, i.e. in R, mathematical scalars are indeed considered as vectors too (of length 1), so I guess it's fine, but it's a bit misleading.
But: Would it be possible to enter a real vector of rows (or columns), not necessarily contiguous, to write the same content but at various coordinates, i.e. on several rows or columns as starting points? For instance, it should be possible to write a vector on a diagonal series of spreadsheet cells in one single call. Or to write this vector vertically every 2 rows, also in one single call. Etc. In general, and conceptually, it should be possible to completely break the input data structure and from their spreadsheet's coordinates structure.

[JanMarvin]

It is possible to write data into pre selected cells using enforce. You have to define the dimensions as non consecutive cells and then you should be able to write into different cells.

[JanMarvin]

An example:

library(openxlsx2)
wb <- wb_workbook()$add_worksheet()$add_data(x = 1:2, dims = "A1,B2", enforce = TRUE)
wb$to_df()
#>    1 NA
#> 2 NA  2

[olivier7121]

Thanks for your reply and for the reprex, @JanMarvin.
Is there a possibility to change the reading direction (i.e. apparently it is here row by row and then to the next column)?
(I didn't see any such option in the documentation.)

[JanMarvin]

No, it already caused enough headaches to create the current solution.