Class Spreadsheet::Excel::Writer::Worksheet
In: lib/spreadsheet/excel/writer/n_worksheet.rb
lib/spreadsheet/excel/writer/worksheet.rb
Parent: Object

Writer class for Excel Worksheets. Most write_* method correspond to an Excel-Record/Opcode. You should not need to call any of its methods directly. If you think you do, look at write_worksheet

Methods

boundsheet_size   boundsheet_size   data   data   encode_date   encode_date   encode_rk   encode_rk   name   name   need_number?   need_number?   new   new   row_blocks   row_blocks   size   size   strings   strings   write_blank   write_blank   write_bof   write_bof   write_boolerr   write_boolerr   write_calccount   write_calccount   write_cell   write_cell   write_cellblocks   write_cellblocks   write_changes   write_changes   write_colinfo   write_colinfo   write_colinfos   write_colinfos   write_defaultrowheight   write_defaultrowheight   write_defcolwidth   write_defcolwidth   write_dimensions   write_dimensions   write_eof   write_eof   write_formula   write_formula   write_from_scratch   write_from_scratch   write_guts   write_guts   write_hlink   write_hlink   write_hyperlink_table   write_hyperlink_table   write_iteration   write_iteration   write_labelsst   write_labelsst   write_merged_cells   write_mulblank   write_mulblank   write_mulrk   write_mulrk   write_multiples   write_multiples   write_number   write_number   write_op   write_op   write_proctection   write_refmode   write_refmode   write_rk   write_rk   write_row   write_row   write_rowblock   write_rowblock   write_rows   write_rows   write_saverecalc   write_saverecalc   write_window2   write_window2   write_wsbool   write_wsbool  

Included Modules

Spreadsheet::Excel::Writer::Biff8 Spreadsheet::Excel::Internals Spreadsheet::Excel::Internals::Biff8 Spreadsheet::Excel::Writer::Biff8 Spreadsheet::Excel::Internals Spreadsheet::Excel::Internals::Biff8

Attributes

worksheet  [R] 
worksheet  [R] 

Public Class methods

Public Instance methods

The number of bytes needed to write a Boundsheet record for this Worksheet Used by Writer::Worksheet to calculate various offsets.

The number of bytes needed to write a Boundsheet record for this Worksheet Used by Writer::Worksheet to calculate various offsets.

Write a blank cell

Write a blank cell

Write a cell with a Boolean or Error value

Write a cell with a Boolean or Error value

Write a cell with a Formula. May write an additional String record depending on the stored result of the Formula.

Write a cell with a Formula. May write an additional String record depending on the stored result of the Formula.

Write record that contains information about the layout of outline symbols.

Write record that contains information about the layout of outline symbols.

Write a cell with a String value. The String must have been stored in the Shared String Table.

Write a cell with a String value. The String must have been stored in the Shared String Table.

Write multiple consecutive blank cells.

Write multiple consecutive blank cells.

Write multiple consecutive cells with RK values (see write_rk)

Write multiple consecutive cells with RK values (see write_rk)

Write a cell with a 64-bit double precision Float value

Write a cell with a 64-bit double precision Float value

Write a cell with a Numeric or Date value.

Write a cell with a Numeric or Date value.

[Validate]