/// <summary>
/// Returns an index into Workbook.Formats for the given cell and preceding ixfe record.
/// </summary>
private int GetFormatIndexForCell(XlsBiffBlankCell cell, XlsBiffRecord ixfe)
{
if (Workbook.BiffVersion == 2)
{
if (cell.XFormat == 63 && ixfe != null)
{
var xFormat = ixfe.ReadUInt16(0);
return(Workbook.GetNumberFormatFromXF(xFormat));
}
else if (cell.XFormat > 63)
{
// Invalid XF ref on cell in BIFF2 stream, default to built-in "General"
return(0);
}
else if (cell.XFormat < Workbook.GetExtendedFormatCount())
{
return(Workbook.GetNumberFormatFromXF(cell.XFormat));
}
else
{
// Either the file has no XFs, or XF was out of range. Use the cell attributes' format reference.
return(Workbook.GetNumberFormatFromFileIndex(cell.Format));
}
}
return(Workbook.GetNumberFormatFromXF(cell.XFormat));
}
private XlsRowBlock ReadNextBlock(XlsBiffStream biffStream, int startRow, int rows)
{
var result = new XlsRowBlock {
Rows = new Dictionary <int, Row>()
};
XlsBiffRecord rec;
XlsBiffRecord ixfe = null;
if (!GetMinMaxOffsetsForRowBlock(startRow, rows, out var minOffset, out var maxOffset))
{
return(result);
}
biffStream.Position = minOffset;
while (biffStream.Position <= maxOffset && (rec = biffStream.Read()) != null)
{
if (rec.Id == BIFFRECORDTYPE.ROW || rec.Id == BIFFRECORDTYPE.ROW_V2)
{
var rowRecord = (XlsBiffRow)rec;
var currentRow = EnsureRow(result, rowRecord.RowIndex);
currentRow.Height = (rowRecord.UseDefaultRowHeight ? DefaultRowHeight : rowRecord.RowHeight) / 20.0;
}
if (rec.Id == BIFFRECORDTYPE.IXFE)
{
// BIFF2: If cell.xformat == 63, this contains the actual XF index >= 63
ixfe = rec;
}
if (rec.IsCell)
{
var cell = (XlsBiffBlankCell)rec;
var currentRow = EnsureRow(result, cell.RowIndex);
if (cell.Id == BIFFRECORDTYPE.MULRK)
{
var cellValues = ReadMultiCell(cell);
currentRow.Cells.AddRange(cellValues);
}
else
{
ushort xFormat;
if (Workbook.BiffVersion == 2 && cell.XFormat == 63 && ixfe != null)
{
xFormat = ixfe.ReadUInt16(0);
}
else
{
xFormat = cell.XFormat;
}
var cellValue = ReadSingleCell(biffStream, cell, xFormat);
currentRow.Cells.Add(cellValue);
}
ixfe = null;
}
}
return(result);
}
private XlsRowBlock ReadNextBlock(XlsBiffStream biffStream)
{
var result = new XlsRowBlock {
Rows = new Dictionary <int, object[]>()
};
var currentRowIndex = -1;
object[] currentRow = null;
XlsBiffRecord rec;
XlsBiffRecord ixfe = null;
while ((rec = biffStream.Read()) != null)
{
if (rec is XlsBiffEof)
{
result.EndOfSheet = true;
break;
}
if (rec is XlsBiffMSODrawing || (!RowContentInMultipleBlocks && rec is XlsBiffDbCell))
{
break;
}
if (rec.Id == BIFFRECORDTYPE.IXFE)
{
// BIFF2: If cell.xformat == 63, this contains the actual XF index >= 63
ixfe = rec;
}
if (rec is XlsBiffBlankCell cell)
{
// In most cases cells are grouped by row
if (currentRowIndex != cell.RowIndex)
{
if (!result.Rows.TryGetValue(cell.RowIndex, out currentRow))
{
currentRow = new object[FieldCount];
result.Rows.Add(cell.RowIndex, currentRow);
}
currentRowIndex = cell.RowIndex;
}
ushort xFormat;
if (Workbook.BiffVersion == 2 && cell.XFormat == 63 && ixfe != null)
{
xFormat = ixfe.ReadUInt16(0);
}
else
{
xFormat = cell.XFormat;
}
var additionalRecords = new List <XlsBiffRecord>();
while (!PushCellValue(currentRow, cell, xFormat, additionalRecords))
{
var additionalRecord = biffStream.Read();
additionalRecords.Add(additionalRecord);
}
ixfe = null;
}
}
return(result);
}