Hello,
I have a XLSX file and I import it to Mathematica.
All things will right if I didn’t add codes:"HeaderLines->1"
If I add HeaderLines->1, there are some Missing.
It is weird as the missing things are the same as those before which had been showed no matter there was code:"HeaderLines->1"
2.xlsx (1.99 MB)
Hi Zhenyu
The Problem here is that the headerline in the xlsx file contains duplicate names.
HCO3-, CO2, CO32- appear two times.
Also the header for column A and B are identical (empty).
Eliminate the duplicates and it will work as expected.
Alternatively you can exactly specify the sheets/columns/rows to import:
(Sheet 1, All rows, columns 3;;7
Import["2.xlsx", {"Dataset", 1, All, 3 ;; 7}, "HeaderLines" -> 1]
Robert
But, before, I once see Impert can contains duplicate names for it will add 2 after the duplicate name.
… a Dataset can not contain identical duplicate headers, that said Import gets into trouble with the duplicates.
Robert