Class Rasta::Spreadsheet::Sheet
In: lib/rasta/spreadsheet.rb
Parent: Object

Sheets store the information about records on the sheet. In order to allow the user to add comments and have flexibility with how the data is laid out we have the following requirements:

  • The data will start at the first non-bold cell closest to Cell ‘A1‘
  • Bold cells will be ignored until we hit the first data cell.
  • The header row (this is usually the attribute you‘re going to set) needs to be bolded. We will use which side of the data (top or left) to determine if the data is laid out in rows or in columns.

Iterating over the Sheet will return Records which represent the row/column

Methods

[]   cell   cellrange   cellrangevals   colname   datacell?   dump   each   new   ole_object   select   select_home_cell   to_s  

Classes and Modules

Class Rasta::Spreadsheet::Sheet::ObjectError

Attributes

book  [R] 
firstcol  [R] 
firstrow  [R] 
headers  [R] 
lastcol  [R] 
lastrow  [R] 
name  [R] 
style  [R] 

Public Class methods

Public Instance methods

cellrange(index, style=@style)

Get the ole range object for a row or column

cellrangevals(index, style=@style)

Get an array of the values of cells in the range describing the row or column

colname(col)

Translate a numerical column index to the alpha worksheet column the user sees

datacell?(row,col)

A cell is a data cell if the cell‘s font is not bold and there is no background color

[Validate]