excelR
excelR copied to clipboard
apply styling to entire row or column
This is a wonderful package, I'm really enjoying exploring all of its features and how it can improve my shiny apps.
With regards to styling (described here https://swechhya.github.io/excelR/#style ) is it possible to apply style to an entire row, or an entire column (as opposed to one cell at a time).
I may have rather large tables and writing hundreds of rows of the same style setting will be tedious. (eg. A1 =, A2 =, A3 =, A4 =, A5= ..... A301 =, A302 =, etc)
Preferred solution for column: style = list(A:A='background-color:orange; color:green;'')
Preferred solution for row: style = list(11:11='background-color:orange; color:green;'')
Preferred solution for range: style = list(A1:D4='background-color:orange; color:green;'')
Many thanks
:)
@jaracklawrence I'll add this as a feature request to be developed in the upcoming version. Thanks!
I wanted to do the same, but ended up embedding a callback javascript function that makes the trick.