Set and Get Window Size for xlsx file

setWindowSize(
  wb,
  xWindow = NULL,
  yWindow = NULL,
  windowWidth = NULL,
  windowHeight = NULL
)

getWindowSize(wb)

Arguments

wb

A Workbook object

xWindow

the horizontal coordinate of the top left corner of the window

yWindow

the vertical coordinate of the top left corner of the window

windowWidth

the width of the window

windowHeight

the height of the window

Set the size and position of the window when you open the xlsx file. The units are in twips. See Microsoft's documentation for the xlsx standard

Examples

## Create Workbook object and add worksheets
wb <- createWorkbook()
addWorksheet(wb, "S1")
getWindowSize(wb)
#> $xWindow
#> [1] "0"
#> 
#> $yWindow
#> [1] "0"
#> 
#> $windowWidth
#> [1] "13125"
#> 
#> $windowHeight
#> [1] "6105"
#> 
setWindowSize(wb, windowWidth = 10000)