我是AppleScript的新手,不知道如何从上到下遍历数字电子表格列(本例中为"C“列),并根据其现有值更改其值。我已经在网上找过了,但没有成功。
这是我到目前为止所拥有的,但它不起作用。它只会更改单元格C11中的值。
on run {input, parameters}
tell application "Numbers"
activate
tell the first table of the active sheet of document 1
repeat with i from 2 to count of cells of column "c"
if value of cell i is equal to "National League" then
set the value of cell i of column "C" to "2"
end if
end repeat
end tell
end tell
return input
end run发布于 2019-12-03 06:15:47
你遗漏了:of column "C"
您需要更改:
if value of cell i is equal to "National League" then至:
if value of cell i of column "C" is equal to "National League" thenhttps://stackoverflow.com/questions/59147140
复制相似问题