tablaxlsx (version 1.2.4)

bordear: Draw borders an area in an Excel sheet

Description

Draw borders an area in an Excel sheet, with the characteristics indicated in the parameters

Usage

bordear(wb, hoja, fila = 1, columna = 1, ancho = 1, alto = 1, 
        estilo = createStyle(border = "topleftbottomright", 
                            borderStyle = "double", borderColour = "blue4"))

Arguments

wb

An object of Workbook class

hoja

The name, if it is a text, or the position, if it is numeric, of the sheet

fila

The row of the upper-left corner of the area

columna

The column of the upper-left corner of the area

ancho

The number of cells in the width of the area

alto

The number of cells in the height of the area

estilo

The border style. It must be an object of class Style, and he border styles are used

Details

Of the parameter estilo is used: border, borderColour and borderStyle. The last two can be vectors, in such a way that each feature is applied to the corresponding edge, according to the order established in border

See Also

createStyle

Examples

  ## Example
  require(openxlsx)
  wb=createWorkbook()
  addWorksheet(wb,"Primera")
  bordear(wb,"Primera",3,2,5,4)
  ##openXL(wb)
  
  ## Otro ejemplo
  wb=createWorkbook()
  addWorksheet(wb,"Primera")
  bordear(wb,"Primera",3,2,5,4,
          estilo=createStyle(border="bottomtop",borderColour=c("red","blue"),
                            borderStyle=c("double","thin")))
  ##openXL(wb)