Filter

You can cause GDXXRW to write data subject to an automatic filter specified in Excel.

By filtering in Excel, you can find values quicker and control not only what you want to see, but what you want to exclude. You can filter based on choices you make from a list, or you can create specific filters to focus on exactly the data you want to see. You can also search for text and numbers by using the Search box in the filter interface.

When you filter data in Excel, entire rows are hidden if values in one or more columns don't meet the filtering criteria. You can filter on numeric or text values.

The syntax for this involves adding

    filter=n

where        n=0 is the default condition and uses no filter

 n=1 turns the filter and applies it to the row just above the data

 n=2 turns the filter and applies it to the row 2 rows above the data

 n=k turns the filter and applies it to the row k rows above the data

to the GDXXRW call.

An example is available in filter.gms