There has been a problem for a long time, please help to see if you can solve, is the data is copied to the clipboard data window, that is to say, I don't have to export the generated excel, I just want to copy to clipboard, the paste into a text file, paste to excel, have been using
Saveas (" ", the clipboard! , the statement is false) to copy, but found that this method can't replicate computed columns, found following
V=now adws. Object. DataWindow. Selected. Data
The Clipboard (v)
This way, don't know how to implement all the text data window, please advice, thank you!
CodePudding user response:
The DescriptionA list of selected controls within the DataWindow.
Controls,
DataWindows
Syntax
The original concept dot notation:
Dw_control. Object. The DataWindow. Selected
Go in and Modify argument:
"DataWindow. Selected='list'"
The Parameter Description
List A list of the controls you want to select. In the list you designate A group of controls by specifying A range of row Numbers and A range of controls In the format: while the startrow/endrow/startcontrol/endcontrolTo specify more than one group, separate each group with A semicolon: startrow1/endrow1/startobj1/endobj1; Startrow2/endrow2/startobj2/endobj2; . Do not include Spaces in the string. You must use column names, not the column Numbers.
Example:
Setting=dw1. Object. The DataWindow. Selected
Dw1. Object. The DataWindow. Selected=& amp;
"1/10/emp_id/emp_name; 12/23/salary/status "
Setting=dw1. The Describe (" DataWindow. Selected ")
Dw1. Modify (" DataWindow. Selected="& amp;
"' 1/10/emp_id/emp_name; 12/23/salary/status' ")
CodePudding user response:
Direct point:Dw1. Modify (" DataWindow. Selected="& amp;
"' 1/10/emp_id/emp_name; 12/23/salary/status' ")
CodePudding user response:
Can say more directlyCodePudding user response:
Dw_1. Modify (" DataWindow. Selected='lines start/end/start column (or columns)/end column (or columns)' ")CodePudding user response:
This is to write all the columns are upCodePudding user response:
Insurance is to be like this, if you can be sure the first column and last column names are simpleAnother method is to use saveasascii save function to TXT and then take the content can also be
CodePudding user response:
This is not very convenient, what better way, no matter how, or thank youCodePudding user response:
Saveas the function, just put the data in the data buffer in accordance with, the datawindow sketchpad, the column specification TAB of the order of export