Class | Spreadsheet::Worksheet |
In: |
lib/spreadsheet/worksheet.rb
lib/spreadsheet/excel.rb |
Parent: | Object |
The Worksheet class. Contains most of the Spreadsheet data in Rows.
Interesting Attributes
name : | The Name of this Worksheet. |
default_format: | The default format used for all cells in this Workhseet that have no format set explicitly or in Row#default_format. |
rows : | The Rows in this Worksheet. It is not recommended to Manipulate this Array directly. If you do, call updated_from with the smallest modified index. |
columns : | The Column formatting in this Worksheet. Column instances may appear at more than one position in columns. If you modify a Column directly, your changes will be reflected in all those positions. |
selected : | When a user chooses to print a Workbook, Excel will include all selected Worksheets. If no Worksheet is selected at Workbook#write, then the first Worksheet is selected by default. |
columns | [R] | |
merged_cells | [R] | |
name | [RW] | |
password_hash | [RW] | |
rows | [R] | |
selected | [RW] | |
workbook | [RW] |
Add a Format to the Workbook. If you use Row#set_format, you should not need to use this Method.
If no argument is given, each iterates over all used Rows (from the first used Row until but omitting the first unused Row, see also dimensions).
If the argument skip is given, each iterates from that row until but omitting the first unused Row, effectively skipping the first skip Rows from the top of the Worksheet.
Formats all Date, DateTime and Time cells with format or the default formats:
Replace the Row at idx with the following arguments. Like update_row, but truncates the Row if there are fewer arguments than Cells in the Row.
Tell Worksheet that the Row at idx has been updated and the dimensions need to be recalculated. You should not need to call this directly.