BEX large amount of filter values

We have BEX Reports within webtemplates for the users. They want to filter a large amount of values (about 100)for e.g. the materialnumber. The materialnumbers for the filter differ from day to day.

Does anybody know how it is possible to add so many values in the filter or in the variable screen without typing them one after another?

Is it possible to add the filter values via an excel sheet?

Thanks for tips.

Eva