TableToXML (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage functions / Controls, pages and windows / Table functions

Use conditions
Binary Memo column (image)
Limit

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

TableToXML (Function)

In french: TableVersXML

Creates an XML file from the data found in a Table or TreeView Table control.

Remarks:

By default, a style sheet (".XSL" file) is automatically generated when creating the XML file.
The document entity of generated XML file is named WINDEV_TABLE.

Example

sFile is string
// File name
sFile = fSelect("", "", "Choose the export file", ...
	"XML files (*.XML) *.xml", "xml", fselCreate + fselExist)
// The export is canceled if no name was specified
// Otherwise, export the content of TABLE_TABLE1
IF sFile <> "" THEN TableToXML(TABLE_TABLE1, sFile, taNoTitle)

sFile is string
// File name
sFile = CompleteDir(fExeDir()) + "MyXML" + ConnectionCount() + ".xml"
// The export is canceled if no name was specified
// Otherwise, export the content of TABLE_TABLE1
IF sFile <> "" THEN TableToXML(TABLE_TABLE1, sFile, taNoTitle)

Syntax

<Result> = TableToXML(<Table control> , <Name of the XML file> [, <Options> [, <Start row> [, <End row>]]])

<Result>: Boolean

True if the file was created,
False otherwise.

<Table control>: Control name

Name of the control to be used. This field may correspond to:
a Table control.
a TreeView Table control.

<Name of the XML file>: Character strings

Name and full path of XML file to create. The file is replaced with the new file if it already exists.

<Options>: Optional Integer constant

Configures the XML file to create.
taColumnDisplayedOrder Exports the columns according to the order of columns currently displayed in the control (and not according to the order of columns defined in the editor).
This constant is not available.
taColumnsTitles
(default value) The title of the columns is inserted in the file.
taNoTitle Only the data is copied to the file.
taNoTotal Does not export:
the rows containing totals, mean and automatic count (these rows are exported by default).
the rows containing custom calculations (these rows are exported by default).
This constant is not available.
taNoXSL The style sheet (file ".XSL") is not created.
taSelectedLines Exports the selected rows only (all the rows are exported by default).
taWithInvisibleColumns Also exports the invisible control columns.
The columns defined as non printable and non exportable are exported. These columns are defined:
or by programming: property VisibleInExportAndPrint to Faux.
either in the "General" tab of the column description window: option "Export and print" to "Never".

<Start row>: Optional integer

Number of the row where the export will start.
If this parameter is not specified, the start row is the first row of the control.

<End row>: Optional integer

Number of the row where the export will end.
If this parameter is not specified, the end row is the last row of the control.

Remarks

Use conditions

TableToXML can be used on:

Table or TreeView Table controls based on a data file.
Table or TreeView Table controls populated programmatically.
single-selection or multi-selection controls.

Binary Memo column (image)

For the Binary Memo columns, the XML file contains an empty string.

Limit

The merged columns are ignored.

Component: wd300std.dll