How to copy TextTable from one doc to another with Basic

[Fortunato1]

I’m using LibreOffice 24.2.6.2 (X86_64) on Ubuntu 22.04.5 LTS

I’d like to copy a table from one doc to another but this approach isn’t working. It errors on the last line.

	strPath = ConvertToUrl("/home/wrg/Documents/projects/MT script test doc5.odt")
	oPTGuideDoc = StarDesktop.loadComponentFromURL(strPath, "_default", 0, args())
		
	tables = oPTGuideDoc.TextTables
	oBlankSkillTable = tables.getByName("BlankSkillTable")
	
	' Create new doc
	oNewDoc = StarDesktop.loadComponentFromURL("private:factory/swriter","_default", 0, args())
	'Goto the end of the doc
	oInsertPoint = oNewDoc.Text.getEnd()
	'Add table from the first doc to this new doc
	oInsertPoint.getText().insertTextContent(oInsertPoint, oBlankSkillTable, False)

How can I do that?

Also, can I add the same table twice and merge the two? It may make more sense looking at the table so it’s attached here.
MT script test doc5.odt (27.7 KB)

[JohnSUN]

Again? Once more?

Issue with Copying Table from One LibreOffice Writer Document to Another Using Macro

…it can be used like this: Sub CopyTableFromFileToCurrentDocument() Dim sSourceFilePath As String ' File path for the source document Dim sTableName As String ' The name of the table to copy Dim oSourceDoc As Object ' The source document Dim oTable As Object ' The table to copy Dim oTargetDoc As Object ' The currently open target document Dim oFrame1 As Object ' Frame of the source document Dim oCursor As Object ' Cursor for the target document ' Get the target …

[Fortunato1]

Ok, getTransferable() and insertTransferable() how about the merge table part, any idea there?

[JohnSUN]

Why not record this action using a macro recorder?

...
    ' Paste the copied table
	oTargetDoc.getCurrentController().insertTransferable(oFrame1.Controller.getTransferable())
	oTargetDoc.getCurrentController().insertTransferable(oFrame1.Controller.getTransferable())
    ' Close the source document without saving changes
    oSourceDoc.close(False)
	' Join last two tables
    oCursor = oTargetDoc.getCurrentController().getViewCursor()
    oCursor.goUp(1, True)
    oCursor.goRight(1, False)
    oCursor.goLeft(1, False)
    With createUnoService("com.sun.star.frame.DispatchHelper")
	    .executeDispatch(oTargetDoc.getCurrentController().getFrame(), ".uno:Delete", "", 0, Array())
		.executeDispatch(oTargetDoc.getCurrentController().getFrame(), ".uno:MergeTable", "", 0, Array())
    End With 
 ...