Compare Data in Two Worksheets

 

Version Info

Minimum Origin Version Required: Origin 8 SR0

Example

This example shows how to compare the data in two worksheets if full match.

static void _get_all_data_from_wks(Worksheet& wks, vector& vec)
{
        vec.RemoveAll();
        foreach(Column col in wks.Columns)
        {
                vector& vecCol = col.GetDataObject();
                vec.Append(vecCol);
        }
}

bool compare_worksheet_data(Worksheet& wks1, Worksheet& wks2, double dTolerance = 1e-10)
{
        if( wks1.GetNumRows() != wks2.GetNumRows() || wks1.GetNumCols() != wks2.GetNumCols() )
                return false;
        
        vector vec1, vec2;
        _get_all_data_from_wks(wks1, vec1);
        _get_all_data_from_wks(wks2, vec2);   
        if( vec1.GetSize() != vec2.GetSize() )
                return false;
        
        bool bIsSame;
        int nn = ocmath_compare_data(vec1.GetSize(), vec1, vec2, &bIsSame, dTolerance);
        return bIsSame;
}