bordear: Draw borders an area in an Excel sheet

In tablaxlsx: Write Formatted Tables in Excel Workbooks

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)
  

tablaxlsx documentation built on May 31, 2023, 8:51 p.m.