CreateUnoService Function

แƒ˜แƒœแƒ˜แƒชแƒ˜แƒแƒšแƒ˜แƒ–แƒแƒชแƒ˜แƒแƒก แƒฃแƒ™แƒ”แƒ—แƒ”แƒ‘แƒก Uno แƒกแƒ”แƒ แƒ•แƒ˜แƒ–แƒก ProcessServiceManager-แƒ˜แƒ—.

Syntax:

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

Example:

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

Example:

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

แƒจแƒ”แƒ›แƒ“แƒ”แƒ’แƒ˜ แƒ™แƒแƒ“แƒ˜ แƒ“แƒ˜แƒแƒšแƒแƒ’แƒฃแƒ แƒ˜ แƒคแƒแƒœแƒฏแƒ แƒ˜แƒก แƒ’แƒแƒกแƒแƒฎแƒกแƒœแƒ”แƒšแƒแƒ“ แƒ˜แƒงแƒ”แƒœแƒ”แƒ‘แƒก แƒกแƒ”แƒ แƒ•แƒ˜แƒ–แƒก.


Sub Main
    fName = FileOpenDialog ("แƒ’แƒ—แƒฎแƒแƒ•แƒ— แƒแƒ˜แƒ แƒฉแƒ˜แƒแƒ— แƒคแƒแƒ˜แƒšแƒ˜")
    print "file chosen: "+fName
End Sub
 
Function FileOpenDialog(title As String) As String
    filepicker = createUnoService("com.sun.star.ui.dialogs.FilePicker")
    filepicker.Title = title
    filepicker.execute()
    files = filepicker.getFiles()
    FileOpenDialog=files(0)
End Function

Please support us!