void XYpopulate()
{
	// get the active worksheet
	Worksheet wks = Project.ActiveLayer();
	if(!wks)
		return;
	
	// suppose x, y, and z columns are column 1, 2, 3 respectively
	Dataset dsX, dsY, dsZ;
	dsX.Attach(wks, 0);
	dsY.Attach(wks, 1);
	dsZ.Attach(wks, 2);
	dsX.SetSize(41*41);
	dsY.SetSize(41*41);
	dsZ.SetSize(41*41);
	
	// fill x column
	int iSize = 41*41;
	int idx = 0;
	for(idx=0; idx<iSize; idx++)
	{
		if(0==((int)dsZ[idx])%41)
		{
			dsX[idx] = 41;
		}
		else
		{
			dsX[idx] = ((int)dsZ[idx])%41;
		}
	}
	
	// fill y column
	int iY = 1;
	for(idx=0; idx<iSize; idx++)
	{
		dsY[idx] = iY;
		if(idx>0 && dsX[idx]==dsX[idx-1]-40)
		{
			iY++;
			dsY[idx] = iY;
		}
	}
}

quote:

---

Originally posted by Penn

Hi jo,

I am not sure what your requirement is. The z column you mentioned is a known column with values, and then you want to fill values to the columns you said x column and y column, right? The x column should be filled from 1 to 41, and then repeat? How is y column increased slowly? What do you mean the repeating z values, two same values in z column?

Maybe you can represent your requirement with some simple data, and then I can see what resources are needed while programming.

Penn

---

//---begin---
//this function will change the active worksheet's data
int XYpopulate2()
{
	//attach to the active worksheet or create a new one
	Worksheet wks = Project.ActiveLayer();
	if( !wks.IsValid() )
	{
		wks.Create("origin");
		if( !wks.IsValid() )
		{
			out_str("no worksheet");
			return -1;
		}
	}
	
	//set 3 columns to the worksheet
	wks.SetSize(-1, 3, WSS_CLEAR_DATA|WSS_FILL_BLANK);
	
	//first column: you can directly set value to it
	int nRowSize = 20;
	Dataset dsX;
	dsX.Attach(wks, 0);
	dsX.SetSize(nRowSize);
	dsX = 100;   
	
	//second column: you can first set value to a vector and then pass the vector to the column
	Dataset dsY(wks, 1);
	vector vYValues;
	vYValues.Data(1, nRowSize);
	dsY = vYValues;
	
	//third column: you can also set value to the cell of the column one by one 
	Dataset dsZ(wks, 2);
	dsZ.SetSize(nRowSize);
	vector vXValue;
	vXValue = dsX;
	for(int ii = 0; ii < nRowSize; ii++)
	{
		dsZ[ii] = vXValue[ii] - ii;
	}
	
	return 0;
}
//---end---