Applescripting - open a document, and copy table to another document

There is no direct AppleScript command to copy or paste tables. But you can use "gui-scripting" to accomplish the task, with something like this:

tell application "Numbers"
	-- open first document and copy table to clipboard
	set f to choose file with prompt "Choose a file" of type {"Numbers"}
	open f
	set t to table 1 of sheet 1 of front document -- selects the table
	tell application "Numbers" to activate
	delay 0.4
	tell application "System Events" to keystroke "c" using {command down}
	
	-- open second document and paste table from clipboard
	set f to choose file with prompt "Choose a file" of type {"Numbers"}
	open f
	tell application "Numbers" to activate
	delay 0.4
	tell application "System Events" to keystroke "v" using {command down}
end tell

SG

If a document is already open then you can address it by name, .e.g. if it is named MyDoc you would use:

set t to table 1 of sheet 1 of document "MyDoc.numbers"

Note that you need to include the file extension in the name

SG

This seems to be more reliable when opening the two documents with the script.

tell application "Numbers"
	-- open first document and copy table to clipboard
	set f to choose file with prompt "Choose a file" of type {"Numbers"}
	open f
	set t to table 1 of sheet 1 of front document
	-- select all the cells in the table
	tell t to set its selection range to range (name of its cell range)
	activate -- return focus to Numbers before copying
	delay 2
	tell application "System Events" to keystroke "c" using {command down}
	
	-- open second document and paste table from clipboard
	set f to choose file with prompt "Choose a file" of type {"Numbers"}
	open f
	activate -- return focus to Numbers before pasting
	delay 2
	tell application "System Events" to keystroke "v" using {command down}
end tell

SG