Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
olsy
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
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.