Module excel 

Excel workbooks: the sheets of one, listed on the home screen and summed up on the Info panel.

A sheet is read whole by calamine when it is opened (see read). What is said of the others comes from what that open read anyway, or from the start of each sheet: an .xlsx sheet declares its range (<dimension ref="A1:D100"/>) before its cells, so its size costs no read of them.

The home screen lists an .xlsx or .xlsm workbook’s sheets from its directory and xl/workbook.xml, a few KB however large the workbook. An .xls or .xlsb file keeps its sheet names in a binary stream that only a read of the workbook finds, so it opens its first sheet and --table names another.

Functions

detail

The Excel tab of the Info panel for a workbook whose sheet opened was read as range: each sheet’s range, the opened one’s from its cells and the others’ as their files declare it or as the open already parsed them.

is_listable

Whether head, the first bytes of file, begin a workbook whose sheets can be listed without reading it: a zip file holding xl/workbook.xml.

read

One sheet of a workbook (xls, xlsx, xlsm, xlsb), read whole by calamine, with the workbook’s Excel tab for the Info panel. The sheet is the one options.table (--table) names, or by 0-based index when no sheet is so named.

sheets

The sheets of the workbook at path, in the workbook’s order, for the home screen and --table. A hidden sheet is the workbook’s own, listed after Ctrl+A; a chart sheet holds no cells and is left out.