record

package
v0.0.1 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Nov 24, 2022 License: GPL-3.0 Imports: 12 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
var ArrayRecord = []byte{0x021, 0x02} //(221h)
View Source
var AutofilterInfoRecord = [2]byte{0x9D, 0x00} // (9Dh)
View Source
var BOFMARKS = []byte{0x09, 0x08} //(809h)
View Source
var BlankRecord = []byte{0x01, 0x02} // (201h)
View Source
var BoolErrRecord = []byte{0x05, 0x02} // (205h)
View Source
var BoundSheetRecord = [2]byte{0x85, 0x00} // (85h)

This record stores the sheet name, sheet type, and stream position

View Source
var CodePageRecord = [2]byte{0x42, 0x00} //(42h)

CODEPAGE: Default Code Page

View Source
var ContinueRecord = [2]byte{0x3c, 0x00} //(0x3c)

CONTINUE: Continues Long Records

View Source
var EOFRecord = [2]byte{0x0A, 0x00} //(0Ah)

EOF : End of File00

View Source
var ExtSstRecord = [2]byte{0xFF, 0x00} // (FFh)
View Source
var FlagBIFF5 = []byte{0x00, 0x05}
View Source
var FlagBIFF8 = []byte{0x00, 0x06}

Record Data — BIFF8

Offset Field Name Size Contents -------------------------------------------- 4 vers 2 Version number:

=0600 for BIFF8

6 dt 2 Substream type:

0005h = Workbook globals
0006h = Visual Basic module
0010h = Worksheet or dialog sheet
0020h = Chart
0040h = Excel 4.0 macro sheet
0100h = Workspace file

8 rupBuild 2 Build identifier (=0DBBh for Excel 97) 10 rupYear 2 Build year (=07CCh for Excel 97) 12 bfh 4 File history flags 16 sfo 4 Lowest BIFF version (see text)

The rupBuild and rupYear fields contain numbers that identify the version (build)

 	of Excel that wrote the file. If you write a BIFF file, you can use the BiffView utility
	to determine the current values of these fields by examining a BOF record in a
	workbook file.

The sfo structure contains the earliest version ( vers structure) of Excel that can read all

records in this file.

The bfh structure contains the following flag bits:

Bits Mask Flag Name Contents -------------------------------------------- 0 00000001h fWin =1 if the file was last edited by Excel for Windows 1 00000002h fRisc =1 if the file was last edited by Excel on a RISC platform 2 00000004h fBeta =1 if the file was last edited by a beta version of Excel 3 00000008h fWinAny =1 if the file has ever been edited by Excel for Windows 4 00000010h fMacAny =1 if the file has ever been edited by Excel for the Macintosh 5 00000020h fBetaAny =1 if the file has ever been edited by a beta version of Excel 7–6 000000C0h (Reserved) Reserved; must be 0 (zero) 8 00000100h fRiscAny =1 if the file has ever been edited by Excel on a RISC platform 31–9 FFFFFE00 (Reserved) Reserved; must be 0 (zero)

View Source
var FormatRecord = []byte{0x1E, 0x04} // (41Eh)
View Source
var FormulaRecord = []byte{0x06, 0x00} // (6h)
View Source
var IndexRecord = [2]byte{0x02, 0x0B} // (20Bh)
View Source
var LabelRecord = []byte{0x04, 0x02} // (204h)
View Source
var LabelSStRecord = []byte{0xFD, 0x00} // (FDh)
View Source
var MulBlankRecord = []byte{0xBE, 0x00} // (BEh)
View Source
var MulRKRecord = []byte{0xBD, 0x00} // (BDh)
View Source
var NumberRecord = []byte{0x03, 0x02} // (203h)
View Source
var RStringRecord = []byte{0xD6, 0x00} // (D6h)
View Source
var RkRecord = []byte{0x7E, 0x02} // (7Eh)
View Source
var RowRecord = []byte{0x08, 0x02} // (208h)
View Source
var SSTRecord = [2]byte{0xFC, 0x00} // (FCh)
View Source
var SharedFormulaRecord = []byte{0xBC, 0x00} // (BCh)
View Source
var StringRecord = []byte{0x07, 0x02} // (207h)
View Source
var XFRecord = []byte{0xE0, 0x00} // (E0h)

Functions

This section is empty.

Types

type Array

type Array struct {
	RwFirst  [2]byte
	RwLast   [2]byte
	ColFirst [1]byte
	ColLast  [1]byte
	Grbit    [2]byte
	Chn      [4]byte
	Cce      [2]byte
	Rgce     []byte
}

type AutofilterInfo

type AutofilterInfo struct {
	// contains filtered or unexported fields
}

func (*AutofilterInfo) GetCountEntries

func (r *AutofilterInfo) GetCountEntries() uint16

func (*AutofilterInfo) Read

func (r *AutofilterInfo) Read(stream []byte)

type Blank

type Blank struct {
	// contains filtered or unexported fields
}

func (*Blank) Get

func (r *Blank) Get() *Blank

func (*Blank) GetCol

func (r *Blank) GetCol() [2]byte

func (*Blank) GetFloat64

func (r *Blank) GetFloat64() (fl float64)

func (*Blank) GetInt64

func (r *Blank) GetInt64() (in int64)

func (*Blank) GetRow

func (r *Blank) GetRow() [2]byte

func (*Blank) GetString

func (r *Blank) GetString() (str string)

func (*Blank) GetType

func (r *Blank) GetType() string

func (*Blank) GetXFIndex

func (r *Blank) GetXFIndex() int

func (*Blank) Read

func (r *Blank) Read(stream []byte)

type BoolErr

type BoolErr struct {
	// contains filtered or unexported fields
}

func (*BoolErr) GetCol

func (r *BoolErr) GetCol() [2]byte

func (*BoolErr) GetFloat

func (r *BoolErr) GetFloat() float64

func (*BoolErr) GetFloat64

func (r *BoolErr) GetFloat64() (fl float64)

func (*BoolErr) GetInt64

func (r *BoolErr) GetInt64() int64

func (*BoolErr) GetRow

func (r *BoolErr) GetRow() [2]byte

func (*BoolErr) GetString

func (r *BoolErr) GetString() string

func (*BoolErr) GetType

func (r *BoolErr) GetType() string

func (*BoolErr) GetXFIndex

func (r *BoolErr) GetXFIndex() int

func (*BoolErr) Read

func (r *BoolErr) Read(stream []byte)

type BoundSheet

type BoundSheet struct {
	LbPlyPos [4]byte
	Grbit    [2]byte
	Cch      [1]byte
	Rgch     []byte
	// contains filtered or unexported fields
}

func (*BoundSheet) GetName

func (r *BoundSheet) GetName() string

func (*BoundSheet) Read

func (r *BoundSheet) Read(stream []byte, vers []byte)

type CodePage

type CodePage struct {
	// contains filtered or unexported fields
}

func (*CodePage) Read

func (r *CodePage) Read(stream []byte)

type Continue

type Continue struct {
	// contains filtered or unexported fields
}

type ExtSST

type ExtSST struct {
	// contains filtered or unexported fields
}

func (*ExtSST) GetRgisstinf

func (r *ExtSST) GetRgisstinf() []structure.ISSTINF

func (*ExtSST) Read

func (r *ExtSST) Read(stream []byte)

type FakeBlank

type FakeBlank struct {
}

func (*FakeBlank) GetFloat64

func (r *FakeBlank) GetFloat64() (fl float64)

func (*FakeBlank) GetInt64

func (r *FakeBlank) GetInt64() (in int64)

func (*FakeBlank) GetString

func (r *FakeBlank) GetString() (str string)

func (*FakeBlank) GetType

func (r *FakeBlank) GetType() string

func (*FakeBlank) GetXFIndex

func (r *FakeBlank) GetXFIndex() int

type Format

type Format struct {
	// contains filtered or unexported fields
}

func (*Format) GetFormatString

func (r *Format) GetFormatString(data structure.CellData) string

func (*Format) GetIndex

func (r *Format) GetIndex() int

func (*Format) Read

func (r *Format) Read(stream []byte, vers []byte)

func (*Format) String

func (r *Format) String() string

type Formula

type Formula struct {
	// contains filtered or unexported fields
}

func (*Formula) GetXFIndex

func (r *Formula) GetXFIndex() int

func (*Formula) Read

func (r *Formula) Read(stream []byte)

type Index

type Index struct {
	// contains filtered or unexported fields
}

func (*Index) GetMaxRow

func (r *Index) GetMaxRow() uint32

func (*Index) Read

func (r *Index) Read(stream []byte)

type LabelBIFF5

type LabelBIFF5 struct {
	// contains filtered or unexported fields
}

func (*LabelBIFF5) GetCol

func (r *LabelBIFF5) GetCol() [2]byte

func (*LabelBIFF5) GetFloat64

func (r *LabelBIFF5) GetFloat64() (fl float64)

func (*LabelBIFF5) GetInt64

func (r *LabelBIFF5) GetInt64() (in int64)

func (*LabelBIFF5) GetRow

func (r *LabelBIFF5) GetRow() [2]byte

func (*LabelBIFF5) GetString

func (r *LabelBIFF5) GetString() string

func (*LabelBIFF5) GetType

func (r *LabelBIFF5) GetType() string

func (*LabelBIFF5) GetXFIndex

func (r *LabelBIFF5) GetXFIndex() int

func (*LabelBIFF5) Read

func (r *LabelBIFF5) Read(stream []byte)

type LabelBIFF8

type LabelBIFF8 struct {
	// contains filtered or unexported fields
}

func (*LabelBIFF8) GetCol

func (r *LabelBIFF8) GetCol() [2]byte

func (*LabelBIFF8) GetFloat64

func (r *LabelBIFF8) GetFloat64() (fl float64)

func (*LabelBIFF8) GetInt64

func (r *LabelBIFF8) GetInt64() (in int64)

func (*LabelBIFF8) GetRow

func (r *LabelBIFF8) GetRow() [2]byte

func (*LabelBIFF8) GetString

func (r *LabelBIFF8) GetString() string

func (*LabelBIFF8) GetType

func (r *LabelBIFF8) GetType() string

func (*LabelBIFF8) GetXFIndex

func (r *LabelBIFF8) GetXFIndex() int

func (*LabelBIFF8) Read

func (r *LabelBIFF8) Read(stream []byte)

type LabelSSt

type LabelSSt struct {
	// contains filtered or unexported fields
}

func (*LabelSSt) GetCol

func (r *LabelSSt) GetCol() [2]byte

func (*LabelSSt) GetFloat64

func (r *LabelSSt) GetFloat64() (fl float64)

func (*LabelSSt) GetInt64

func (r *LabelSSt) GetInt64() (in int64)

func (*LabelSSt) GetRow

func (r *LabelSSt) GetRow() [2]byte

func (*LabelSSt) GetString

func (r *LabelSSt) GetString() string

func (*LabelSSt) GetType

func (r *LabelSSt) GetType() string

func (*LabelSSt) GetXFIndex

func (r *LabelSSt) GetXFIndex() int

func (*LabelSSt) Read

func (r *LabelSSt) Read(stream []byte, sst *SST)

type MulBlank

type MulBlank struct {
	// contains filtered or unexported fields
}

func (*MulBlank) GetArrayBlRecord

func (r *MulBlank) GetArrayBlRecord() (blkRecords []Blank)

func (*MulBlank) Read

func (r *MulBlank) Read(stream []byte)

type MulRk

type MulRk struct {
	// contains filtered or unexported fields
}

func (*MulRk) GetArrayRKRecord

func (r *MulRk) GetArrayRKRecord() (rkRecords []Rk)

func (*MulRk) Read

func (r *MulRk) Read(stream []byte)

type Number

type Number struct {
	// contains filtered or unexported fields
}

func (*Number) GetCol

func (r *Number) GetCol() [2]byte

func (*Number) GetFloat

func (r *Number) GetFloat() float64

func (*Number) GetFloat64

func (r *Number) GetFloat64() (fl float64)

func (*Number) GetInt64

func (r *Number) GetInt64() (in int64)

func (*Number) GetRow

func (r *Number) GetRow() [2]byte

func (*Number) GetString

func (r *Number) GetString() string

func (*Number) GetType

func (r *Number) GetType() string

func (*Number) GetXFIndex

func (r *Number) GetXFIndex() int

func (*Number) Read

func (r *Number) Read(stream []byte)

type RString

type RString struct {
	Rw      [2]byte
	Col     [2]byte
	Ixfe    [2]byte
	Cch     [2]byte
	Rgch    []byte
	Cruns   [1]byte
	Rgstrun []byte
}

type Rk

type Rk struct {
	// contains filtered or unexported fields
}

func (*Rk) Get

func (r *Rk) Get() *Rk

func (*Rk) GetCol

func (r *Rk) GetCol() [2]byte

func (*Rk) GetFloat64

func (r *Rk) GetFloat64() float64

func (*Rk) GetInt64

func (r *Rk) GetInt64() int64

func (*Rk) GetRow

func (r *Rk) GetRow() [2]byte

func (*Rk) GetString

func (r *Rk) GetString() (s string)

func (*Rk) GetType

func (r *Rk) GetType() string

func (*Rk) GetXFIndex

func (r *Rk) GetXFIndex() int

func (*Rk) Read

func (r *Rk) Read(stream []byte)

type Row

type Row struct {
	Rw       [2]byte
	ColMic   [2]byte
	ColMac   [2]byte
	MiyRw    [2]byte
	IrwMac   [2]byte
	Reserved [2]byte
	Grbit    [2]byte
	Ixfe     [2]byte
}

type SST

type SST struct {
	CstTotal  [4]byte
	CstUnique [4]byte
	RgbSrc    []byte
	Rgb       []structure.XLUnicodeRichExtendedString

	ByteLen int

	// These are needed to properly handle CONTINUE records.
	// CONTINUE record contains grbit in the first byte unless it's a formatting run
	// so we need to know whether all the string bytes have been consumed.
	// OpenOffice.org - Microsoft Excel File Format - section 5.21
	RgbDone bool
	Grbit   byte
	// contains filtered or unexported fields
}

func (*SST) NewSST

func (s *SST) NewSST(buf []byte)

func (*SST) Read

func (s *SST) Read(readType string, grbit byte, prevLen int32)

func (*SST) RgbAppend

func (s *SST) RgbAppend(bts []byte) (err error)

type ShareFormula

type ShareFormula struct {
	RwFirst  [2]byte
	RwLast   [2]byte
	ColFirst [1]byte
	ColLast  [1]byte
	Reserved [2]byte
	Cce      [2]byte
	Rgce     []byte
}

type String

type String struct {
	Cch   [2]byte
	Grbit [2]byte
	Rgch  []byte
}

type XF

type XF struct {
	// contains filtered or unexported fields
}

func (*XF) GetFormatIndex

func (r *XF) GetFormatIndex() int

func (*XF) Read

func (r *XF) Read(stream []byte)

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL