Good morning everything is fine?
Using the FireDAC Excel component, is it possible to freeze the first row and add filters to the columns?
Thanks.
Solved
FireDAC Excel freeze row and add filter on columns
Best answer by Ethem Q
Hi
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.
This topic has been closed for replies.
Hi
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.
Hello, I am attaching a file that I exported from my system using Excel installed on Windows.
The first row is frozen and we add filters for each column.
If you go inside Excel, the Freeze option is found at:
View -> Freeze Panes -> Freeze Top Row.
Today we can do this on my system, but the client must have Excel installed on Windows, I would like to do this using the CData component if possible.
Hi
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.
Hi
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?
Yes that's right. Thanks.
Hi
I wanted to notify you that with the latest build of the Excel connector you are now able to Freeze and Unfreeze Panes by utilizing the newly implemented FreezePanes stored procedure.
Kindly submit a support ticket or reach out to the support team at [email protected] in order to request an updated version of the CData connector for Excel so that we can further assist you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.