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 DataTableState::from_excel). 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.

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.