Giter VIP home page Giter VIP logo

Comments (3)

redchair123 avatar redchair123 commented on May 4, 2024

(both are clearly bugs and I'm currently testing a patch)

Quick summary of what happened:

In the first case (from gdocs), neither the core properties nor the worksheet dimensions were emitted by google docs (both of which I assumed were included in every xlsx workbook).

The fix is to have the parser deduce the dimensions if its not provided (and to use sheet names from the workbook manifest if the properties are not provided)

In the second case (from excel), there are empty cells in places like E1,F1,D2,E2,F2,... and according to the schema those cells shouldn't have been generated in the first place (in the XLS format there's a special type of cell for the cells that haven't been specified). In this case, I forced it to emit undefined (and updated sheet_to_row_object_array to ignore undefined elements)

from sheetjs.

redchair123 avatar redchair123 commented on May 4, 2024

@nathanathan thanks a lot and keep the issues coming :) Also, can you tell me what version of excel you used for the second file?

from sheetjs.

nathanathan avatar nathanathan commented on May 4, 2024

Thanks!
The excel version I was using: 14.0.6129.5000 (32-bit)

from sheetjs.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.