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 ¶
View Source
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 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 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
Variables ¶
This section is empty.
Functions ¶
func PreserveDisplayText ¶
PreserveDisplayText is a HyperlinkFunc that keeps the cell's existing display text as the value and exposes the link target via Cell.URL()
Types ¶
type HyperlinkFunc ¶
HyperlinkFunc customizes how a hyperlink cell is stored when reading an .xls file. It receives the cell's existing value as read from the shared-string table (empty if the cell had none), the hyperlink record's own display name, and the link target. It returns the value to store in the cell and the URL to attach (an empty url attaches none).
var HandleHyperlink HyperlinkFunc
type WorkBook ¶
type WorkBook struct {
// contains filtered or unexported fields
}
WorkBook represents an Excel workbook containing 1 or more sheets.
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 (*WorkBook) ListHidden ¶
ListHidden sheet names in the workbook.
Source Files
Directories
¶
| Path | Synopsis |
|---|---|
|
Package cfb implements the Microsoft Compound File Binary File Format.
|
Package cfb implements the Microsoft Compound File Binary File Format. |
|
Package crypto implements excel encryption algorithms from the MS-OFFCRYPTO design specs.
|
Package crypto implements excel encryption algorithms from the MS-OFFCRYPTO design specs. |
Click to show internal directories.
Click to hide internal directories.