#include <Origin.h>

void SumUp_Worksheets()
{


	WorksheetPage  wksPage("[Test]");
		foreach (Layer wks in wksPage.Layers)
		{
			DataRange dr;
			//string strRangeName ="X";
			int r1=0, c1=0, r2=10, c2=1;
			dr.Add("Range1",wksPage, r1, c1, r2, c2);
			matrix myData;
			dr.GetData(myData);
			
			int nRows = wks.GetNumRows();
			vector vSum(nRows);
			int nRet = ocmath_row_desc_stats(nRows, wks, vSum);
		}

}

#include <Origin.h>
void SumUp_Worksheets()
{
	WorksheetPage wksPage("Test");
	if( !wksPage )
		return;
	
	int nwks = wksPage.Layers.Count();
	vector<double> sums( nwks );
	double sum;
	
	Worksheet wks;
	int i;
	for( i = 0; i < nwks; i++ )
	{
		wks = wksPage.Layers( i );
		
		foreach( Column col in wks.Columns )
		{
			vectorbase & vb = col.GetDataObject();
			vb.Sum( sum );
			sums[i] += sum;
		}
		
		printf("Sum of [%s]%s: %g\n", wksPage.GetName(), wks.GetName(), sums[i] );
	}
	
	return;
}

�c��   �ȥ�  �f�u�c  �c��    �Τ�  �c/     ����
 �c�ʥ� ����  �� ��   ���' �̩���   /��  �թ��f
   ��             ��          ����  �` ��   ��
                              ��

void SumUp_Worksheets()
{
	WorksheetPage wksPage("Book1");  // Workbook
	if(!wksPage)
		return;
	foreach(Layer layer in wksPage.Layers)  // All worksheets in workbook
	{
		Worksheet wks(layer);
		DataRange dr;  // Data range to the whole worksheet
		dr.Add(wks, 0, "X", -1);
		matrix mData;
		dr.GetData(mData);  // Get worksheet data into matrix
		int nRows = mData.GetNumRows();  // number of rows
		int nCols = mData.GetNumCols();  // number of columns
		vector vSum(nRows);  // vector to strore sum of rows in each worksheet
		// Sum up each rows in all columns
		int nRet = ocmath_row_desc_stats(nRows, nCols, mData, NULL, NULL, NULL, NULL, NULL, vSum);
		int nn = wks.AddCol();  // Add a column to store these sums
		Column col(wks, nn);
		col.SetLongName("Sum of Rows");
		vectorbase& vv = col.GetDataObject();
		vv = vSum;
		
		// Sum up each columns in worksheet
		for(int ii = 0; ii < nCols; ii++)
		{
			Column colSrc(wks, ii);
			vectorbase& vSrc = colSrc.GetDataObject();
			double dSum;
			vSrc.Sum(dSum);
			nn = wks.AddCol();  // Add a column to hold the sum in the first cell
			wks.Columns(nn).SetLongName("Sum of Column "+colSrc.GetName());
			wks.SetCell(0, nn, dSum);			
		}
		
		// Sum up the whole worksheet
		double dWksSum;
		nn = wks.AddCol();  // Add a column to hold the sum of worksheet in the first cell
		wks.Columns(nn).SetLongName("Sum of All Values in Sheet");
		vv.Sum(dWksSum);
		wks.SetCell(0, nn, dWksSum);
	}
}