Example

The following example creates a Spread with multiple sheets and resets one sheet.

C++

BOOL CTestSpread7DllDlg::OnInitDialog()
{    CDialog::OnInitDialog();

    // Set sheet count
    spr->SetSheetCount(4);
    // Set active sheet
    spr->SetActiveSheet(2);
    // Set sheet number
    spr->SetSheet(2);
    // Apply text to cell in sheet
    spr->SetData(1, 1, "test");
}

void CTestSpread7DllDlg::OnButton1()
{
    // Reset sheet 2
    spr->ResetSheet(2);
}