topic Check Excel for Filter in Application Development and Automation Discussions

Check Excel for Filter

Former Member — Mon, 08 Jul 2013 12:30:29 GMT

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

Re: Check Excel for Filter

arindam_m — Tue, 09 Jul 2013 04:49:47 GMT

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

Re: Check Excel for Filter

Former Member — Tue, 09 Jul 2013 05:48:08 GMT

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

Re: Check Excel for Filter

arindam_m — Tue, 09 Jul 2013 06:19:19 GMT

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