collectSheetData
Mitch Stutler avatar
Written by Mitch Stutler
Updated over a week ago

The collectSheetData lets you run a collection on the current sheet. This collection will not update the sheet's actual data, but will let you retrieve cell values from this collection. This is useful for the programatic reading of a current calculation.

// Initialize SheetSearch
var sheet = new x_vivid_sheets.SheetSearch('a6b4ff401bac8a100df574cf034bcb3d');

// Collect most recent data for the sheet
sheet.collectSheetData();

// Read updated values as necessary
var cell = sheet.getCell('B3');

The saveSheetData will outline how you can collect and then save a sheet if desired.

Did this answer your question?