Check Excel for Filter

[Former Member]

Hi All,

Does anybody know how to check if a filter is applied to an excel sheet when reading the data into SAP?

I'm asking because I've read a program to read a large amount of data from Excel to SAP, but I need to be sure al the data is being read instead of only the data shown in the sheet because of a filter.

I'm using a variant of Function Module ALSM_EXCEL_TO_INTERNAL_TABLE to read the data.

Thanks in advance,

Arthur

[Former Member]

Hi All,

Does anybody know how to check if a filter is applied to an excel sheet when reading the data into SAP?

I'm asking because I've read a program to read a large amount of data from Excel to SAP, but I need to be sure al the data is being read instead of only the data shown in the sheet because of a filter.

I'm using a variant of Function Module ALSM_EXCEL_TO_INTERNAL_TABLE to read the data.

Thanks in advance,

Arthur

[arindam_m]

Hi,

I don't think there is any kind of return code designed to say its filtered but most probably you will end up with junk values in table that has the contents of the file after reading it. That should be a good enough indication

Cheers,

Arindam

[Former Member]

Hi,

Thanks for the answer, but unfortunately you don't get any junk data, you just get the filtered data.

But instead of a return code, does somebody know if there is a way to clear the filter that can be used?

I know there is a way the hide colums or rows when you're creating an excel file from SAP, maybe somebody knows of simular code for applying or removing a filter.

Arthur

[arindam_m]

Hi,

I just tried and got some junk data so told you so. I was using the class CL_GUI_FRONTEND_SERVICES may be some issue with my file.

Cheers,

Arindam