Class: Excel::Row

Inherits:
Object
  • Object
show all
Defined in:
lib/ru_excel/row.rb

Constant Summary collapse

EPOCH = 
Date.new(1899, 12, 31)
TIME_EPOCH = 
Time.mktime(1902, 1, 1)
TIME_EPOCH_ADD = 
(Date.new(1902, 1, 1) - Date.new(1899, 12, 31))

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(index, parent_sheet) ⇒ Row

Constructor



13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
 
# File 'lib/ru_excel/row.rb', line 13

def initialize(index, parent_sheet)
    @idx = index
    @parent = parent_sheet
    @parent_wb = parent_sheet.parent
    @cells = []
    @min_col_idx = 0
    @max_col_idx = 0
    @total_str = 0
    @xf_index = 0x0F
    @has_default_format = 0
    @height_in_pixels = 0x11
    
    @height = 0x00FF
    @has_default_height = 0x00
    @level = 0
    @collapse = 0
    @hidden = 0
    @space_above = 0
    @space_below = 0
end

Instance Attribute Details

#level ⇒ Object

Returns the value of attribute level.



34
35
36
 
# File 'lib/ru_excel/row.rb', line 34

def level
  @level
end

Instance Method Details

#_adjust_bound_col_idx(*args) ⇒ Object 



49
50
51
52
53
54
55
56
57
 
# File 'lib/ru_excel/row.rb', line 49

def _adjust_bound_col_idx(*args)
    for arg in args
        if arg < @min_col_idx
            @min_col_idx = arg
        elsif arg > @max_col_idx
            @max_col_idx = arg
        end
    end
end

#_adjust_height(style) ⇒ Object 



36
37
38
39
40
41
42
43
44
45
46
 
# File 'lib/ru_excel/row.rb', line 36

def _adjust_height(style)
    twips = style.font.height
    points = twips.to_f/20.0
    # Cell height in pixels can be calcuted by following approx. formula
    # cell height in pixels = font height in points * 83/50 + 2/5
    # It works when screen resolution is 96 dpi 
    pix = (points*83.0/50.0 + 2.0/5.0.to_i).round
    if pix > @height_in_pixels
        @height_in_pixels = pix
    end
end

#_excel_date_dt(date) ⇒ Object 



62
63
64
65
66
67
68
69
70
71
72
73
74
75
 
# File 'lib/ru_excel/row.rb', line 62

def _excel_date_dt(date)
    if Date === date
        xldate = (date - EPOCH).to_f + date.offset.to_f
    elsif Time === date
        xldate = (date - TIME_EPOCH + 
                  date.utc_offset - TIME_EPOCH.utc_offset).to_f / (24 * 60 * 60) +
                 TIME_EPOCH_ADD
    else
        raise date.inspect+' is not a date'
    end
    # Add a day for Excel's missing leap day in 1900
    xldate += 1 if xldate > 59
    xldate
end

#get_cells_biff_data ⇒ Object 



134
135
136
137
 
# File 'lib/ru_excel/row.rb', line 134

def get_cells_biff_data
    #@cells.map{|c| c.get_biff_data()}.join('')
    @cells.join('')
end

#get_cells_count ⇒ Object 



93
94
95
 
# File 'lib/ru_excel/row.rb', line 93

def get_cells_count
    @cells.length
end

#get_height_in_pixels ⇒ Object 



77
78
79
 
# File 'lib/ru_excel/row.rb', line 77

def get_height_in_pixels
    @height_in_pixels
end

#get_index ⇒ Object 



140
141
142
 
# File 'lib/ru_excel/row.rb', line 140

def get_index
    @idx
end

#get_max_col ⇒ Object 



103
104
105
 
# File 'lib/ru_excel/row.rb', line 103

def get_max_col
    @min_col_idx
end

#get_min_col ⇒ Object 



98
99
100
 
# File 'lib/ru_excel/row.rb', line 98

def get_min_col
    @min_col_idx
end

#get_row_biff_data ⇒ Object 



113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
 
# File 'lib/ru_excel/row.rb', line 113

def get_row_biff_data
    height_options = (@height & 0x07FFF) 
    height_options |= (@has_default_height & 0x01) << 15

    options =  (@level & 0x07) << 0
    options |= (@collapse & 0x01) << 4
    options |= (@hidden & 0x01) << 5
    options |= (0x00 & 0x01) << 6
    options |= (0x01 & 0x01) << 8
    if @xf_index != 0x0F
        options |= (0x01 & 0x01) << 7
    else
        options |= (0x00 & 0x01) << 7
    end
    options |= (@xf_index & 0x0FFF) << 16 
    options |= (0x00 & @space_above) << 28
    options |= (0x00 & @space_below) << 29
    
    BiffRecord.rowRecord(@idx, @min_col_idx, @max_col_idx, height_options, options)
end

#get_str_count ⇒ Object 



108
109
110
 
# File 'lib/ru_excel/row.rb', line 108

def get_str_count
    @total_str
end

#get_xf_index ⇒ Object 



88
89
90
 
# File 'lib/ru_excel/row.rb', line 88

def get_xf_index
    @xf_index
end

#set_style(style) ⇒ Object 



82
83
84
85
 
# File 'lib/ru_excel/row.rb', line 82

def set_style(style)
    _adjust_height(style)
    @xf_index = @parent_wb.add_style(style)
end

#write(col, label, style) ⇒ Object 



145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
 
# File 'lib/ru_excel/row.rb', line 145

def write(col, label, style)
    _adjust_height(style)
    _adjust_bound_col_idx(col)
    if String === label
        if label.length > 0
            @cells << Cell.strCell(self, col, @parent_wb.add_style(style), @parent_wb.add_str(label))
            @total_str += 1
        else
            @cells << Cell.blankCell(self, col, @parent_wb.add_style(style))
        end
    elsif Numeric === label
        @cells << Cell.numberCell(self, col, @parent_wb.add_style(style), label)
    elsif Date === label or Time === label
        @cells << Cell.numberCell(self, col, @parent_wb.add_style(style), _excel_date_dt(label))
    else
        @cells << Cell.formulaCell(self, col, @parent_wb.add_style(style), label)
    end
end

#write_blanks(c1, c2, style) ⇒ Object 



164
165
166
167
168
 
# File 'lib/ru_excel/row.rb', line 164

def write_blanks(c1, c2, style)
    _adjust_height(style)
    _adjust_bound_col_idx(c1, c2)
    @cells << Cell.mulBlankCell(self, c1, c2, @parent_wb.add_style(style))
end