下面的以下函数将在Excel工作表的每一列中添加“ 1”。如果我将= vbe(12)放在A1中,它将在“ A1:L1”列中放入“ 1”。如何将该VBA转换为适用于Google表格的JavaScript?
Function vbe(Num As Long) As Variant
Dim ary As Variant
Dim i As Long
ReDim ary(Num - 1)
For i = 0 To Num - 1
ary(i) = 1
Next i
vbe = ary
End Function