xls

Documentation

Overview

Package xls implements the Microsoft Excel Binary File Format (.xls) Structure. More specifically, it contains just enough detail to extract cell contents, data types, and last-calculated formula values. In particular, it does NOT implement formatting or formula calculations.

Index

• Constants
• func Open(filename string) (grate.Source, error)
• type RKNumber
  • func (r RKNumber) Float64() float64
  • func (r RKNumber) Int() int
  • func (r RKNumber) IsInteger() bool
  • func (r RKNumber) String() string
• type RkRec
• type WorkBook
  • func (b *WorkBook) Close() error
  • func (b *WorkBook) Get(sheetName string) (grate.Collection, error)
  • func (b *WorkBook) IsProtected() bool
  • func (b *WorkBook) List() ([]string, error)
  • func (b *WorkBook) ListHidden() ([]string, error)
• type WorkSheet
  • func (s *WorkSheet) Err() error
  • func (s *WorkSheet) IsEmpty() bool
  • func (s *WorkSheet) Next() bool
  • func (s *WorkSheet) Scan(args ...interface{}) error
  • func (s *WorkSheet) Strings() []string

Constants

const (
	RecTypeFormula              recordType = 6    // per section 2.4.127
	RecTypeEOF                  recordType = 10   // section 2.4.103
	RecTypeCalcCount            recordType = 12   // section 2.4.31
	RecTypeCalcMode             recordType = 13   // section 2.4.34
	RecTypeCalcPrecision        recordType = 14   // section 2.4.35
	RecTypeCalcRefMode          recordType = 15   // section 2.4.36
	RecTypeCalcDelta            recordType = 16   // section 2.4.32
	RecTypeCalcIter             recordType = 17   // section 2.4.33
	RecTypeProtect              recordType = 18   // section 2.4.207
	RecTypePassword             recordType = 19   // section 2.4.191
	RecTypeHeader               recordType = 20   // section 2.4.136
	RecTypeFooter               recordType = 21   // section 2.4.124
	RecTypeExternSheet          recordType = 23   // section 2.4.106
	RecTypeLbl                  recordType = 24   // section 2.4.150
	RecTypeWinProtect           recordType = 25   // section 2.4.347
	RecTypeVerticalPageBreaks   recordType = 26   // section 2.4.343
	RecTypeHorizontalPageBreaks recordType = 27   // section 2.4.142
	RecTypeNote                 recordType = 28   // section 2.4.179
	RecTypeSelection            recordType = 29   // section 2.4.248
	RecTypeDate1904             recordType = 34   // section 2.4.77
	RecTypeExternName           recordType = 35   // section 2.4.105
	RecTypeLeftMargin           recordType = 38   // section 2.4.151
	RecTypeRightMargin          recordType = 39   // section 2.4.219
	RecTypeTopMargin            recordType = 40   // section 2.4.328
	RecTypeBottomMargin         recordType = 41   // section 2.4.27
	RecTypePrintRowCol          recordType = 42   // section 2.4.203
	RecTypePrintGrid            recordType = 43   // section 2.4.202
	RecTypeFilePass             recordType = 47   // section 2.4.117
	RecTypeFont                 recordType = 49   // section 2.4.122
	RecTypePrintSize            recordType = 51   // section 2.4.204
	RecTypeContinue             recordType = 60   // section 2.4.58
	RecTypeWindow1              recordType = 61   // section 2.4.345
	RecTypeBackup               recordType = 64   // section 2.4.14
	RecTypePane                 recordType = 65   // section 2.4.189
	RecTypeCodePage             recordType = 66   // section 2.4.52
	RecTypePls                  recordType = 77   // section 2.4.199
	RecTypeDCon                 recordType = 80   // section 2.4.82
	RecTypeDConRef              recordType = 81   // section 2.4.86
	RecTypeDConName             recordType = 82   // section 2.4.85
	RecTypeDefColWidth          recordType = 85   // section 2.4.89
	RecTypeXCT                  recordType = 89   // section 2.4.352
	RecTypeCRN                  recordType = 90   // section 2.4.65
	RecTypeFileSharing          recordType = 91   // section 2.4.118
	RecTypeWriteAccess          recordType = 92   // section 2.4.349
	RecTypeObj                  recordType = 93   // section 2.4.181
	RecTypeUncalced             recordType = 94   // section 2.4.331
	RecTypeCalcSaveRecalc       recordType = 95   // section 2.4.37
	RecTypeTemplate             recordType = 96   // section 2.4.323
	RecTypeIntl                 recordType = 97   // section 2.4.147
	RecTypeObjProtect           recordType = 99   // section 2.4.183
	RecTypeColInfo              recordType = 125  // section 2.4.53
	RecTypeGuts                 recordType = 128  // section 2.4.134
	RecTypeWsBool               recordType = 129  // section 2.4.351
	RecTypeGridSet              recordType = 130  // section 2.4.132
	RecTypeHCenter              recordType = 131  // section 2.4.135
	RecTypeVCenter              recordType = 132  // section 2.4.342
	RecTypeBoundSheet8          recordType = 133  // section 2.4.28
	RecTypeWriteProtect         recordType = 134  // section 2.4.350
	RecTypeCountry              recordType = 140  // section 2.4.63
	RecTypeHideObj              recordType = 141  // section 2.4.139
	RecTypeSort                 recordType = 144  // section 2.4.263
	RecTypePalette              recordType = 146  // section 2.4.188
	RecTypeSync                 recordType = 151  // section 2.4.318
	RecTypeLPr                  recordType = 152  // section 2.4.158
	RecTypeDxGCol               recordType = 153  // section 2.4.98
	RecTypeFnGroupName          recordType = 154  // section 2.4.120
	RecTypeFilterMode           recordType = 155  // section 2.4.119
	RecTypeBuiltInFnGroupCount  recordType = 156  // section 2.4.30
	RecTypeAutoFilterInfo       recordType = 157  // section 2.4.8
	RecTypeAutoFilter           recordType = 158  // section 2.4.6
	RecTypeScl                  recordType = 160  // section 2.4.247
	RecTypeSetup                recordType = 161  // section 2.4.257
	RecTypeScenMan              recordType = 174  // section 2.4.246
	RecTypeSCENARIO             recordType = 175  // section 2.4.244
	RecTypeSxView               recordType = 176  // section 2.4.313
	RecTypeSxvd                 recordType = 177  // section 2.4.309
	RecTypeSXVI                 recordType = 178  // section 2.4.312
	RecTypeSxIvd                recordType = 180  // section 2.4.292
	RecTypeSXLI                 recordType = 181  // section 2.4.293
	RecTypeSXPI                 recordType = 182  // section 2.4.298
	RecTypeDocRoute             recordType = 184  // section 2.4.91
	RecTypeRecipName            recordType = 185  // section 2.4.216
	RecTypeMulRk                recordType = 189  // section 2.4.175
	RecTypeMulBlank             recordType = 190  // section 2.4.174
	RecTypeMms                  recordType = 193  // section 2.4.169
	RecTypeSXDI                 recordType = 197  // section 2.4.278
	RecTypeSXDB                 recordType = 198  // section 2.4.275
	RecTypeSXFDB                recordType = 199  // section 2.4.283
	RecTypeSXDBB                recordType = 200  // section 2.4.276
	RecTypeSXNum                recordType = 201  // section 2.4.296
	RecTypeSxBool               recordType = 202  // section 2.4.274
	RecTypeSxErr                recordType = 203  // section 2.4.281
	RecTypeSXInt                recordType = 204  // section 2.4.289
	RecTypeSXString             recordType = 205  // section 2.4.304
	RecTypeSXDtr                recordType = 206  // section 2.4.279
	RecTypeSxNil                recordType = 207  // section 2.4.295
	RecTypeSXTbl                recordType = 208  // section 2.4.305
	RecTypeSXTBRGIITM           recordType = 209  // section 2.4.307
	RecTypeSxTbpg               recordType = 210  // section 2.4.306
	RecTypeObProj               recordType = 211  // section 2.4.185
	RecTypeSXStreamID           recordType = 213  // section 2.4.303
	RecTypeDBCell               recordType = 215  // section 2.4.78
	RecTypeSXRng                recordType = 216  // section 2.4.300
	RecTypeSxIsxoper            recordType = 217  // section 2.4.290
	RecTypeBookBool             recordType = 218  // section 2.4.22
	RecTypeDbOrParamQry         recordType = 220  // section 2.4.79
	RecTypeScenarioProtect      recordType = 221  // section 2.4.245
	RecTypeOleObjectSize        recordType = 222  // section 2.4.187
	RecTypeXF                   recordType = 224  // section 2.4.353
	RecTypeInterfaceHdr         recordType = 225  // section 2.4.146
	RecTypeInterfaceEnd         recordType = 226  // section 2.4.145
	RecTypeSXVS                 recordType = 227  // section 2.4.317
	RecTypeMergeCells           recordType = 229  // section 2.4.168
	RecTypeBkHim                recordType = 233  // section 2.4.19
	RecTypeMsoDrawingGroup      recordType = 235  // section 2.4.171
	RecTypeMsoDrawing           recordType = 236  // section 2.4.170
	RecTypeMsoDrawingSelection  recordType = 237  // section 2.4.172
	RecTypePhoneticInfo         recordType = 239  // section 2.4.192
	RecTypeSxRule               recordType = 240  // section 2.4.301
	RecTypeSXEx                 recordType = 241  // section 2.4.282
	RecTypeSxFilt               recordType = 242  // section 2.4.285
	RecTypeSxDXF                recordType = 244  // section 2.4.280
	RecTypeSxItm                recordType = 245  // section 2.4.291
	RecTypeSxName               recordType = 246  // section 2.4.294
	RecTypeSxSelect             recordType = 247  // section 2.4.302
	RecTypeSXPair               recordType = 248  // section 2.4.297
	RecTypeSxFmla               recordType = 249  // section 2.4.286
	RecTypeSxFormat             recordType = 251  // section 2.4.287
	RecTypeSST                  recordType = 252  // section 2.4.265
	RecTypeLabelSst             recordType = 253  // section 2.4.149
	RecTypeExtSST               recordType = 255  // section 2.4.107
	RecTypeSXVDEx               recordType = 256  // section 2.4.310
	RecTypeSXFormula            recordType = 259  // section 2.4.288
	RecTypeSXDBEx               recordType = 290  // section 2.4.277
	RecTypeRRDInsDel            recordType = 311  // section 2.4.228
	RecTypeRRDHead              recordType = 312  // section 2.4.226
	RecTypeRRDChgCell           recordType = 315  // section 2.4.223
	RecTypeRRTabID              recordType = 317  // section 2.4.241
	RecTypeRRDRenSheet          recordType = 318  // section 2.4.234
	RecTypeRRSort               recordType = 319  // section 2.4.240
	RecTypeRRDMove              recordType = 320  // section 2.4.231
	RecTypeRRFormat             recordType = 330  // section 2.4.238
	RecTypeRRAutoFmt            recordType = 331  // section 2.4.222
	RecTypeRRInsertSh           recordType = 333  // section 2.4.239
	RecTypeRRDMoveBegin         recordType = 334  // section 2.4.232
	RecTypeRRDMoveEnd           recordType = 335  // section 2.4.233
	RecTypeRRDInsDelBegin       recordType = 336  // section 2.4.229
	RecTypeRRDInsDelEnd         recordType = 337  // section 2.4.230
	RecTypeRRDConflict          recordType = 338  // section 2.4.224
	RecTypeRRDDefName           recordType = 339  // section 2.4.225
	RecTypeRRDRstEtxp           recordType = 340  // section 2.4.235
	RecTypeLRng                 recordType = 351  // section 2.4.159
	RecTypeUsesELFs             recordType = 352  // section 2.4.337
	RecTypeDSF                  recordType = 353  // section 2.4.94
	RecTypeCUsr                 recordType = 401  // section 2.4.72
	RecTypeCbUsr                recordType = 402  // section 2.4.40
	RecTypeUsrInfo              recordType = 403  // section 2.4.340
	RecTypeUsrExcl              recordType = 404  // section 2.4.339
	RecTypeFileLock             recordType = 405  // section 2.4.116
	RecTypeRRDInfo              recordType = 406  // section 2.4.227
	RecTypeBCUsrs               recordType = 407  // section 2.4.16
	RecTypeUsrChk               recordType = 408  // section 2.4.338
	RecTypeUserBView            recordType = 425  // section 2.4.333
	RecTypeUserSViewBegin       recordType = 426  // section 2.4.334
	RecTypeUserSViewBeginChart  recordType = 426  // section 2.4.335
	RecTypeUserSViewEnd         recordType = 427  // section 2.4.336
	RecTypeRRDUserView          recordType = 428  // section 2.4.237
	RecTypeQsi                  recordType = 429  // section 2.4.208
	RecTypeSupBook              recordType = 430  // section 2.4.271
	RecTypeProt4Rev             recordType = 431  // section 2.4.205
	RecTypeCondFmt              recordType = 432  // section 2.4.56
	RecTypeCF                   recordType = 433  // section 2.4.42
	RecTypeDVal                 recordType = 434  // section 2.4.96
	RecTypeDConBin              recordType = 437  // section 2.4.83
	RecTypeTxO                  recordType = 438  // section 2.4.329
	RecTypeRefreshAll           recordType = 439  // section 2.4.217
	RecTypeHLink                recordType = 440  // section 2.4.140
	RecTypeLel                  recordType = 441  // section 2.4.154
	RecTypeCodeName             recordType = 442  // section 2.4.51
	RecTypeSXFDBType            recordType = 443  // section 2.4.284
	RecTypeProt4RevPass         recordType = 444  // section 2.4.206
	RecTypeObNoMacros           recordType = 445  // section 2.4.184
	RecTypeDv                   recordType = 446  // section 2.4.95
	RecTypeExcel9File           recordType = 448  // section 2.4.104
	RecTypeRecalcID             recordType = 449  // section 2.4.215
	RecTypeEntExU2              recordType = 450  // section 2.4.102
	RecTypeDimensions           recordType = 512  // section 2.4.90
	RecTypeBlank                recordType = 513  // section 2.4.20
	RecTypeNumber               recordType = 515  // section 2.4.180
	RecTypeLabel                recordType = 516  // section 2.4.148
	RecTypeBoolErr              recordType = 517  // section 2.4.24
	RecTypeString               recordType = 519  // section 2.4.268
	RecTypeRow                  recordType = 520  // section 2.4.221
	RecTypeIndex                recordType = 523  // section 2.4.144
	RecTypeArray                recordType = 545  // section 2.4.4
	RecTypeDefaultRowHeight     recordType = 549  // section 2.4.87
	RecTypeTable                recordType = 566  // section 2.4.319
	RecTypeWindow2              recordType = 574  // section 2.4.346
	RecTypeRK                   recordType = 638  // section 2.4.220
	RecTypeStyle                recordType = 659  // section 2.4.269
	RecTypeBigName              recordType = 1048 // section 2.4.18
	RecTypeFormat               recordType = 1054 // section 2.4.126
	RecTypeContinueBigName      recordType = 1084 // section 2.4.59
	RecTypeShrFmla              recordType = 1212 // section 2.4.260
	RecTypeHLinkTooltip         recordType = 2048 // section 2.4.141
	RecTypeWebPub               recordType = 2049 // section 2.4.344
	RecTypeQsiSXTag             recordType = 2050 // section 2.4.211
	RecTypeDBQueryExt           recordType = 2051 // section 2.4.81
	RecTypeExtString            recordType = 2052 // section 2.4.108
	RecTypeTxtQry               recordType = 2053 // section 2.4.330
	RecTypeQsir                 recordType = 2054 // section 2.4.210
	RecTypeQsif                 recordType = 2055 // section 2.4.209
	RecTypeRRDTQSIF             recordType = 2056 // section 2.4.236
	RecTypeBOF                  recordType = 2057 // section 2.4.21
	RecTypeOleDbConn            recordType = 2058 // section 2.4.186
	RecTypeWOpt                 recordType = 2059 // section 2.4.348
	RecTypeSXViewEx             recordType = 2060 // section 2.4.314
	RecTypeSXTH                 recordType = 2061 // section 2.4.308
	RecTypeSXPIEx               recordType = 2062 // section 2.4.299
	RecTypeSXVDTEx              recordType = 2063 // section 2.4.311
	RecTypeSXViewEx9            recordType = 2064 // section 2.4.315
	RecTypeContinueFrt          recordType = 2066 // section 2.4.60
	RecTypeRealTimeData         recordType = 2067 // section 2.4.214
	RecTypeChartFrtInfo         recordType = 2128 // section 2.4.49
	RecTypeFrtWrapper           recordType = 2129 // section 2.4.130
	RecTypeStartBlock           recordType = 2130 // section 2.4.266
	RecTypeEndBlock             recordType = 2131 // section 2.4.100
	RecTypeStartObject          recordType = 2132 // section 2.4.267
	RecTypeEndObject            recordType = 2133 // section 2.4.101
	RecTypeCatLab               recordType = 2134 // section 2.4.38
	RecTypeYMult                recordType = 2135 // section 2.4.356
	RecTypeSXViewLink           recordType = 2136 // section 2.4.316
	RecTypePivotChartBits       recordType = 2137 // section 2.4.196
	RecTypeFrtFontList          recordType = 2138 // section 2.4.129
	RecTypeSheetExt             recordType = 2146 // section 2.4.259
	RecTypeBookExt              recordType = 2147 // section 2.4.23
	RecTypeSXAddl               recordType = 2148 // section 2.4.273.2
	RecTypeCrErr                recordType = 2149 // section 2.4.64
	RecTypeHFPicture            recordType = 2150 // section 2.4.138
	RecTypeFeatHdr              recordType = 2151 // section 2.4.112
	RecTypeFeat                 recordType = 2152 // section 2.4.111
	RecTypeDataLabExt           recordType = 2154 // section 2.4.75
	RecTypeDataLabExtContents   recordType = 2155 // section 2.4.76
	RecTypeCellWatch            recordType = 2156 // section 2.4.41
	RecTypeFeatHdr11            recordType = 2161 // section 2.4.113
	RecTypeFeature11            recordType = 2162 // section 2.4.114
	RecTypeDropDownObjIds       recordType = 2164 // section 2.4.93
	RecTypeContinueFrt11        recordType = 2165 // section 2.4.61
	RecTypeDConn                recordType = 2166 // section 2.4.84
	RecTypeList12               recordType = 2167 // section 2.4.157
	RecTypeFeature12            recordType = 2168 // section 2.4.115
	RecTypeCondFmt12            recordType = 2169 // section 2.4.57
	RecTypeCF12                 recordType = 2170 // section 2.4.43
	RecTypeCFEx                 recordType = 2171 // section 2.4.44
	RecTypeXFCRC                recordType = 2172 // section 2.4.354
	RecTypeXFExt                recordType = 2173 // section 2.4.355
	RecTypeAutoFilter12         recordType = 2174 // section 2.4.7
	RecTypeContinueFrt12        recordType = 2175 // section 2.4.62
	RecTypeMDTInfo              recordType = 2180 // section 2.4.162
	RecTypeMDXStr               recordType = 2181 // section 2.4.166
	RecTypeMDXTuple             recordType = 2182 // section 2.4.167
	RecTypeMDXSet               recordType = 2183 // section 2.4.165
	RecTypeMDXProp              recordType = 2184 // section 2.4.164
	RecTypeMDXKPI               recordType = 2185 // section 2.4.163
	RecTypeMDB                  recordType = 2186 // section 2.4.161
	RecTypePLV                  recordType = 2187 // section 2.4.200
	RecTypeCompat12             recordType = 2188 // section 2.4.54
	RecTypeDXF                  recordType = 2189 // section 2.4.97
	RecTypeTableStyles          recordType = 2190 // section 2.4.322
	RecTypeTableStyle           recordType = 2191 // section 2.4.320
	RecTypeTableStyleElement    recordType = 2192 // section 2.4.321
	RecTypeStyleExt             recordType = 2194 // section 2.4.270
	RecTypeNamePublish          recordType = 2195 // section 2.4.178
	RecTypeNameCmt              recordType = 2196 // section 2.4.176
	RecTypeSortData             recordType = 2197 // section 2.4.264
	RecTypeTheme                recordType = 2198 // section 2.4.326
	RecTypeGUIDTypeLib          recordType = 2199 // section 2.4.133
	RecTypeFnGrp12              recordType = 2200 // section 2.4.121
	RecTypeNameFnGrp12          recordType = 2201 // section 2.4.177
	RecTypeMTRSettings          recordType = 2202 // section 2.4.173
	RecTypeCompressPictures     recordType = 2203 // section 2.4.55
	RecTypeHeaderFooter         recordType = 2204 // section 2.4.137
	RecTypeCrtLayout12          recordType = 2205 // section 2.4.66
	RecTypeCrtMlFrt             recordType = 2206 // section 2.4.70
	RecTypeCrtMlFrtContinue     recordType = 2207 // section 2.4.71
	RecTypeForceFullCalculation recordType = 2211 // section 2.4.125
	RecTypeShapePropsStream     recordType = 2212 // section 2.4.258
	RecTypeTextPropsStream      recordType = 2213 // section 2.4.325
	RecTypeRichTextStream       recordType = 2214 // section 2.4.218
	RecTypeCrtLayout12A         recordType = 2215 // section 2.4.67
	RecTypeUnits                recordType = 4097 // section 2.4.332
	RecTypeChart                recordType = 4098 // section 2.4.45
	RecTypeSeries               recordType = 4099 // section 2.4.252
	RecTypeDataFormat           recordType = 4102 // section 2.4.74
	RecTypeLineFormat           recordType = 4103 // section 2.4.156
	RecTypeMarkerFormat         recordType = 4105 // section 2.4.160
	RecTypeAreaFormat           recordType = 4106 // section 2.4.3
	RecTypePieFormat            recordType = 4107 // section 2.4.195
	RecTypeAttachedLabel        recordType = 4108 // section 2.4.5
	RecTypeSeriesText           recordType = 4109 // section 2.4.254
	RecTypeChartFormat          recordType = 4116 // section 2.4.48
	RecTypeLegend               recordType = 4117 // section 2.4.152
	RecTypeSeriesList           recordType = 4118 // section 2.4.253
	RecTypeBar                  recordType = 4119 // section 2.4.15
	RecTypeLine                 recordType = 4120 // section 2.4.155
	RecTypePie                  recordType = 4121 // section 2.4.194
	RecTypeArea                 recordType = 4122 // section 2.4.2
	RecTypeScatter              recordType = 4123 // section 2.4.243
	RecTypeCrtLine              recordType = 4124 // section 2.4.68
	RecTypeAxis                 recordType = 4125 // section 2.4.11
	RecTypeTick                 recordType = 4126 // section 2.4.327
	RecTypeValueRange           recordType = 4127 // section 2.4.341
	RecTypeCatSerRange          recordType = 4128 // section 2.4.39
	RecTypeAxisLine             recordType = 4129 // section 2.4.12
	RecTypeCrtLink              recordType = 4130 // section 2.4.69
	RecTypeDefaultText          recordType = 4132 // section 2.4.88
	RecTypeText                 recordType = 4133 // section 2.4.324
	RecTypeFontX                recordType = 4134 // section 2.4.123
	RecTypeObjectLink           recordType = 4135 // section 2.4.182
	RecTypeFrame                recordType = 4146 // section 2.4.128
	RecTypeBegin                recordType = 4147 // section 2.4.17
	RecTypeEnd                  recordType = 4148 // section 2.4.99
	RecTypePlotArea             recordType = 4149 // section 2.4.197
	RecTypeChart3d              recordType = 4154 // section 2.4.46
	RecTypePicF                 recordType = 4156 // section 2.4.193
	RecTypeDropBar              recordType = 4157 // section 2.4.92
	RecTypeRadar                recordType = 4158 // section 2.4.212
	RecTypeSurf                 recordType = 4159 // section 2.4.272
	RecTypeRadarArea            recordType = 4160 // section 2.4.213
	RecTypeAxisParent           recordType = 4161 // section 2.4.13
	RecTypeLegendException      recordType = 4163 // section 2.4.153(
	RecTypeShtProps             recordType = 4164 // section 2.4.261
	RecTypeSerToCrt             recordType = 4165 // section 2.4.256
	RecTypeAxesUsed             recordType = 4166 // section 2.4.10
	RecTypeSBaseRef             recordType = 4168 // section 2.4.242
	RecTypeSerParent            recordType = 4170 // section 2.4.255
	RecTypeSerAuxTrend          recordType = 4171 // section 2.4.250
	RecTypeIFmtRecord           recordType = 4174 // section 2.4.143
	RecTypePos                  recordType = 4175 // section 2.4.201
	RecTypeAlRuns               recordType = 4176 // section 2.4.1
	RecTypeBRAI                 recordType = 4177 // section 2.4.29
	RecTypeSerAuxErrBar         recordType = 4187 // section 2.4.249
	RecTypeClrtClient           recordType = 4188 // section 2.4.50
	RecTypeSerFmt               recordType = 4189 // section 2.4.251
	RecTypeChart3DBarShape      recordType = 4191 // section 2.4.47
	RecTypeFbi                  recordType = 4192 // section 2.4.109
	RecTypeBopPop               recordType = 4193 // section 2.4.25
	RecTypeAxcExt               recordType = 4194 // section 2.4.9
	RecTypeDat                  recordType = 4195 // section 2.4.73
	RecTypePlotGrowth           recordType = 4196 // section 2.4.198
	RecTypeSIIndex              recordType = 4197 // section 2.4.262
	RecTypeGelFrame             recordType = 4198 // section 2.4.131
	RecTypeBopPopCustom         recordType = 4199 // section 2.4.26
	RecTypeFbi2                 recordType = 4200 // section 2.4.110
)

Record types defined by the XLS specification document, section 2.3/2.4. https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/43684742-8fcd-4fcd-92df-157d8d7241f9

Functions

func Open

func Open(filename string) (grate.Source, error)

Types

type RKNumber

type RKNumber uint32

func (RKNumber) Float64

func (r RKNumber) Float64() float64

func (RKNumber) Int

func (r RKNumber) Int() int

func (RKNumber) IsInteger

func (r RKNumber) IsInteger() bool

func (RKNumber) String

func (r RKNumber) String() string

type RkRec

type RkRec struct {
	IXFCell uint16
	Value   RKNumber
}

type WorkBook

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

WorkBook represents an Excel workbook containing 1 or more sheets.

func (*WorkBook) Close

func (b *WorkBook) Close() error

func (*WorkBook) Get

func (b *WorkBook) Get(sheetName string) (grate.Collection, error)

Get opens the named worksheet and return an iterator for its contents.

func (*WorkBook) IsProtected

func (b *WorkBook) IsProtected() bool

func (*WorkBook) List

func (b *WorkBook) List() ([]string, error)

List (visible) sheet names from the workbook.

func (*WorkBook) ListHidden

func (b *WorkBook) ListHidden() ([]string, error)

ListHidden sheet names in the workbook.

type WorkSheet

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

WorkSheet holds various metadata about a sheet in a Workbook.

func (*WorkSheet) Err

func (s *WorkSheet) Err() error

Err returns the last error that occured.

func (*WorkSheet) IsEmpty

func (s *WorkSheet) IsEmpty() bool

func (*WorkSheet) Next

func (s *WorkSheet) Next() bool

Next advances to the next row of content. It MUST be called prior to any Scan().

func (*WorkSheet) Scan

func (s *WorkSheet) Scan(args ...interface{}) error

Scan extracts values from the row into the provided arguments Arguments must be pointers to one of 5 supported types:

bool, int, float64, string, time.Time or interface{}

func (*WorkSheet) Strings

func (s *WorkSheet) Strings() []string

Strings returns the contents of the row as string types.