I'm using the exportDataStoreEntityToExcel sail function to pull data from a single table into excel...
The data I'm pulling has a location identifier for each row. Is it at all possible to write the data into excel so that data for each location is on a different sheet ?table has loc1 field2 field3 field4loc1 field2 field3 field4loc2 field2 field3 field4loc3 field2 field3 field4loc2 field2 field3 field4I'd like to get the spreadsheet to have
loc1 field2 field3 field4loc1 field2 field3 field4
tabs :Loc1 Loc2 Loc3
Discussion posts and replies are publicly visible
You might want/need to check out the Export CDT to Excel smart service in the Excel Tools plug-in. It's officially "deprecated" now but after testing I've found it still works perfectly well in the latest plugin version / latest Appian version. And since they've never bothered to provide a remotely sufficient replacement, I consider this "fair game".
Can't say I disagree with that, I had to use this component recently to solve an issue with all other Export to Excel mechanisms. Don't tell my team! ;)