ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Table functions
  • Use conditions
  • Limitation
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Copies the content of a Table or TreeView Table control to the clipboard. The control content is copied in text format: it is converted into a string and this string is copied to the clipboard.
Example
TableToClipboard(TABLE_TABLE1, taNoTitle, ";")
Syntax
<Result> = TableToClipboard(<Table control> [, <Options> [, <Separator> [, <Start row> [, <End row>]]]])
<Result>: Boolean
  • True if the control content was copied to the clipboard,
  • False otherwise. To get more details on the error, use ErrorInfo.
<Table control>: Control name
Name of the control to be used. This control can correspond to:
  • a Table control.
  • a TreeView Table control.
<Options>: Optional constant (or combination of constants)
Sets the information to be taken into account in the string copied to the clipboard.
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).
taColumnsTitlesThe title of the columns is inserted.
taNoTitle
(default value)
Only the data is copied.
taNoTotalDoes not export:
  • the rows containing totals, mean and automatic count (these rows are exported by default).
  • WINDEV the rows containing custom calculations (these rows are exported by default).
taSelectedLinesExports the selected rows only (all the rows are exported by default).
taWithInvisibleColumnsAlso exports the invisible control columns.
WINDEV The columns defined as non printable and non exportable are exported. These columns are defined:
  • programmatically: VisibleInExportAndPrint property set to False.
  • in the "General" tab of the column description window: "Export and print" set to "Never".
<Separator>: Optional character string
Separator used between the columns. The default separator is the tabulation (TAB).
<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

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

Limitation

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.
Component: wd300std.dll
Minimum version required
  • Version 12
This page is also available for…
Comments
Video TableToClipboard
https://youtu.be/nheOxxmqYL4

https://windevdesenvolvimento.blogspot.com/2019/02/dicas-2017-windev-tabela-93.html


// BTN_COPIAR_AREA_TRANSFERENCIA

// Copia o conteúdo de um controle Table ou TableView Table na área de transferência.
// Copies the content of a Table or TreeView Table control into the clipboard.
// Copie le contenu d'un champ Table ou Table hiérarchique dans le presse-papiers
// Copia el contenido de un control Table o TableView Table en el portapapeles.

TableToClipboard(TABLE_WIN_TABELA_EXEMPLO,taNoTitle,";")
amarildo
15 Feb. 2019

Last update: 06/17/2024

Send a report | Local help