stdlib icon indicating copy to clipboard operation
stdlib copied to clipboard

Extract non-contiguous, multiple ranges from an XLSX sheet?

Open visnup opened this issue 4 years ago • 1 comments

The .sheet() function to extract data out of a XLSX sheet is limited to specifying a single, contiguous range. We've seen several cases so far where after extracting an initial range, we need to re-filter the result to skip empty rows that are interleaved with the data.

Currently we can do this in the notebook, but there might be a more flexible API to make this easier?

visnup avatar Sep 28 '21 16:09 visnup

Another case: keep reading rows but stop short of a totals or summary row. Although in that case, supporting "negative" rows or columns similar to slice could work. For example, "2:-10".

visnup avatar Sep 28 '21 20:09 visnup