Sha256: 265dfe1a4f80dbf6c4424c8a12b46dc3f934a5fbb159f6ec1f6b00bd178055a8
Contents?: true
Size: 1.09 KB
Versions: 69
Compression:
Stored size: 1.09 KB
Contents
module Spreadsheet
module Excel
class Reader
##
# This Module collects reader methods such as read_string that are specific to
# Biff5. This Module is likely to be expanded as Support for older Versions
# of Excel grows.
module Biff5
##
# Read a String of 8-bit Characters
def read_string work, count_length=1
# Offset Size Contents
# 0 1 or 2 Length of the string (character count, ln)
# 1 or 2 ln Character array (8-bit characters)
fmt = count_length == 1 ? 'C' : 'v'
length, = work.unpack fmt
work[count_length, length]
end
def read_range_address_list work, len
# Cell range address, BIFF2-BIFF5:
# Offset Size Contents
# 0 2 Index to first row
# 2 2 Index to last row
# 4 1 Index to first column
# 5 1 Index to last column
#
offset = 0, results = []
return results if len < 2
count = work[0..1].unpack('v').first
offset = 2
count.times do |i|
results << work[offset...offset+6].unpack('v2c2')
offset += 6
end
results
end
end
end
end
end
Version data entries
69 entries across 69 versions & 3 rubygems