class CrystalXlsx::Worksheet

• CrystalXlsx::Worksheet
• Reference
• Object

Defined in:

crystal_xlsx/worksheet.cr

Constructors

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

Instance Method Summary

• #<<(data : CrystalXlsx::Row::ValuesTypes)
• #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 : String
• #name=(name : String)
• #rows : Array(Row)
• #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 : CrystalXlsx::Workbook | Nil
• #workbook=(workbook : CrystalXlsx::Workbook | Nil)

Constructor Detail

Instance Method Detail