XLSXWriter and Excel “=SORT()” Function?

user_364966 0
Viewed 524

I learned in this SO post about using XLSXWriter to add a =FILTER() function to a workbook.

Now I'm trying to add a =SORT() function. So far I have tried this:

worksheet.write_array_formula('H2', '=_xlfn._xlws.SORT(A2:F16, 6, -1)')

...but SORT doesn't appear to be an array formula. I have also tried this:

worksheet.write_formula('H2', '=_xlfn.SORT(A2:F16, 6, -1)')

worksheet.write_formula('H2', '=_xlfn._xlws.SORT(A2:F16, 6, -1)')

The formula appears in the worksheet, but instead of being:

=SORT(A2:F16, 6, -1)

...it appears as:

=@SORT(A2:F16, 6, -1)

How can I correct this?

xlsxwriter excel-formula excel
1 Answers

This is similar to the other answer that you linked to and your first attempt is almost correct. I think you just need to specify a range that the range formula applies to like this:

import xlsxwriter

workbook = xlsxwriter.Workbook('test.xlsx')
worksheet = workbook.add_worksheet()

worksheet.write_array_formula('H2:M16', 
                              '=_xlfn._xlws.SORT(A2:F16, 6, -1)')

workbook.close()

Output:

enter image description here

user_102380
Related