zhao
2021-06-24 02ca96debc6056275d58e55d97f7885a195542d0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
 
namespace HH.WMS.Utils.ExcelLibrary.BinaryFileFormat
{
    /// <summary>
    /// contains relative offsets to calculate the stream position of the first cell
    /// record for each row in each row block.
    /// </summary>
    public partial class DBCELL : Record
    {
        public DBCELL(Record record) : base(record) { }
 
        public DBCELL()
        {
            this.Type = RecordType.DBCELL;
            this.FirstCellOffsets = new List<UInt16>();
        }
 
        /// <summary>
        /// Relative offset to first ROW record in the Row Block
        /// </summary>
        public UInt32 FirstRowOffset;
 
        /// <summary>
        /// relative offsets to calculate stream position of the first cell record for the respective row
        /// </summary>
        public List<UInt16> FirstCellOffsets;
 
        public override void Decode()
        {
            MemoryStream stream = new MemoryStream(Data);
            BinaryReader reader = new BinaryReader(stream);
            this.FirstRowOffset = reader.ReadUInt32();
            int count = (this.Size - 4) / 2;
            this.FirstCellOffsets = new List<UInt16>(count);
            for (int i = 0; i < count; i++)
            {
                FirstCellOffsets.Add(reader.ReadUInt16());
            }
        }
 
        public override void Encode()
        {
            MemoryStream stream = new MemoryStream();
            BinaryWriter writer = new BinaryWriter(stream);
            writer.Write(FirstRowOffset);
            foreach(UInt16 uint16Var in FirstCellOffsets)
            {
                writer.Write(uint16Var);
            }
            this.Data = stream.ToArray();
            this.Size = (UInt16)Data.Length;
            base.Encode();
        }
 
    }
}