15.3. 规范与限制
下面的常量定义了 Excel 工作表和工作簿规范与限制:
const (
UnzipSizeLimit = 1000 << 24
StreamChunkSize = 1 << 24
MaxFontFamilyLength = 31
MaxFontSize = 409
MaxFileNameLength = 207
MaxFieldLength = 255
MaxColumnWidth = 255
MaxRowHeight = 409
TotalRows = 1048576
TotalColumns = 16384
TotalSheetHyperlinks = 65529
TotalCellChars = 32767
)
下面的常量定义了 EMU (English Metric Units) 单位:
const (
EMU int = 9525
)
下面的常量定义了 XML 文档中的独立声明:
const XMLHeader = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n"
以下这些常量定义了当前支持的数据验证类型:
const (
DataValidationTypeCustom
DataValidationTypeDate
DataValidationTypeDecimal
DataValidationTypeTextLength
DataValidationTypeTime
DataValidationTypeWhole
)
以下这些常量定义了当前支持的数据验证条件:
const (
DataValidationOperatorBetween
DataValidationOperatorEqual
DataValidationOperatorGreaterThan
DataValidationOperatorGreaterThanOrEqual
DataValidationOperatorLessThan
DataValidationOperatorLessThanOrEqual
DataValidationOperatorNotBetween
DataValidationOperatorNotEqual
)
CellType 定义了单元格的数据类型:
const (
CellTypeUnset CellType = iota
CellTypeBool
CellTypeDate
CellTypeError
CellTypeNumber
CellTypeString
)