|
|
|
|
|
|
|
|
|
|
TableToClipboard (Function) In french: TableVersPressePapier 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.
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. | | | 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). | | taColumnsTitles | The title of the columns is inserted. | taNoTitle
(default value) | Only the data is copied. | | 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).
| | taSelectedLines | Exports the selected rows only (all the rows are exported by default). | | taWithInvisibleColumns | Also exports the invisible control columns.
|
<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:
|
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.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|