A while back I asked a question about how to pass a list of columns to display in a views table and a solution closest to what I wanted to do was a module:
I was positively shocked that the description of the project mentioned the second part of what I need to do here. Export that view to an Excel spreadsheet.
This module provides additional advantages when used with the Views Bonus Pack module or the Views Excel Export module to generate an xls file from a view. The xls file will only display the fields you have chosen on the rendered view instance in browser.
I need to let the user choose the columns, then render the view with those columns and expose filters for all chosen columns, apply them, then download the result in an excel file. Unfortunately I was not able to find a description how do I actually do that. Using the xls feed option I don't get any fields from the view itself (seems like I need to add the fields manually again) which I can't imagine works with the filters from the view itself. Exporting the file works, but it only shows the default "Title" field (without adding fields to the feed manually).
I had the same problems with Views data export, creating a new data export started with a default "Title" field and I don't think you're supposed to add the same filters again.
Let me know if you have any experience with those modules or ever had to export a view to a spreadsheet.