最北端で暮らすSEのknowhow

人生の最終目標は気ままな老後生活

LibreOfficeのVBで配列を便利に操作する


GlobalScope.BasicLibraries.LoadLibrary("ScriptForge")
Dim service As Object
service = CreateScriptService("Array")
Dim arr As Variant
arr = Array()
arr = service.Append(arr, 123)
arr = service.Append(arr, 456)
Print(service.Contains(arr, 123))
For index = 0 To Ubound(arr)
    Print(arr(index))
Next index