問題描述
使用查詢和過濾但“無列:Col15”錯誤 (Use Query and filter But "No Column: Col15" error)
我有一個包含 20 列的主數據。我使用 query()
來提取數據,但它說:沒有列:Col15 錯誤
=QUERY({IMPORTRANGE("15EKBUMLhbpHL‑bzOTEF2mtYVbuC4sHWtZrPJqynedJ0";"'BANHANGT8.19'!A3:N")};"select Col1, Col2, Col5, Col6, Col7, Col8, Col9, Col10, Col11, Col12, Col14, Col15";0)
我希望 Col15 應該顯示出來:Col15 存儲為純文本,儘管它有數字和文字:331‑hoàng an
參考解法
方法 1:
Probably easily fixed with
=QUERY({IMPORTRANGE("15EKBUMLhbpHL‑bzOTEF2mtYVbuC4sHWtZrPJqynedJ0";"'BANHANGT8.19'!A3:T")};"select Col1, Col2, Col5, Col6, Col7, Col8, Col9, Col10, Col11, Col12, Col14, Col15";0)
to actually import the first 20 columns. Cfr comment in original post.
(by Nguyen Thi Lan Anh、Benoît Wéry)