Probably best to ask this question in an Excel forum – preferably one where the members are clairvoyant, so they don't need further details to make meaningful suggestions.
Also better to not ask the entire question in the title, provide more info, and say crazy crazy things like 'please' & 'Thank you'
You could use AppleScript to modify & format the spreadsheet after the export is completed. Obviously this doesn't help if you're on Windows.
Or you can avoid the Export scrip step entirely. Build and format the spreadsheet just the way you like in Excel and save the file as .xlsx, which is XML. Copy & paste the XML text into a field in your FileMaker solution. Then in FileMaker instead of exporting, loop through the records to be exported, and search & replace sample data in the excel text. Finally, write the new excel file to disk.
Either way it's a lot of work for a pretty spreadsheet.
1 of 1 people found this helpful
1) brsamuel's answer is a good one. Very close to what will have to probably be done.
2) Remember that Excel is NOT a database, but rather a presentation program for data sets*, and therefore does not function as a database would. And, likewise, FileMaker is not a spreadsheet program, but rather a database, and functions accordingly. There will always be gaps in presentation capabilities from one to the other.
3) brsamuel's answer is a good one. Very close to what will have to probably be done.
4) Again, 1) brsamuel's answer is a good one. Very close to what will have to probably be done.
*in a database you can only have one field per column, whereas in the presentation program Excel you can have different fields in any given column, where ever you please. A database cannot export such arbitrary assignments of columnar data (well, not easily).