\<bookmark_value\>CreateUnoService function\</bookmark_value\>

CreateUnoService Function

Instantiates a Uno service with the ProcessServiceManager.


oService = CreateUnoService( Uno service name )

For a list of available services, go to: https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star.html


Calling Calc functions in Basic:

    Function MyVlook(item, InRange As Object, FromCol As Integer)
        Dim oService As Object
        oService = createUnoService("com.sun.star.sheet.FunctionAccess")
        REM Always use the function English name
        MyVlook = oService.callFunction("VLOOKUP",Array(item, InRange, FromCol, True))
    End Function


oIntrospection = CreateUnoService( "com.sun.star.beans.Introspection" )

\<bookmark_value\>filepicker;API service\</bookmark_value\>

The following code uses a service to open a file open dialog:

Sub Main
    fName = FileOpenDialog ("Please select a file")
    print "file chosen: "+fName
End Sub
Function FileOpenDialog(title As String) As String
    filepicker = createUnoService("com.sun.star.ui.dialogs.FilePicker")
    filepicker.Title = title
    files = filepicker.getFiles()
End Function

Please support us!