Giving the user a scipt that exports data to an Excel sheet
I have a client that would like to be able to export some data from his runtime solution to an Excel file. It looks like to do this I need to create a special table with field names he'll understand, and then have the script import the required data into that table, and then export it to an Excel sheet. Otherwise, I don't see how I can get the script to export field names that are user friendly. Is this the way it's usually done?
What I was hoping to be able to do was actually have a pre-designed Excel sheet, complete with formulas, sitting in the solution's folder, and have the solution import the data into that sheet, but I don't see that I can even come close to that.