excelR icon indicating copy to clipboard operation
excelR copied to clipboard

apply styling to entire row or column

Open jaracklawrence opened this issue 4 years ago • 2 comments

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 avatar Jun 18 '20 20:06 jaracklawrence

@jaracklawrence I'll add this as a feature request to be developed in the upcoming version. Thanks!

Swechhya avatar Jul 07 '20 08:07 Swechhya

I wanted to do the same, but ended up embedding a callback javascript function that makes the trick.

ipignate avatar Jul 14 '20 16:07 ipignate