setRowHeight-methods

0th

Percentile

Setting the height of a row in a worksheet

Sets the height of a row in a worksheet.

Keywords
methods, utilities
Usage
# S4 method for workbook,character
setRowHeight(object,sheet,row,height)
# S4 method for workbook,numeric
setRowHeight(object,sheet,row,height)
Arguments
object

The '>workbook to use

sheet

The name or index of the sheet to edit

row

The index of the row to resize

height

The height in points. If height < 0 (default: -1), the row will be sized to the sheet's default row height.

Details

Note that the arguments sheet, row and height are vectorized. As such the row height of multiple rows (potentially on different worksheets) can be set with one method call.

See Also

'>workbook, setColumnWidth

Aliases
  • setRowHeight
  • setRowHeight-methods
  • setRowHeight,workbook,character-method
  • setRowHeight,workbook,numeric-method
Examples
# NOT RUN {
# mtcars xlsx file from demoFiles subfolder of package XLConnect
mtcarsFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")

# Load workbook
wb <- loadWorkbook(mtcarsFile)

# Sets the row height of the 1st row on sheet 'mtcars'
# to 20 points
setRowHeight(wb, sheet = "mtcars", row = 1, height = 20)
# }
Documentation reproduced from package XLConnect, version 0.2-15, License: GPL-3

Community examples

Looks like there are no examples yet.