使用applescript在Excel中选择多列

Question

我试着教自己AppleScript关于我真正需要AppleScript的东西。

(我知道一定有一些重复的捷径，但我找不到一个很好的教程来教我怎么做，所以我做了很长的路。)

我被困在如何一次选择多个列(或多个行)上。我想选择填充的列并对它们进行排序，但是我做不到，因为我不知道如何选择多个列。如有任何指导，将不胜感激。

我想让剧本做的是：

• 打开Excel文件
• 删除第1-32行
• 删除第4-7栏
• 删除新的第7栏
• 选择列1-5
• 对列1-5进行排序，首先按任务排序，其次按样本排序
• 删除包含ENDO的行
• 保存文件

以下是我到目前为止所拥有的：

tell application "Microsoft Excel"
activate
open (choose file)
end tell

tell application "Microsoft Excel"
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete row 1
    delete column 4
    delete column 4
    delete column 4
    delete column 4
    delete column 7
    select row 1
    select row 2
end tell

Answer 1

这应该会让你开始：Excel 2004 AppleScript参考

tell application "Microsoft Excel"
    tell active sheet of active workbook
        set myRows to range "1:27"
        delete myRows
        set myColumn to range "D:G"
        delete myColumn
    end tell
end tell