Hello Marco

Thank you for your interest in our plugin.

I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.

You are able to either Link to an existing Excel file or import the file to create a manual table, but unfortunately no formulas and formatting will be transferred over to the plugin's table. You can, however, make your own formulas with Formula Columns, and apply all formatting from within the plugin itself. If something you're looking for to achieve isn't available through settings, we can probably help you out with some CSS.

Filters can be used on the website, of course. wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look the same both in back-end and in front-end.