IDtExcelProvider.Query

Syntax

Query: String;

Description

The Query property determines Excel sheets query. Imported data is selected by means of the query.

Comments

As a value of the property the following values can be selected:

• SQL query to be used to select data. Example: Select * From [Sheet1$].

• Sheet names. Example: Sheet1.

NOTE. The sheet name must not contain the characters "[","]" and "*".

Example

The property use is given in the example for IDtExcelProvider.File.

See also:

IDtExcelProvider

Copy page URL

Back to top

To report a found bug, please, select the text with the bug and click Report a Bug or CTRL+ENTER.

Help system 10.7 of 05/02/2025, © FORESIGHT