tmssoftware.com
TMS Support Center
Excel Filter
FLX
TMS FlexCel for VCL & FMX
Markus_Donath
(Markus Donath)
April 12, 2019, 10:37am
1
When creating a new Excel file I would like to add a filter in the first row. The filter should not be active but visible.
Is this possible by TExcelFile?
adrian
(adrian)
April 12, 2019, 12:07pm
2
Hi,
Yes, you can do it with
http://www.tmssoftware.biz/flexcel/doc/vcl/api/FlexCel.XlsAdapter/TXlsFile/SetAutoFilter.html
But remember that for questions of the kind "how do I?" APIMate is your friend. Just create a file in Excel, add an autofilter, save it and open it in APIMate. It will tell you the code you need to create the same autofilter in FlexCel.
Markus_Donath
(Markus Donath)
April 12, 2019, 2:23pm
3
Thanks a lot.
APIMate is great. :)
© tmssoftware.com