You can use apache-poi to create excel files by yourself. Create an excel file and run through entities and add rows and cells to excel file (i.e. one per day from date range)
Filter won’t work with the datasource containing non-persistent entities, because it just modifies the JPQL query of the datasource. However, you can define additional datasource for your original persistent entity and load data with it. This datasource would not be linked to any table, only to the filter. So instead of loading by DataManager, you will load by the filtered datasource.