Is your feature request related to a problem? Please describe.
Using writeDataTable is great, however when sharing my work with colleagues, the expectation would be to have certain filters set. I cannot find a way to not only have filters, but also to set how I want them filtered when creating the workbook. Thus, I need to write it, open it, set the filters myself, then save again.
Describe the solution you'd like
I could envision this as part of writeDataTable, or a separate helper function similar to setColWidths (e.g. setDataTableOptions?).
So maybe something like this, assuming I write a table with colName1, with values value1, value2, value3, and NA (blank). This would generate the table such that the equivalent user action would be to click the column drop down, uncheck value3 and leave Blank selected.
Describe alternatives you've considered
I've google around and found what I think is this question on SO, but the only answer is to use VBS, which I'm not interested in doing.
Additional context
Add any other context or screenshots about the feature request here.
Is your feature request related to a problem? Please describe. Using
writeDataTable
is great, however when sharing my work with colleagues, the expectation would be to have certain filters set. I cannot find a way to not only have filters, but also to set how I want them filtered when creating the workbook. Thus, I need to write it, open it, set the filters myself, then save again.Describe the solution you'd like I could envision this as part of
writeDataTable
, or a separate helper function similar tosetColWidths
(e.g.setDataTableOptions
?).So maybe something like this, assuming I write a table with colName1, with values value1, value2, value3, and NA (blank). This would generate the table such that the equivalent user action would be to click the column drop down, uncheck value3 and leave Blank selected.
Describe alternatives you've considered I've google around and found what I think is this question on SO, but the only answer is to use VBS, which I'm not interested in doing.
Additional context Add any other context or screenshots about the feature request here.