| Author |
 Topic  |
|
|
olsy
29 Posts |
 Posted - 09/15/2011 : 05:24:03 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): 8.5Pro
Operating System:Win7
Hi guys!
I tried to copy a worksheet with this code:
// 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);
}
But it copy only a data without the LongName.
How i can copy everything in the same workbook just in a new worksheet?
|
|
|
greg
USA
1379 Posts |
Posted - 09/15/2011 : 4:42:11 PM
|
// create a copy of The best to calculate statistics
Worksheet wks = Project.ActiveLayer();
WorksheetPage WksPage = wks.GetPage();
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 | CPYT_COPY_COLUMN_LABELS; // want to keep column format and designations with copied data
int nRet = wks.CopyTo(wksDest, nC1, 10, nR1, nR2, nDestC1, -1, dwCtrl);
} |
 |
|
|
a13cbold
USA
1 Posts |
|
|
olsy
29 Posts |
Posted - 09/21/2011 : 10:47:30 AM
|
Thanks greg!!!
works ) |
|
|
| |
Topic |
|
|
|
How to copy a page with a LongName?