Returns a list of all styles in the workbook

Returns list of style objects in the workbook

getStyles(wb)

Arguments

wb

A workbook object

See also

replaceStyle()

Examples

## load a workbook
wb <- loadWorkbook(file = system.file("extdata", "loadExample.xlsx", package = "openxlsx"))
getStyles(wb)[1:3]
#> [[1]]
#> A custom cell style. 
#> 
#>  Cell formatting: GENERAL 
#>  Font name: Calibri 
#>  Font size: 11 
#>  Font colour: 10 
#>  Font decoration: UNDERLINE 
#>  Cell horz. align: left 
#>  
#> 
#> 
#> [[2]]
#> A custom cell style. 
#> 
#>  Cell formatting: GENERAL 
#>  Cell horz. align: center 
#>  wraptext: TRUE 
#> 
#> 
#> [[3]]
#> A custom cell style. 
#> 
#>  Cell formatting: GENERAL 
#>  
#> 
#>