biff

Documentation

Index

• Constants
• Variables
• func UnpackRK(rkBits uint32) (float64, error)
• func UnpackUnicode(data []byte, pos int, lenBytes int) (string, int, error)

Constants

const (
	XL_CELL_EMPTY   = 0
	XL_CELL_TEXT    = 1
	XL_CELL_NUMBER  = 2
	XL_CELL_DATE    = 3
	XL_CELL_BOOLEAN = 4
	XL_CELL_ERROR   = 5
	XL_CELL_BLANK   = 6
)

Cell types

const (
	XL_BOF        = 0x809
	XL_EOF        = 0x0A
	XL_BOUNDSHEET = 0x85
	XL_SST        = 0xFC
	XL_EXTSST     = 0xFF
	XL_CONTINUE   = 0x3C
	XL_LABEL      = 0x204
	XL_LABELSST   = 0xFD
	XL_NUMBER     = 0x203
	XL_RK         = 0x27E
	XL_MULRK      = 0xBD
	XL_MULBLANK   = 0xBE
	XL_BLANK      = 0x201
	XL_BOOLERR    = 0x205
	XL_FORMULA    = 0x06
	XL_STRING     = 0x207
	XL_ROW        = 0x208
	XL_DIMENSION  = 0x200
	XL_DIMENSION2 = 0x00
	XL_WINDOW2    = 0x23E
	XL_CODEPAGE   = 0x42
	XL_DATEMODE   = 0x22
	XL_XF         = 0xE0
	XL_FONT       = 0x31
	XL_FORMAT     = 0x41E
	XL_STYLE      = 0x293
	XL_SHEETHDR   = 0x8F // BIFF 4W only
	XL_ARRAY      = 0x221
	XL_SHRFMLA    = 0x4BC
	XL_TABLEOP    = 0x236
	XL_TABLEOP2   = 0x37
)

BIFF record types

Variables

var ErrorTextFromCode = map[byte]string{
	0x00: "#NULL!",
	0x07: "#DIV/0!",
	0x0F: "#VALUE!",
	0x17: "#REF!",
	0x1D: "#NAME?",
	0x24: "#NUM!",
	0x2A: "#N/A",
}

ErrorTextFromCode returns a text representation of an Excel error code.

Functions

func UnpackRK

func UnpackRK(rkBits uint32) (float64, error)

UnpackRK unpacks an RK number.

func UnpackUnicode

func UnpackUnicode(data []byte, pos int, lenBytes int) (string, int, error)

UnpackString unpacks a string from BIFF data (simplified for BIFF8 Unicode).