Class: BoundSheetRecord

Inherits:
BiffRecord show all
Defined in:
lib/surpass/biff_record.rb

Overview

This record is located in the workbook globals area and represents a sheet inside of the workbook. For each sheet a BOUNDSHEET record is written. It stores the sheet name and a stream offset to the BOF record within the workbook stream. The record is also known as BUNDLESHEET.

Record BOUNDSHEET, BIFF5-BIFF8: Offset Size Contents 0 4 Absolute stream position of the BOF record of the sheet represented by this record. This

field is never encrypted in protected files.

4 1 Visibility:

00H = Visible
01H = Hidden
02H = Strong hidden

5 1 Sheet type:

00H = Worksheet
02H = Chart
06H = Visual Basic module

6 var. Sheet name:

BIFF5/BIFF7: Byte string, 8-bit string length
BIFF8: Unicode string, 8-bit string length

Constant Summary collapse

RECORD_ID = 
0x0085

Constants inherited from BiffRecord

BiffRecord::BIFF_LIMIT, BiffRecord::CONTINUE_RECORD_ID

Instance Attribute Summary

Attributes inherited from BiffRecord

#record_data

Instance Method Summary collapse

Methods inherited from BiffRecord

#record_header, #to_biff

Constructor Details

#initialize(stream_pos, visibility, name) ⇒ BoundSheetRecord

Returns a new instance of BoundSheetRecord.



969
970
971
 
# File 'lib/surpass/biff_record.rb', line 969

def initialize(stream_pos, visibility, name)
  @record_data = [stream_pos, visibility, 0x00].pack('VCC') + [name.length, 0].pack('CC') + name
end