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

Head row all nils #126

Open
schnittchen opened this issue Sep 3, 2024 · 1 comment
Open

Head row all nils #126

schnittchen opened this issue Sep 3, 2024 · 1 comment

Comments

@schnittchen
Copy link

Hello,

I have a weird issue with a file containing all the data, except that the first (head) row is all nils.

Here's my code:

  def load_sheet(_xlsx_file_path = path) do
    [ok: table_id] = Xlsxir.multi_extract(path)

    result = Xlsxir.get_list(table_id)

    Xlsxir.close(table_id)

    result
  end 

I suspect there's something broken about the xlsx file, but I can't be sure. I tried to produce a version with only the head row both in LibreOffice and in some version of Excel, but when I do that, I read the proper head row.

I can't disclose the file here because it contains PII.

I peeked into the ets table and saw that the head row was stored there with those nil values already.

Do you have any idea what might cause this?

@lowercase
Copy link

unzip the xlsx, maybe the same problem as me
#131

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

No branches or pull requests

2 participants