Axolot Data

Posted: **Thu Sep 05, 2013 9:03 am**

in XLSReadWriteII4 I add an autofilter with

XLS.Sheet[0].Autofilters.Add(0, 4, 3, 4);

in Version 5 the method "ADD" does not exist. How can I create an autofilter in XLSReadWriteII5?

In my existing Code, I can Create fixed header rows with to following code:

Code: Select all

    sheet.Pane.SplitColX := 0;
    sheet.Pane.SplitRowY := FHeaderRows;
    sheet.Pane.TopRow    := FHeaderRows;
    sheet.Pane.PaneType  := ptFrozen;
    sheet.Pane.ActivePane := 0;
    sheet.Options := sheet.Options + [soFrozenPanes];

In V5 this does not work. The Option soFrozenPanes does not exist anymore.

Posted: **Mon Oct 07, 2013 2:50 pm**

still not solved...

Posted: **Wed Oct 09, 2013 6:19 am**

Hello

Autofilters is added in update. 5.20.03

In order to create frozen/split panes use FreezePanes/SplitPanes methods: XLS[x].FreezePanes(Col,Row);

Axolot Data

Adding Autofilter & Frozen Panes

Adding Autofilter & Frozen Panes

Re: Adding Autofilter & Frozen Panes

Re: Adding Autofilter & Frozen Panes