1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
|
require 'date'
require 'roo/excelx/cell/base'
require 'roo/excelx/cell/boolean'
require 'roo/excelx/cell/datetime'
require 'roo/excelx/cell/date'
require 'roo/excelx/cell/empty'
require 'roo/excelx/cell/number'
require 'roo/excelx/cell/string'
require 'roo/excelx/cell/time'
module Roo
class Excelx
class Cell
attr_reader :formula, :value, :excelx_type, :excelx_value, :style, :hyperlink, :coordinate
attr_writer :value
# DEPRECATED: Please use Cell.create_cell instead.
def initialize(value, type, formula, excelx_type, excelx_value, style, hyperlink, base_date, coordinate)
warn '[DEPRECATION] `Cell.new` is deprecated. Please use `Cell.create_cell` instead.'
@type = type
@formula = formula
@base_date = base_date if [:date, :datetime].include?(@type)
@excelx_type = excelx_type
@excelx_value = excelx_value
@style = style
@value = type_cast_value(value)
@value = Roo::Link.new(hyperlink, @value.to_s) if hyperlink
@coordinate = coordinate
end
def type
case
when @formula
:formula
when @value.is_a?(Roo::Link)
:link
else
@type
end
end
def self.create_cell(type, *values)
case type
when :string
Cell::String.new(*values)
when :boolean
Cell::Boolean.new(*values)
when :number
Cell::Number.new(*values)
when :date
Cell::Date.new(*values)
when :datetime
Cell::DateTime.new(*values)
when :time
Cell::Time.new(*values)
end
end
# Deprecated: use Roo::Excelx::Coordinate instead.
class Coordinate
attr_accessor :row, :column
def initialize(row, column)
warn '[DEPRECATION] `Roo::Excel::Cell::Coordinate` is deprecated. Please use `Roo::Excelx::Coordinate` instead.'
@row, @column = row, column
end
end
private
def type_cast_value(value)
case @type
when :float, :percentage
value.to_f
when :date
create_date(@base_date + value.to_i)
when :datetime
create_datetime(@base_date + value.to_f.round(6))
when :time
value.to_f * 86_400
else
value
end
end
def create_date(date)
yyyy, mm, dd = date.strftime('%Y-%m-%d').split('-')
::Date.new(yyyy.to_i, mm.to_i, dd.to_i)
end
def create_datetime(date)
datetime_string = date.strftime('%Y-%m-%d %H:%M:%S.%N')
t = round_datetime(datetime_string)
::DateTime.civil(t.year, t.month, t.day, t.hour, t.min, t.sec)
end
def round_datetime(datetime_string)
/(?<yyyy>\d+)-(?<mm>\d+)-(?<dd>\d+) (?<hh>\d+):(?<mi>\d+):(?<ss>\d+.\d+)/ =~ datetime_string
::Time.new(yyyy.to_i, mm.to_i, dd.to_i, hh.to_i, mi.to_i, ss.to_r).round(0)
end
end
end
end
|
