Skip to main content Skip to complementary content

IFileDataFormat Interface

Namespace: Qlik.Engine
Assembly: Qlik.Engine.dll

FileType

Recognized file formats are:

  • CSV for Delimited
  • FIX for Fixed Record
  • DIF for Data Interchange Format
  • EXCEL_BIFF for Microsoft Excel (XLS)
  • EXCEL_OOXML for Microsoft Excel (XLSX)
  • HTML for HTML
  • QVD for QVD file
  • XML for XML
  • QVX for QVX file
  • JSON for JSON format
  • KML for KML file
  • PARQUET for PARQUET file

Syntax

[ValueClass]
public interface IFileDataFormat

Properties

Name Description
CodePage

Character set used in the file.

JSON property name: qCodePage

Comment

String that marks the beginning of the comment line.

Example: “#” or “ The engine ignores the commented lines during the data load.

This property is only used for delimited files.

JSON property name: qComment

Delimiter

Information about the delimiter.

This property is used for delimited files.

JSON property name: qDelimiter

FixedWidthDelimiters

Positions of the field breaks in the table.

This property is used for fixed record data files.

JSON property name: qFixedWidthDelimiters

HeaderSize

Size of the header.

Example: If the header size is 2, the first two rows in the file are considered as header and not as data. The header can contain the field names.

JSON property name: qHeaderSize

IgnoreEOF

Is set to true, the end-of-file character is not taken into account during reload.

This property is used for delimited files and fixed record data files.

JSON property name: qIgnoreEOF

Label

One of:

* Embedded labels (field names are present in the file)

* No labels

* Explicit labels (for DIFfiles)

JSON property name: qLabel

Quote

One of:

* None (no quotes)

* MSQ (Modern Style Quoting)

* Standard (quotes " " or ' ' can be used, but only if they are the first and last non blank characters of a field value)

This property is used for delimited files.

JSON property name: qQuote

RecordSize

Record length.

Each record (row of data) contains a number of columns with a fixed field size.

This property is used for fixed record data files.

JSON property name: qRecordSize

TabSize

Number of spaces that one tab character represents in the table file.

This property is used for fixed record data files.

JSON property name: qTabSize

Type

Type of the file.

JSON property name: qType

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!