FireDAC Excel freeze row and add filter on columns

Hi @andrews_saac 

This is an unusual request and I am not sure I understand what you mean when you say “to freeze the first row and add filters to the columns”. Would you be able to provide more context on the functionality that you are envisioning? How exactly would you intend to add filters to the columns of the first row? If we can have a better picture of what you are trying to accomplish, I can check with the engineering team and see if this is something feasible.

Hi @andrews_saac,  

From what I gather here, you are requesting a way to Freeze the top row directly from the driver so that in cases when someone does not have Excel installed on their machine, they can still manage to run this command via the CData driver for Excel, is that right?

I think one way to support this functionality could be via a stored procedure but I will need to check with the team to see if this is feasible first. That said, I will go ahead and open this as a request with our development team. I will keep you updated when there is any progress on this ask.