class

CrystalXlsx::Worksheet

Inherits Reference < Object

Constructors

new(name : String, workbook : CrystalXlsx::Workbook | Nil = nil)

add_row(data : CrystalXlsx::Row::ValuesTypes, format : Format | Nil = nil)

column_width(column : Int32, width : Float64 | Int32)

columns_width=(columns : Array(Int32))

columns_width=(columns : Array(Float64))

freeze_pane(xSplit : Int32, ySplit : Int32, topLeftCell : String = "A2")

freeze_row(row : Int32)

name

name=(name : String)

rows

rows=(rows : Array(Row))

set_pane(xSplit : Int32, ySplit : Int32, topLeftCell : String = "A2", activePane : String = "bottomLeft", state : String = "frozen")

to_xml(io : IO)

generate the xml for the worksheet

workbook

workbook=(workbook : CrystalXlsx::Workbook | Nil)