# 格式規格項目 各個格式規格項目都會定義表格檔案的特定屬性： fspec-item ::= [ ansi | oem | mac | UTF-8 | Unicode | txt | fix | dif | biff | ooxml | html | xml | kml | qvd | qvx | parquet | delimiter is char | no eof | embedded labels | explicit labels | no labels | table is [tablename] | header is n | header is line | header is n lines | comment is string | record is n | record is line | record is n lines | no quotes |msq | URL is string | userAgent is string] 使用每個函數中的下拉式功能表，以查看每個函數的簡要描述及語法。按一下語法描述中的函數名稱，以取得進一步詳細資料。 [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### 字元集 字元集是 LOAD 陳述式的檔案規範，可定義檔案中使用的字元集。 ansi | oem | mac | UTF-8 | Unicode | codepage is | [字元集](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/character-set.htm) [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### 表格格式 表格格式是 LOAD 陳述式的檔案規格，可定義檔案類型。若未指定任何項目，將採用 .txt 檔案。 txt | fix | dif | biff | ooxml | html | xml | qvd | qvx | parquet | [表格格式](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/table-format.htm) [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### 分格符號是 若是分隔的表格檔案，可透過 delimiter is 規範來指定任意的分隔符號。此規範只與分隔的 .txt 檔有關。 [**delimiter**](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/delimiter.htm) char [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### 表格是 對於 XML、Excel 或巢狀 Parquet 檔案，「表格是」指定要從檔案載入的表格。 [**table-is**](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/table-is.htm) char [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### Header is 指定表格檔案的標頭大小。可以透過 header is 規範指定任意的標頭長度。標頭是 Qlik Sense 不使用的文字區段。 [**header-is**](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/header-is.htm) n Header is line Header is n lines [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### Comment is 如果您的來源資料檔中有些行是帶有註解的，則可以使用 Comment is 定義註解的前置詞。將 commentprefix 設為註解行的開頭字元或字串，在您載入資料時將忽略這些行。 Comment is commentprefix [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### labels Labels 是 LOAD 陳述式的檔案規範，會定義可以在檔案的什麼位置找到檔案名稱。 [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm)embedded [**labels**](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/labels.htm) |[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) explicit labels|[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm)no labels [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### no eof no eof 規範用來在載入分隔的 .txt 檔案時忽略檔案結尾的字元。 [**no-eof**](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/no-eof.htm) [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### quotes Quotes 是 LOAD 陳述式的檔案規範，可定義是否可使用引號，以及引號與分隔符號的優先順序。僅適用於文字檔。 [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm)[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm)no [**quotes**](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/quotes.htm) [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm)[](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm)msq [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### Record is 若是固定記錄長度檔案，必須透過 record is 規範指定記錄長度。 [**record-is**](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/record-is.htm) n Record is line Record is n lines [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### XML 載入 xml 檔案時使用此指令碼規範。XML 規範的有效選項在語法中列出。 xmlsimple [XML](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/XML.htm) [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### KML 載入 KML 檔案以在地圖視覺化中使用時使用此指令碼規範。 [**KML**](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/KML.htm) [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### URL is 此指令碼規範用來在載入 Web 檔案時，設定 Web 檔案資料連線的 URL。 [**url**](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/url.htm) is [](https://help.qlik.com/en-US/sense/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/format-specification-items.htm) #### userAgent is 此指令碼規範用來在載入 Web 檔案時設定瀏覽器使用者代理程式。 [**userAgent**](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifiers/userAgent.htm) is ## 瞭解更多資訊 * [Load](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Load.htm) * [Select](https://help.qlik.com/zh-TW/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Select.htm)