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

Version Path
spreadsheet-1.3.3 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.3.2 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.3.1 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.3.0 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.2.9 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.2.8 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.2.7 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.2.6 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.2.5 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.2.4 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.2.3 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.2.2 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.2.1 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.2.0 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.1.9 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.1.8 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.1.7 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.1.6 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.1.5 lib/spreadsheet/excel/reader/biff5.rb
spreadsheet-1.1.4 lib/spreadsheet/excel/reader/biff5.rb