public TableStylesRecord(RecordInputStream in1)
{
rt = in1.ReadUShort();
grbitFrt = in1.ReadUShort();
in1.ReadFully(unused);
cts = in1.ReadInt();
int cchDefListStyle = in1.ReadUShort();
int cchDefPivotStyle = in1.ReadUShort();
rgchDefListStyle = in1.ReadUnicodeLEString(cchDefListStyle);
rgchDefPivotStyle = in1.ReadUnicodeLEString(cchDefPivotStyle);
}
public ExtendedPivotTableViewFieldsRecord(RecordInputStream in1)
{
grbit1 = in1.ReadInt();
grbit2 = in1.ReadUByte();
citmShow = in1.ReadUByte();
isxdiSort = in1.ReadUShort();
isxdiShow = in1.ReadUShort();
// This record seems to have different valid encodings
switch (in1.Remaining) {
case 0:
// as per "Microsoft Excel Developer's Kit" book
// older version of SXVDEX - doesn't seem to have a sub-total name
reserved1 = 0;
reserved2 = 0;
subName = null;
return;
case 10:
// as per "MICROSOFT OFFICE EXCEL 97-2007 BINARY FILE FORMAT SPECIFICATION" pdf
break;
default:
throw new RecordFormatException("Unexpected remaining size (" + in1.Remaining + ")");
}
int cchSubName = in1.ReadUShort();
reserved1 = in1.ReadInt();
reserved2 = in1.ReadInt();
if (cchSubName != STRING_NOT_PRESENT_LEN)
{
subName = in1.ReadUnicodeLEString(cchSubName);
}
}
/**
* Constructs a String record and Sets its fields appropriately.
*
* @param in the RecordInputstream to Read the record from
*/
public StringRecord(RecordInputStream in1)
{
int field_1_string_length = in1.ReadShort();
_is16bitUnicode = in1.ReadByte() != 0x00;
if (_is16bitUnicode)
{
_text = in1.ReadUnicodeLEString(field_1_string_length);
}
else
{
_text = in1.ReadCompressedUnicode(field_1_string_length);
}
}
/**
* Constructs a Format record and Sets its fields appropriately.
* @param in the RecordInputstream to Read the record from
*/
public FormatRecord(RecordInputStream in1)
{
field_1_index_code = in1.ReadShort();
int field_3_unicode_len = in1.ReadShort();
field_3_hasMultibyte = (in1.ReadByte() & (byte)0x01) != 0;
if (field_3_hasMultibyte)
{
// Unicode
field_4_formatstring = in1.ReadUnicodeLEString(field_3_unicode_len);
}
else
{
// not Unicode
field_4_formatstring = in1.ReadCompressedUnicode(field_3_unicode_len);
}
}
public ViewFieldsRecord(RecordInputStream in1)
{
sxaxis = in1.ReadShort();
cSub = in1.ReadShort();
grbitSub = in1.ReadShort();
cItm = in1.ReadShort();
int cchName = in1.ReadUShort();
if (cchName != STRING_NOT_PRESENT_LEN)
{
int flag = in1.ReadByte();
if ((flag & 0x01) != 0)
{
_name = in1.ReadUnicodeLEString(cchName);
}
else
{
_name = in1.ReadCompressedUnicode(cchName);
}
}
}
/**
* Constructs an Label record and Sets its fields appropriately.
*
* @param in the RecordInputstream to Read the record from
*/
public LabelRecord(RecordInputStream in1)
{
field_1_row = in1.ReadUShort();
field_2_column = in1.ReadUShort();
field_3_xf_index = in1.ReadShort();
field_4_string_len = in1.ReadShort();
field_5_unicode_flag = (byte)in1.ReadByte();
if (field_4_string_len > 0)
{
if (IsUncompressedUnicode)
{
field_6_value = in1.ReadUnicodeLEString(field_4_string_len);
}
else
{
field_6_value = in1.ReadCompressedUnicode(field_4_string_len);
}
}
else
{
field_6_value = "";
}
}
protected HeaderFooterBase(RecordInputStream in1)
{
if (in1.Remaining > 0)
{
int field_1_footer_len = in1.ReadShort();
field_2_hasMultibyte = in1.ReadByte() != 0x00;
if (field_2_hasMultibyte)
{
field_3_text = in1.ReadUnicodeLEString(field_1_footer_len);
}
else
{
field_3_text = in1.ReadCompressedUnicode(field_1_footer_len);
}
}
else
{
// Note - this is unusual for BIFF records in general, but normal for header / footer records:
// when the text is empty string, the whole record is empty (just the 4 byte BIFF header)
field_3_text = "";
}
}
/**
* Read hyperlink from input stream
*
* @param in the stream to Read from
*/
public HyperlinkRecord(RecordInputStream in1)
{
_range = new CellRangeAddress(in1);
// 16-byte GUID
_guid = new GUID(in1);
/*
* streamVersion (4 bytes): An unsigned integer that specifies the version number
* of the serialization implementation used to save this structure. This value MUST equal 2.
*/
int streamVersion = in1.ReadInt();
if (streamVersion != 0x00000002)
{
throw new RecordFormatException("Stream Version must be 0x2 but found " + streamVersion);
}
_linkOpts = in1.ReadInt();
if ((_linkOpts & HLINK_LABEL) != 0)
{
int label_len = in1.ReadInt();
_label = in1.ReadUnicodeLEString(label_len);
}
if ((_linkOpts & HLINK_TARGET_FRAME) != 0)
{
int len = in1.ReadInt();
_targetFrame = in1.ReadUnicodeLEString(len);
}
if ((_linkOpts & HLINK_URL) != 0 && (_linkOpts & HLINK_UNC_PATH) != 0)
{
_moniker = null;
int nChars = in1.ReadInt();
_address = in1.ReadUnicodeLEString(nChars);
}
if ((_linkOpts & HLINK_URL) != 0 && (_linkOpts & HLINK_UNC_PATH) == 0)
{
_moniker = new GUID(in1);
if (URL_MONIKER.Equals(_moniker))
{
int length = in1.ReadInt();
/*
* The value of <code>length<code> be either the byte size of the url field
* (including the terminating NULL character) or the byte size of the url field plus 24.
* If the value of this field is set to the byte size of the url field,
* then the tail bytes fields are not present.
*/
int remaining = in1.Remaining;
if (length == remaining)
{
int nChars = length / 2;
_address = in1.ReadUnicodeLEString(nChars);
}
else
{
int nChars = (length - TAIL_SIZE) / 2;
_address = in1.ReadUnicodeLEString(nChars);
/*
* TODO: make sense of the remaining bytes
* According to the spec they consist of:
* 1. 16-byte GUID: This field MUST equal
* {0xF4815879, 0x1D3B, 0x487F, 0xAF, 0x2C, 0x82, 0x5D, 0xC4, 0x85, 0x27, 0x63}
* 2. Serial version, this field MUST equal 0 if present.
* 3. URI Flags
*/
_uninterpretedTail = ReadTail(URL_uninterpretedTail, in1);
}
}
else if (FILE_MONIKER.Equals(_moniker))
{
_fileOpts = in1.ReadShort();
int len = in1.ReadInt();
_shortFilename = StringUtil.ReadCompressedUnicode(in1, len);
_uninterpretedTail = ReadTail(FILE_uninterpretedTail, in1);
int size = in1.ReadInt();
if (size > 0)
{
int charDataSize = in1.ReadInt();
//From the spec: An optional unsigned integer that MUST be 3 if present
int optFlags = in1.ReadUShort();
if (optFlags != 0x0003)
{
throw new RecordFormatException("Expected 0x3 but found " + optFlags);
}
_address = StringUtil.ReadUnicodeLE(in1, charDataSize / 2);
}
else
{
_address = null;
}
}
else if (STD_MONIKER.Equals(_moniker))
{
_fileOpts = in1.ReadShort();
int len = in1.ReadInt();
byte[] path_bytes = new byte[len];
in1.ReadFully(path_bytes);
_address = Encoding.UTF8.GetString(path_bytes);
}
}
if ((_linkOpts & HLINK_PLACE) != 0)
{
int len = in1.ReadInt();
_textMark = in1.ReadUnicodeLEString(len);
}
if (in1.Remaining > 0)
{
Console.WriteLine(HexDump.ToHex(in1.ReadRemainder()));
}
}
private static String ReadRawString(RecordInputStream in1, int textLength)
{
byte compressByte = (byte)in1.ReadByte();
bool isCompressed = (compressByte & 0x01) == 0;
if (isCompressed)
{
return in1.ReadCompressedUnicode(textLength);
}
return in1.ReadUnicodeLEString(textLength);
}
/**
* Constructs a Font record and Sets its fields appropriately.
*
* @param in the RecordInputstream to Read the record from
*/
public FontRecord(RecordInputStream in1)
{
field_1_font_height = in1.ReadShort();
field_2_attributes = in1.ReadShort();
field_3_color_palette_index = in1.ReadShort();
field_4_bold_weight = in1.ReadShort();
field_5_base_sub_script = in1.ReadShort();
field_6_underline = (byte)in1.ReadByte();
field_7_family = (byte)in1.ReadByte();
field_8_charset = (byte)in1.ReadByte();
field_9_zero = (byte)in1.ReadByte();
int field_10_font_name_len = (byte)in1.ReadByte();
int unicodeFlags = in1.ReadUByte(); // options byte present always (even if no character data)
if (field_10_font_name_len > 0)
{
if (unicodeFlags == 0)
{ // Is compressed Unicode
field_11_font_name = in1.ReadCompressedUnicode(field_10_font_name_len);
}
else
{ // Is not compressed Unicode
field_11_font_name = in1.ReadUnicodeLEString(field_10_font_name_len);
}
}
else
{
field_11_font_name = "";
}
}