语法错误：非关键字xlwings

Question

尝试运行以下代码时：

import xlwings as xw
from xlwings.constants import SortOrder
from xlwings.constants import SortOrientation

def xlwingstest():
    wb = xw.Book.caller()
    wb.app.screen_updating = 'False'

    xw.Range('A3:B8501').api.Sort(Key1=wb.Sheets('Sheet1').xw.Range('A3'), SortOrder.xlDescending, 
             SortOrientation.xlSortColumns)

我得到以下错误：

Traceback (most recent call last):

File "", line 1, in

File "xlwings_sort_data1.py", line 16

xw.Range('A3:B8501').api.Sort(Key1=wb.Sheets('Sheet1').xw.Range('A3'),
                               SortOrder.xlDescending, 

SyntaxError: non-keyword arg after keyword arg

我使用的是python2.7。你知道吗

Answer 1

不能将关键字arg（例如Key1=）放在非关键字arg之前。从excel documentation，您可以找到Range.Sort方法参数。我想你想做：

xw.Range('A3:B8501').api.Sort(Key1=wb.Sheets('Sheet1').xw.Range('A3'),
 Order1=SortOrder.xlDescending,
 Orientation=SortOrientation.xlSortColumns)