While I hit an issue with excel and had to take the risk to switch the language.
The current code sample only supports VBScript and JScript (https://support.smartbear.com/viewarticle/24734/), while using the JScript snippet in JavaScript (TestComplete 12), it reports "book.Sheets() is not a function".
Have to close my project, open and update my project mds file, then reload the project again.
Changed from
<config language="{90F89436-9452-4F95-9882-6B5210079F13}" />
to
<config language="{E42909F2-4390-4F5D-94B8-FABF59BABFCE}" />
Now it seems to be fine, I can read/write excel now. I would not suggest you to do this unless you want to take the unknown risk, JavaScript to JScript is probably has the lowest risk, I guess?
I just realized there is a more details response above, please discard this.
