TableToXML (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | Français

Help

WLanguage

WLanguage functions

Controls, pages and windows

Binary Memo column (image)

Constants for managing Table, Treeview Table, Looper and List Box controls

FileToMemoryTable

Functions for managing Table controls

TableAddLineWithAnimation

TableCellSelectOccurrence

TableCollapseExpand

TableColumnSelect

TableColumnSelectOccurrence

TableDeleteWithAnimation

TableFormulaDeleteAll

TableInsertLineWithAnimation

TableRestorePositionAndSelection

TableSave

TableSavePositionAndSelection

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.

Versions 15 and later

This function is now available for PHP sites.

New in version 15

This function is now available for PHP sites.

This function is now available for PHP sites.

Versions 18 and later

This function can now be used to handle the TreeView Table controls in the WEBDEV and PHP sites.

New in version 18

This function can now be used to handle the TreeView Table controls in the WEBDEV and PHP sites.

This function can now be used to handle the TreeView Table controls in the WEBDEV and PHP sites.

Versions 20 and later

This function is now available for WINDEV applications in Linux.

New in version 20

This function is now available for WINDEV applications in Linux.

Versions 23 and later

This function is now available for WEBDEV sites in Linux.

New in version 23

This function is now available for WEBDEV sites in Linux.

Example

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 XML file> [, <Options> [, <Start row> [, <End row>]]])

<Result>: Boolean

True if the file was created,
False otherwise.

<Table control>: Control name

Name of control to use. This control can correspond to:
a Table control.
a TreeView Table control.

<Name of XML file>: Character string (with quotes)

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

<Options>: Optional Integer constant

Configures the XML file to create.
taWithInvisibleColumns Also exports the invisible control columns.
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.
taSelectedLines Exports the selected rows only (all the rows are exported by default).
taNoTitle Only the data is copied into the file.
taNoTotal Does not export:
the rows containing totals, mean and automatic count (these rows are exported by default).
This constant is not available.
taNoXSL The style sheet (".XSL" file) is not created.
taColumnsTitles
(default value) The title of columns is inserted into the file.

<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 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 control.

Remarks

Use conditions

TableToXML can be used on:

a browsing or memory control.
a single-selection or multiselection control.

Binary Memo column (image)

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

Limit

The merged columns are ignored.

Component : wd250std.dll