sheet_to_json, is my file incorrect or sheet_to_json does not work correctly?
Openopened 4 months ago by LuckyOne3 · 6 comments
No Branch/Tag Specified
good first issue
No Assignees2 Participants
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.
No due date set.
No dependencies set.
Reference in New Issue
There is no content yet.
Delete Branch '%!s(<nil>)'
Deleting a branch is permanent. It CANNOT be undone. Continue?
version - "xlsx": "^0.18.5"
language - JS
365, 366, 367,368 - lines at excel are skipped at array of data
this is 364 - line at excel
The attached file is a TSV. There are a few problems viz-a-vis our understanding of delimited files.
First: you should pass the option
XLSX.readFile. The reason is SheetJS assumes en-US semantics. Without a proper
sep=pragma, TSV file separators are guessed by looking at the first KB of data.
Row 363 looks strange:
The problem is the quoting. The start of the run-on cell is
Here, the field starts with a double quote. The parser assumes that the quoting is in effect, and looks for an end quote to end the block. That would be the second pair, after
Воина. It encounters the third and assumes that is part of a quoted string that terminates when the next double quote is found.
If you are generating the TSV files, keep in mind the correct Excel quoting rule is to use two pairs of double quotes. That is to say, the literal string
should be written as
If you can share a screenshot of how that row looks in Excel, then we can go back and revisit quoting rules.
Thank you for answering, on the screen shot is 363 line of excel and how "Союз Святого Иоанна Воина ОООРЦ" is look. I do not generate this files, i just need to parse them, but I was surprised to see such behavior.
As soon as possible i will try this file with XSLX.read option with feed back.
Thanks for sharing! This is surprising for us as well. We'll test some more cases to get a better understanding for how Excel works.
my service is getting file from post query, save file to local folder, and parsing excel, maybe I can give you something more, but I do not know what to send you for this issue, сan you tell me?
I have been tried with new option, but it did not help for concating lines.
line - 363
I want to say - Thank you again, to be honest, I didn’t expect you to answer :)
At this screen shot for column
"Название клиента"- sentence
Союз Святого Иоанна Воина\" ОООРЦparsed ok.
But for the column
"Юр. Название клиента"- sentence
Союз Святого Иоанна Воина ООО- is parsed as
\"Союз Святого Иоанна Воина\" ООО