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
|
require "spreadsheet/workbook"
require "spreadsheet/excel/offset"
require "spreadsheet/excel/writer"
require "ole/storage"
module Spreadsheet
module Excel
##
# Excel-specific Workbook methods. These are mostly pertinent to the Excel
# reader. You should have no reason to use any of these.
class Workbook < Spreadsheet::Workbook
include Spreadsheet::Encodings
include Spreadsheet::Excel::Offset
BIFF_VERSIONS = {
0x000 => 2,
0x007 => 2,
0x200 => 2,
0x300 => 3,
0x400 => 4,
0x500 => 5,
0x600 => 8
}
VERSION_STRINGS = {
0x600 => "Microsoft Excel 97/2000/XP",
0x500 => "Microsoft Excel 95"
}
offset :encoding, :boundsheets, :sst
attr_accessor :bof, :ole
attr_writer :date_base
def self.open io, opts = {}
Reader.new(opts).read(io)
end
def initialize *args
super
enc = "UTF-16LE"
if RUBY_VERSION >= "1.9"
enc = Encoding.find enc
end
@encoding = enc
@version = 0x600
@sst = []
end
def add_shared_string str
@sst.push str
end
def add_worksheet worksheet
@changes.store :boundsheets, true
super
end
def biff_version
case @bof
when 0x009
2
when 0x209
3
when 0x409
4
else
BIFF_VERSIONS.fetch(@version) { raise "Unkown BIFF_VERSION '#{@version}'" }
end
end
def date_base
@date_base ||= DateTime.new 1899, 12, 31
end
def inspect
worksheets
end
def shared_string idx
@sst[idx.to_i].content
end
def sst_size
@sst.size
end
def uninspect_variables
super.push "@sst", "@offsets", "@changes"
end
def version_string
client VERSION_STRINGS.fetch(@version, "Unknown"), "UTF-8"
end
end
end
end
|
