将数据从Excel复制/粘贴到网站表格

Question

我需要帮助更正下面的脚本，以自动执行非常平凡的复制/粘贴任务，我必须在接下来的几周内对列表进行改动。

我通过我们的公司网站报告了WIKI，可让我们加载客户端ID s为该客户端运行报告ID。我有一个1300个客户端的列表，我需要在不同的几周运行此报告，并将这些客户端（当前在Excel工作表中）复制/粘贴到WIKI中以运行这些报告。

当前工作流程： 从Excel复制客户端ID，选择Chrome窗口，然后单击文本框，粘贴，单击选项卡，以便WIKI显示下一个文本框以供我添加客户端ID，返回Excel副本并重复... 1300次...

我发现following site并试图修改他们必须工作的代码，但我认为自那时起词典已经改变。我试图寻找，但一直未能弄清楚。

repeat 2 times 
tell application "/applications/Microsoft Excel.app" to activate 
tell application "System Events" 
    tell process "Microsoft Excel" 
     keystroke "c" using command down 
    end tell 
end tell 
delay 0.3 
tell application "/Applications/Google Chrome.app" to activate 
tell application "System Events" 
    tell process "Google Chrome" 
     keystroke "v" using command down 
     keystroke tab 
    end tell 
end tell 
delay 0.3 

tell application "/applications/Microsoft Excel.app" to activate 
tell application "System Events" 
    tell process "Microsoft Excel" 
     keystroke return 
     delay 0.4 
     keystroke "c" using command down 
     delay 0.3 
    end tell 
end tell 
delay 0.3 
tell application "/applications/Google Chrome.app" to activate 
tell application "System Events" 
    tell process "Google Chrome" 
     keystroke "v" using command down 
     keystroke tab 
    end tell 
end tell 
delay 0.3 
end repeat 

，我每月运行这些报告，并完成所有的工作，让他们在WIKI数据来获得这些客户端正确配置。

Answer 1

的问题是，你使用的目录应用程序时的AppleScript只需要姓名，此处

repeat 2 times 
tell application "Microsoft Excel" to activate 
tell application "System Events" 
    tell process "Microsoft Excel" 
     keystroke "c" using command down 
    end tell 
end tell 
delay 0.3 
tell application "Google Chrome" to activate 
tell application "System Events" 
    tell process "Google Chrome" 
     keystroke "v" using command down 
     keystroke tab 
    end tell 
end tell 
delay 0.3 

tell application "Microsoft Excel" to activate 
tell application "System Events" 
    tell process "Microsoft Excel" 
     keystroke return 
     delay 0.4 
     keystroke "c" using command down 
     delay 0.3 
    end tell 
end tell 
delay 0.3 
tell application "Google Chrome" to activate 
tell application "System Events" 
    tell process "Google Chrome" 
     keystroke "v" using command down 
     keystroke tab 
    end tell 
end tell 
delay 0.3 
end repeat 

希望这有助于！