Skip to main content
CrystalDocs
Search documentation
Search
Browse Docs
CrystalShards
About
class
CrystalXlsx::Worksheet
Inherits
Reference
<
Object
Constructors
new
(name :
String
, workbook :
CrystalXlsx::Workbook
|
Nil
= nil)
Source
Instance methods
<<
(data :
CrystalXlsx::Row::ValuesTypes
)
Source
add_row
(data :
CrystalXlsx::Row::ValuesTypes
, format :
Format
|
Nil
= nil)
Source
column_width
(column :
Int32
, width :
Float64
|
Int32
)
Source
columns_width=
(columns :
Array
(
Int32
))
Source
columns_width=
(columns :
Array
(
Float64
))
Source
freeze_pane
(x
Split
:
Int32
, y
Split
:
Int32
, top
LeftCell
:
String
= "
A2
")
Source
freeze_row
(row :
Int32
)
Source
name
Source
name=
(name :
String
)
Source
rows
Source
rows=
(rows :
Array
(
Row
))
Source
set_pane
(x
Split
:
Int32
, y
Split
:
Int32
, top
LeftCell
:
String
= "
A2
", active
Pane
:
String
= "bottom
Left
", state :
String
= "frozen")
Source
to_xml
(io :
IO
)
generate the xml for the worksheet
Source
workbook
Source
workbook=
(workbook :
CrystalXlsx::Workbook
|
Nil
)
Source