abap2xlsx -> bind_table without filters

[Former Member]

Hello everyone,

i use the Class zcl_excel_worksheet with the Method bind_table.

The problem is that the excel file is created with filters in the Header line. But i need a excel_file without any filters.

The only way it seems to work is, thatyou set each cell with the method -> set_cell  manual.
Is there any other solution ????

Thanks

bye

[_IvanFemia_ · Accepted solution]

Johannes,

Which version are you using?

In the newest version is it possible to remove the filter using the table settings

ls_table_settings-nofilters         = abap_true.

Please check ZDEMO_EXCEL3 for more details.

Regards,

Ivan

[Former Member · Accepted solution]

Hello Ivan,

thanks for your help and sorry for cross posting, i first posted there and than saw that you should post question into the forum.

However, right now i can't see the Version but i want to share my solution :

If i remember correct the Version is from the year 2010 ... or s.t. like that.

So if you have a itab and want to create a xslx. file with filter use the Methode :

bind_table

if you want no autofilter set use the Method

set_table

regards,

Johannes

[_IvanFemia_ · Accepted solution]

Johannes,

set_table should not be used any longer, because it is deprecated.

I would suggest to use the table settings as suggested in my previous post.
(ZDEMO_EXCEL3)

Ivan

[Former Member · Accepted solution]

If we ever get a newer version, i willl keep that in mind

thank you

[_IvanFemia_ · Accepted solution]

I strongly suggest to update to the newer version.

You'll get new features, improvements in performances and more. Code is backward compatible, so no change to the existing reports.

Ivan

[Former Member · Accepted solution]

well it is not my decision to make 🙂

but i agree with you

johannes