Hi Zhenyu,

Looks like a bug to me. Import works fine. I would suggest using Import and doing any type / unit conversions on the imported data.

Import["~/Downloads/5.xlsx"]
(*
{{{"采样点编号", "年", "月", "日期", "时间", "\[Degree]C", "mmHg", "DO %", "DO mg/L", "SPC-uS/cm", "C-uS/cm"}}}
*)

Are the values in each column also in 普通话 or 英语?

Zhenyu,

You can Import the spreadsheet as a Dataset

data = Import["ExampleData/elements.xls", {"Dataset", 1}, HeaderLines -> 1]

Then you can add columns, change columns, ... e.g.

data[All,
 <|#,
    "Density" -> Entity["Element", #Name]["Density"],
    "Name" -> ToUpperCase[#Name],
    "Weight / Number" -> #AtomicWeight/#AtomicNumber|> &]