Пример #1
0
        /// <summary>
        /// Returns an index into Workbook.ExtendedFormats for the given cell and preceding ixfe record.
        /// </summary>
        private int GetXfIndexForCell(XlsBiffBlankCell cell, XlsBiffRecord ixfe)
        {
            if (Workbook.BiffVersion == 2)
            {
                if (cell.XFormat == 63 && ixfe != null)
                {
                    var xFormat = ixfe.ReadUInt16(0);
                    return(xFormat);
                }
                else if (cell.XFormat > 63)
                {
                    // Invalid XF ref on cell in BIFF2 stream
                    return(-1);
                }
                else if (cell.XFormat < Workbook.ExtendedFormats.Count)
                {
                    return(cell.XFormat);
                }
                else
                {
                    // Either the file has no XFs, or XF was out of range
                    return(-1);
                }
            }

            return(cell.XFormat);
        }
Пример #2
0
        /// <summary>
        /// Reads record at specified offset, does not change cursor position
        /// </summary>
        /// <param name="offset"></param>
        /// <returns></returns>
        public XlsBiffRecord ReadAt(int offset)
        {
            XlsBiffRecord rec = XlsBiffRecord.GetRecord(bytes, (uint)offset);

            if (m_offset + rec.Size > m_size)
            {
                return(null);
            }
            return(rec);
        }
Пример #3
0
        public XlsBiffRecord ReadAt(int offset)
        {
            XlsBiffRecord record = XlsBiffRecord.GetRecord(this.bytes, (uint)offset);

            if ((this.m_offset + record.Size) > this.m_size)
            {
                return(null);
            }
            return(record);
        }
Пример #4
0
        private XlsRowBlock ReadNextBlock(XlsBiffStream biffStream, int startRow, int rows, int minOffset, int maxOffset)
        {
            var result = new XlsRowBlock {
                Rows = new Dictionary <int, Row>()
            };

            // Ensure rows with physical records are initialized with height
            for (var i = 0; i < rows; i++)
            {
                if (RowOffsetMap.TryGetValue(startRow + i, out _))
                {
                    EnsureRow(result, startRow + i);
                }
            }

            if (minOffset == int.MaxValue)
            {
                return(result);
            }

            biffStream.Position = minOffset;

            XlsBiffRecord rec;
            XlsBiffRecord ixfe = null;

            while (biffStream.Position <= maxOffset && (rec = biffStream.Read()) != null)
            {
                if (rec.Id == BIFFRECORDTYPE.IXFE)
                {
                    // BIFF2: If cell.xformat == 63, this contains the actual XF index >= 63
                    ixfe = rec;
                }

                if (rec is XlsBiffBlankCell cell)
                {
                    var currentRow = EnsureRow(result, cell.RowIndex);

                    if (cell.Id == BIFFRECORDTYPE.MULRK)
                    {
                        var cellValues = ReadMultiCell(cell);
                        currentRow.Cells.AddRange(cellValues);
                    }
                    else
                    {
                        var xfIndex   = GetXfIndexForCell(cell, ixfe);
                        var cellValue = ReadSingleCell(biffStream, cell, xfIndex);
                        currentRow.Cells.Add(cellValue);
                    }

                    ixfe = null;
                }
            }

            return(result);
        }
Пример #5
0
        public XlsBiffRecord Read()
        {
            XlsBiffRecord rec = XlsBiffRecord.GetRecord(bytes, (uint)m_offset);

            m_offset += rec.Size;
            if (m_offset > m_size)
            {
                return(null);
            }
            return(rec);
        }
Пример #6
0
        public XlsBiffRecord Read()
        {
            XlsBiffRecord record = XlsBiffRecord.GetRecord(this.bytes, (uint)this.m_offset);

            this.m_offset += record.Size;
            if (this.m_offset > this.m_size)
            {
                return(null);
            }
            return(record);
        }
Пример #7
0
        /// <summary>
        /// Reads record at specified offset, does not change cursor position
        /// </summary>
        /// <param name="offset"></param>
        /// <returns></returns>
        public XlsBiffRecord ReadAt(int offset)
        {
            XlsBiffRecord rec = XlsBiffRecord.GetRecord(bytes, (uint)offset, reader);

            //choose ReadOption.Loose to skip this check (e.g. sql reporting services)
            if (reader.ReadOption == ReadOption.Strict)
            {
                if (m_offset + rec.Size > m_size)
                {
                    return(null);
                }
            }

            return(rec);
        }
Пример #8
0
        public XlsBiffRecord Read()
        {
            if ((uint)m_offset >= bytes.Length)
            {
                return(null);
            }

            XlsBiffRecord rec = XlsBiffRecord.GetRecord(bytes, (uint)m_offset, reader);

            m_offset += rec.Size;
            if (m_offset > m_size)
            {
                return(null);
            }
            return(rec);
        }