UpdateState
The UpdateState() function is an Excel specific Quintessence function that returns a Boolean value indicating whether either the Upload Sheet or Upload Selected button was clicked.
Related functions: UploadData, UploadDataAsync
Syntax:
Qx.UpdateState()- In Excel with Quintessence add-in versions prior to 25.1, use:
UpdateState()
Remarks:
- The returned Boolean reflects whether an upload action was triggered since the last calculation.
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Detecting whether an Upload action was triggered
Suppose a workbook contains an UploadData call.
Place the following formula in any cell (e.g., A1):
=Qx.UpdateState()- Initially,
A1will returnFALSE. - In the Quintessence ribbon in Excel, click Upload Sheet or Upload Selected to execute the upload.
- After the upload operation is triggered,
A1will returnTRUE.