//public double Value { get; private set; }
public NumberRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
SetRowColXf(reader);
Value = reader.ReadDouble();
}
//public string Value { get; private set; }
public LabelRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
SetRowColXf(reader);
Value = reader.ReadSimpleUnicodeString();
}
public LabelSstRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
SetRowColXf(reader);
SSTIndex = reader.ReadUInt32();
}
public RkRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
SetRowColXf(reader);
Value = Convet(reader.ReadInt32());
}
public RowRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
RowNumber = reader.ReadUInt16();
FirstCol = reader.ReadUInt16();
LastCol = reader.ReadUInt16();
RowHeight = reader.ReadUInt16();
Optimizer = reader.ReadUInt16();
Options = reader.ReadUInt16();
XF = reader.ReadUInt16();
}
public BoundSheetRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
BOFPos = reader.ReadUInt32();
Visibility = (VisibilityType)reader.ReadByte();
Type = (SheetType)reader.ReadByte();
byte len = reader.ReadByte();
Name = reader.ReadPossibleCompressedString(len);
}
public DbCellRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
RowOffset = reader.ReadUInt32();
//int noffsets = (int)(stream.Length - stream.Position) / 2;
//_streamOffsets = new ushort[noffsets];
//noffsets = 0;
//while (stream.Position < stream.Length)
// _streamOffsets[noffsets++] = reader.ReadUInt16();
}
public MulRkRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
reader = SetRowColInfo(reader);
RKs = new double[reader.BaseStream.Length / 6];
for (int n = 0; n < RKs.Length; ++n)
{
ushort xf = reader.ReadUInt16();
int rk = reader.ReadInt32();
RKs[n] = RkRecord.Convet(rk);
}
}
public DbCellRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
RowOffset = reader.ReadUInt32();
//int noffsets = (int)(stream.Length - stream.Position) / 2;
//_streamOffsets = new ushort[noffsets];
//noffsets = 0;
//while (stream.Position < stream.Length)
// _streamOffsets[noffsets++] = reader.ReadUInt16();
}
public RowRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
RowNumber = reader.ReadUInt16();
FirstCol = reader.ReadUInt16();
LastCol = reader.ReadUInt16();
RowHeight = reader.ReadUInt16();
Optimizer = reader.ReadUInt16();
Options = reader.ReadUInt16();
XF = reader.ReadUInt16();
}
public ArrayRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
FirstRowIdx = reader.ReadUInt16();
LastRowIdx = reader.ReadUInt16();
FirstColIdx = reader.ReadByte();
LastColIdx = reader.ReadByte();
Options = reader.ReadUInt16();
Reserved = reader.ReadUInt32();
Data = reader.ReadBytes((int)(stream.Length - stream.Position));
}
public MulRkRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
reader = SetRowColInfo(reader);
RKs = new double[reader.BaseStream.Length / 6];
for (int n = 0; n < RKs.Length; ++n)
{
ushort xf = reader.ReadUInt16();
int rk = reader.ReadInt32();
RKs[n] = RkRecord.Convet(rk);
}
}
public IndexRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
uint reserved = reader.ReadUInt32();
FirstRow = reader.ReadUInt32();
LastRow = reader.ReadUInt32();
reserved = reader.ReadUInt32();
//int nrows = (int)(stream.Length - stream.Position) / 4;
//Rows = new uint[nrows];
//nrows = 0;
//while (stream.Position < stream.Length)
// Rows[nrows++] = reader.ReadUInt32();
}
public BoolErrRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
SetRowColXf(reader);
byte boolErr = reader.ReadByte();
Error = reader.ReadByte() == 1;
if (Error)
{
SetBoolErrValue(boolErr);
}
else
{
Value = boolErr == 1;
}
}
public MergeCellsRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
var count = reader.ReadUInt16();
MergeCells = new List <MergeCell>();
for (int i = 0; i < count; i++)
{
MergeCells.Add(new MergeCell()
{
FirstRow = reader.ReadUInt16(),
LastRow = reader.ReadUInt16(),
FirstCol = reader.ReadUInt16(),
LastCol = reader.ReadUInt16(),
});
}
}
public SstRecord(BIFFData data, Stream stream)
{
var dataStream = data.ToStream();
BinaryReader reader = new BinaryReader(dataStream);
uint totalStrings = reader.ReadUInt32();
uint totalUniqueStrings = reader.ReadUInt32();
Strings = new string[totalUniqueStrings];
StringBuilder sb = new StringBuilder();
for (int i = 0; i < totalUniqueStrings; ++i)
{
GetNewReader(stream, ref dataStream, ref reader);
ushort len = reader.ReadUInt16();
byte options = reader.ReadByte();
bool compressed = (options & 0x01) == 0;
bool farEast = (options & 0x04) != 0;
bool richText = (options & 0x08) != 0;
ushort rtSize = 0;
uint farEastSize = 0;
if (richText)
{
rtSize = reader.ReadUInt16();
}
if (farEast)
{
farEastSize = reader.ReadUInt32();
}
HandleChar(stream, ref dataStream, reader, sb, len, ref compressed);
Strings[i] = sb.ToString();
long skip = (rtSize * 4) + farEastSize;
ReadSkip(stream, ref dataStream, ref reader, ref skip);
}
}
public EofRecord(BIFFData data, Stream stream)
{
}
private Stream ReadContinue(Stream stream)
{
BIFFData biff = new BIFFData(stream);
return(new ContinueRecord(biff, stream).Data.ToStream());
}
public LabelSstRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
SetRowColXf(reader);
SSTIndex = reader.ReadUInt32();
}
public FormulaRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
SetRowColXf(reader);
}
public ContinueRecord(BIFFData data, Stream stream)
{
Data = data.Data;
}
public MulBlankRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
}
public FormulaRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
SetRowColXf(reader);
}
public StringValueRecord(BIFFData data, Stream stream)
{
BinaryReader reader = new BinaryReader(data.ToStream());
Value = reader.ReadComplexString();
}
