Limit the data area #16
Description
First of all, fantastic library! Good job!
The "issue" is not the case, it's more a suggestion.
- The user browse/drops the excel file.
- Modal window requests to specify:
2.1 Header row(optional) - e.g. A2:D2
2.2 Data area(required) - e.g A3:D400
- Checkbox "Until the first blank row" (in case user has multiple tables on 1 page)
I am working with very big files and reading the entire file if the user requires only first 3(!) rows takes too much time. What I have done is I break the sequence before the cell parsing and return the sheets array so user could select a reading sheet as well. When all data is gathered, here is the tricky part, I start the reading again with limits set, where cell has to match chosen sheet and r:c limits. It's definitely not the best solution, but if you want I could share it by the time I am done. I still have to run some testing.
P.S. For some reasons I could never achieve "d" as a cell type. So trying to fix that by creating my own cell pattern to match.
P.S.S Very good job! Exquisite!
P.S.S.S English is not my native language