using System; using System.Collections.Generic; using System.Text; using System.IO; namespace HH.WMS.Utils.ExcelLibrary.BinaryFileFormat { public partial class BOUNDSHEET : Record { public BOUNDSHEET(Record record) : base(record) { } public BOUNDSHEET() { this.Type = RecordType.BOUNDSHEET; } /// /// Absolute stream position of the BOF record of the sheet represented by this record. /// public UInt32 StreamPosition; /// /// 00H = Visible, 01H = Hidden, 02H = Strong hidden /// public Byte Visibility; /// /// 00H = Worksheet, 02H = Chart, 06H = Visual Basic module /// public Byte SheetType; /// /// BIFF8: Unicode string, 8-bit string length /// public String SheetName; public override void Decode() { MemoryStream stream = new MemoryStream(Data); BinaryReader reader = new BinaryReader(stream); this.StreamPosition = reader.ReadUInt32(); this.Visibility = reader.ReadByte(); this.SheetType = reader.ReadByte(); this.SheetName = this.ReadString(reader, 8); } public override void Encode() { MemoryStream stream = new MemoryStream(); BinaryWriter writer = new BinaryWriter(stream); writer.Write(StreamPosition); writer.Write(Visibility); writer.Write(SheetType); Record.WriteString(writer, SheetName, 8); this.Data = stream.ToArray(); this.Size = (UInt16)Data.Length; base.Encode(); } } }