Hi I need to convert this: // Convert [[1],[2],[3],[4],["a","b","c"],["d","e","f"]] to this: [1,2,3,4,"a","b","c","d","e","f"] In MS Office Script. I can't use I've tried using things like array.flat(), but it doesn't exist in Office Script.
I want to recalculate an Excel worksheet every 1 second using Office Script. Here is my failed attempt. function sendMessage(sheet: ExcelScript.Worksheet) { console.log('hi'); sheet.calculate(true); } function main(workbook: ExcelScript.Workbook) { let sheet = workbook.getActiveWorksheet(); setInterval(sendMessage, 1000, sheet); } Nothing printed at…
please advice best way to replace formulas with values. I used before: //copy-paste values rEPORT__2_.getRange().copyFrom(rEPORT__2_.getRange(), ExcelScript.RangeCopyType.values, false, false); but it stopped to work starting from today. Excel just get unexpected error if i try to copy-paste more tnan 100 rows…
Is there a code for repetitive merging. Like for example I want to merge A1:B1, then again A2:B2, then A3:B3 and so forth. It goes a long way up to 500th cell A500:B500? I am familiar with this code: function…