PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Use conditions
  • Limit
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Creates a character string from the data found in a Table or TreeView Table control. This string can be saved in a specific format thereafter.
Versions 15 and later
PHP This function is now available for the PHP sites.
New in version 15
PHP This function is now available for the PHP sites.
PHP This function is now available for the PHP sites.
Example
sText is string
sText = TableToText(TABLE_TABLE1, taNoTitle, ";")
fSaveText("Export.csv", sText)
Syntax
<Result> = TableToText(<Table Control> [, <Options> [, <Column Separator> [, <Row Separator> [, <Start Row> [, <End Row>]]]]])
<Result>: Character string
  • Character string containing the table data. In this string, the columns are separated by <Separator> and the rows are separated by CR characters (Carriage Return).
  • Empty string ("") if an error occurred or if the table is empty.
<Table Control>: Control name
Name of control to use. This control can correspond to:
  • a Table control.
  • a TreeView Table control.
<Options>: Optional constant
Configures the information that must be taken into account in the string.
taWithInvisibleColumnsAlso exports the invisible control columns.
Versions 22 and later
WINDEV The columns defined as non printable and non exportable are exported. These columns are defined:
  • by programming: ..VisibleInExportAndPrint set to False.
  • in the "General" tab of the description window of columns: "Export and print" to "Never".
New in version 22
WINDEV The columns defined as non printable and non exportable are exported. These columns are defined:
  • by programming: ..VisibleInExportAndPrint set to False.
  • in the "General" tab of the description window of columns: "Export and print" to "Never".
WINDEV The columns defined as non printable and non exportable are exported. These columns are defined:
  • by programming: ..VisibleInExportAndPrint set to False.
  • in the "General" tab of the description window of columns: "Export and print" to "Never".
taColumnDisplayedOrderExports 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).
WEBDEV - Server code This constant is not available.
taSelectedLinesExports the selected rows only (all the rows are exported by default).
taNoTitleOnly the data is copied.
taNoTotalDoes not export:
  • the rows containing totals, mean and automatic count (these rows are exported by default).
  • Versions 22 and later
    WINDEV the rows containing custom calculations (these rows are exported by default).
    New in version 22
    WINDEV the rows containing custom calculations (these rows are exported by default).
    WINDEV the rows containing custom calculations (these rows are exported by default).
WEBDEV - Server code This constant is not available.
taColumnsTitles
(Default value)
The title of the columns is inserted.
<Column Separator>: Optional character string (with quotes)
Separator used between the columns. The default separator is the tabulation (TAB).
<Row Separator>: Optional character string (with quotes)
Separator used between the rows. The separator used by default is the CR character (Carriage Return).
<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

TableToText can be used on:
  • a browsing or memory control.
  • a single-selection or multi-selection control.

Limit

The merged columns are ignored.
Related Examples:
The TableTo functions Unit examples (WINDEV): The TableTo functions
[ + ] Exporting table data with the WLanguage functions.
The following topics are presented in this example:
1/ interfacing with Word and Excel
2/ sending data to the clipboard
3/ generating a text file
This example explains how to export the content of a table to a Word document, an Excel workbook, the clipboard or a text file via the following WLanguage functions: TableToWord, TableToExcel, ToClipboard, TableToText.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230std.dll
Windows Mobile wp230std.dll
Linux wd230std.so
Minimum required version
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment