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?
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.
Thanks a lot.
APIMate is great. :)