Use of getCount() => ?? about office-scripts-docs

[Geradav]

Actually, I found out what works.
The getCount() property has to first be assigned to a let variable and then we can read the value from that variable.
Weird, but maybe that is how it is supposed to work.

---

let vAllSheetTables = vThisWorksheet.tables;
let vCount = vAllSheetTables.getCount();

await context.sync();

console.log(vCount.value);

---

[AlexJerabek]

Hi @Geradav,

You are correct: you need to sync with the workbook before reading the value of getCount. This is because the script is running on your local machine, without input from the workbook, until you call await context.sync(). That sync call gives values to anything required from a get method or any property referenced with a load. More about this process can be found in the Scripting fundamentals article.

I'll transfer this issue to https://github.com/OfficeDev/office-scripts-docs so we can explicitly call out those get methods as part of the load/sync cycle. I'll also tag @jedunn in reference to #38 which should help with learning this pattern.

Finally, we are working on a version of the Office Scripts API that avoids the load/sync pattern. It'll handle workbook communication for you, so you'll always have access to variables acquired from the workbook. That will become publicly available for Office Scripts are released into general availability. And don't worry, any script you write now will still work when we release the new version.