You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
So to be clear, this library reads whatever data is stored in the file. It doesn't attempt to perform Excel calculations (we actually have a paid component to handle calculating formula expressions, but that's not the thrust of the issue here).
For example, "Cambodia" is cell B2. The raw xml stored in the file (after prettifying with xmllint --format) for row 2 is:
Cell B2 is very clearly stored with the #VALUE! error, and t="e" notes that the cell is an error cell.
Note: By default, XLSX uses a shared string table, and the "4" in cell A2 is the string at index 4 from the table (which happens to be "Activity One").
C2 is of course the literal number 2017
There may be a way to grab the name "Cambodia" from the value metadata, so we'll keep the issue open, but for now it's behaving as expected.
I'm trying to read a Geography Cell and I'm having trouble getting the value.
When I parse the excel to json, the cell is returned as
{t: "e", v: 15, w: "#VALUE!"}
.How can I get the country from these linked data type cells?
The text was updated successfully, but these errors were encountered: