Applying data filter before saving generate document

[Georges]

Hello,

I've been looking around but did not find my answer in the forum...

Is there a way to apply a data filter to the XLS file while creating the sheet ?

I'm currently developping an application using XlsIO that sends by mail a daily export of my SQL Database ; the point is that, if all of the datas must be in this sheet, some of them should be hidden by using a simple field criteria, because there are hundreds of lines in this table, and 90% of the time, people are just working on these 30 or 40 lines that changed since yesterday.

I've tried applying the filter to the empty excel template, and setting it to the desired value ; but as the sheet is filled, it doesn't seem to work.

Do you have a solution for me ?

Thanks for your help,

Georges.

[Melba Winshia]

Hi Georges,

Your Direct-Trac incident #37485 has been updated which was created with the same issue. Please follow this issue in that incident #37485.

Kindly let me know if you have any other questions.

Thanks,
Melba

[Amal Ibrahim]

Hi,
How can I see the incident#37485.
I have the same issue to filter certain column in Excel.
Thanks
Amal

>Hi Georges,

Your Direct-Trac incident #37485 has been updated which was created with the same issue. Please follow this issue in that incident #37485.

Kindly let me know if you have any other questions.

Thanks,
Melba

[Amal Ibrahim]

Hi,
How can I see the incident#37485.
I have the same issue to filter certain column in Excel.
Thanks
Amal

>Hi Georges,

Your Direct-Trac incident #37485 has been updated which was created with the same issue. Please follow this issue in that incident #37485.

Kindly let me know if you have any other questions.

Thanks,
Melba

[Melba Winshia]

Hi Amal,

To filter columns with certain value\text:

I regret to let you know that currently we do not provide support for this feature in our code library. We have logged a request in our feature management system. We will get back to you once this feature is implemented.

Please let me know if you have any concerns.

Thanks,
Melba