In a previous recipe, we looked at how to export SmartLists to Excel with the push of a button. That method creates a new Excel file each time. In many cases users need to export the same set of data on a regular basis and build it into a formatted report via Excel. There's a way to accomplish this with SmartList exports. The feature is called Export Solutions and it's the focus of this recipe.
For our recipe, we'll assume that we have an Account Summary report that we want to format with a title and headers the same way every time. To begin we need to set it up the first time.