How to sort a Numbers table using Javascript for Automation

Question

I want to sort a Numbers table using Javascript for Automation, the code like

table.sort(table.columns["P"], {direction: "descending"})

But the Script Editor told me: Parameter is missing. (-1701)

Here is the code I wrote:

 var Numbers = Application("Numbers")
 var path = Path("/Volumes/sfufoet/test.numbers")

 var doc = Numbers.open(path)

 var sheet = doc.sheets[1]
 var table = sheet.tables[1]

 table.sort(table.columns["P"], {direction: "descending"})

Thanks!

sfufoet · Accepted Answer · 2015-08-27 21:06:02Z

1

I found it!

the right code is:

table.sort({by:table.columns["P"], direction: "descending"})

answered Aug 27, 2015 at 21:06

sfufoet

1,1111 gold badge6 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to sort a Numbers table using Javascript for Automation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related