Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
visnup opened this issue Sep 28, 2021 · 1 comment
Open

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

visnup opened this issue Sep 28, 2021 · 1 comment
Labels
enhancement New feature or request

Comments

@visnup
Copy link
Member

visnup commented Sep 28, 2021

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 visnup added the enhancement New feature or request label Sep 28, 2021
@visnup
Copy link
Member Author

visnup commented Sep 28, 2021

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".

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant