| Author |
 Topic  |
|
|
olsy
29 Posts |
 Posted - 09/15/2011 : 05:14:06 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): 8.5
Operating System:Win7
Hi guys!
i have a problem to create a copy of worksheet.
It copies only a data and not a LongName of the columns.
// create a copy of The best to calculate statistics
Worksheet wks = Project.ActiveLayer();
int newWks = WksPage.AddLayer( "Statistics" );
Worksheet WksRes = WksPage.Layers( newWks );
if(wks)
{
Worksheet wksDest=WksPage.Layers( newWks );
int nC1 = 0, nC2 = wks.GetNumCols()-1; //want to copy all columns
int nR1 = 0, nR2 = -1; // want to copy rows 10-230
int nDestC1 = 0; // copy data to destination worksheet start from the first column
DWORD dwCtrl = CPYT_COPY_COLUMN_FORMAT | CPYT_COPY_COLUMN_DESIGNATIONS; // want to keep column format and designations with copied data
int nRet = wks.CopyTo(wksDest, nC1, 10, nR1, nR2, nDestC1, -1, dwCtrl);
}
How i can copy also a LongName? |
|
|
LabTalk user
USA
35 Posts |
Posted - 09/15/2011 : 5:58:50 PM
|
Hello olsy,
Look into using the colcopy x-function. I use it within loop structures to copy ranges of data between worksheets and it has a wide variety of options to suit all of my needs.
Hopefully it can address your issue.
Patrick |
 |
|
| |
Topic |
|
|
|
How to add a LongName