2.2.4.46.90 Worksheet::UpdateOrigin

Description

Updates the underlying Origin worksheet from Excel

Syntax

BOOL UpdateOrigin( )

Parameters

Return

Returns TRUE on success and FALSE on failure - indicating an Origin worksheet

Examples

EX1

// Loop through pages and update any Excel found
int Worksheet_UpdateOrigin_Ex1()
{
    int iCount = 0;
    foreach(WorksheetPage wksPage in Project.WorksheetPages)
    {
        Worksheet wks(wksPage.GetName());
        if( wks )
        {
            bool bOK = wks.UpdateOrigin();
            if(bOK)
                printf("%s is an Excel Worksheet\n", wksPage.GetName());
            else
                printf("%s is an Origin Worksheet or Matrix\n", wksPage.GetName());
            iCount++;
        }
    }
    return iCount;
}

Remark

Updates the underlying Origin worksheet from Excel.

This method is the equivalent of the combined Layer -s; and set %H -ui; LabTalk commands.

See Also

Header to Include

origin.h