lwhite1
commented
2 years ago I'm just guessing as i'm not really familiar with this, but i believe the code uses an Apache library for the Excel parsing, and it relies on Excel's interpretation of what type is found in a cell. I suspect it is treating '0' as a missing value.
On Thu, Sep 15, 2022 at 3:34 AM Piyush-Shell @.***> wrote:
I want to read excel where data is as follows.
col1, col2, col3 0, 0, 0 1, 10, 20 2, 30, 40
So its only parsing the header and no data, but if I change any of "0" value like,
col1, col2, col3 0, 0, 1 1, 10, 20 2, 30, 40
then it reads the entire table. Also if parse table like,
col1, col2, col3 1, 10, 20 0, 0, 0 2, 30, 40
then it only reads till row (1, 10, 20) and no data after that.
Can anyone suggest why when an entire row is "0" it is not parsing the rows, and how to read such tables?
— Reply to this email directly, view it on GitHub https://github.com/jtablesaw/tablesaw/issues/1147, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA2FPAQ7MZULLBB3G2KT6XDV6LGRNANCNFSM6AAAAAAQNDIQTU . You are receiving this because you are subscribed to this thread.Message ID: @.***>
mo20053444
I want to read excel where data is as follows.
col1, col2, col3 0, 0, 0 1, 10, 20 2, 30, 40
So its only parsing the header and no data, but if I change any of "0" value like,
col1, col2, col3 0, 0, 1 1, 10, 20 2, 30, 40
then it reads the entire table. Also if parse table like,
col1, col2, col3 1, 10, 20 0, 0, 0 2, 30, 40
then it only reads till row (1, 10, 20) and no data after that.
Can anyone suggest why when an entire row is "0" it is not parsing the rows, and how to read such tables?