1

I have added a worksheet to an excel spreadsheet using the following code using the xlsx package in R

library(xlsx)    
wb <- CreateWorkbook()
newsheet <- createSheet(wb, sheetName = 'Sheet1')

Is there a way to automatically change the color of the tab for "Sheet1"?

Harrison Jones
  • 2,256
  • 5
  • 27
  • 34

1 Answers1

0

There is no reference to tabs in xlsx

My first instinct was to look look at XLConnect but there is no reference to tabs there either.

Adam Hoelscher
  • 1,804
  • 2
  • 17
  • 33