There is no option to tell Origin to use the first row of data as column name - whether from the Clipboard or in any worksheet.
The following script is adapted from my AddOn Tools at http://www.originlab.com/www/downloads/addon_modules/index.cfm :
loop(jj,1,wks.ncols) { // Loop through all columns
wks.col$(jj).name$=%(%H,jj,1); // Column names from row 1
}
mark -d %(%H,1) -b 1 -e 1; // Delete the first row
Note that there are internal routines that check to make sure names are valid. Invalid characters will be stripped from candidate names. If a name conflicts with an existing name, then it will not be used. For this reason, you may want to remove the line that deletes the first row.
Edited by - greg on 10/15/2002 1:48:18 PM
Copying Excel Data
Posted - 10/14/2002 : 08:27:51 AM
