in reply to Re: Win32::OLE and Excel Autofilter
in thread Win32::OLE and Excel Autofilter
$sort->{SortFields}->Clear(); $sort->{SortFields}->Add($Sheet->Range("e$filter_row:e$filter_row"), x +lSortOnValues, xlDescending, xlSortNormal); $sort->{Header} = xlYes; $sort->{MatchCase} = xlYes; $sort->{Orientation} = xlTopToBottom; $sort->{SortMethod} = xlPinYin; $sort->Apply;
All is working as planned.
|
|---|