I'm working to output a VFP report to an Excel .xlsx file. It will have a very different structure from the VFP report so I can't use any sort of direct output-to-Excel function. ...
I could suggest another approach. The data is loaded first into a temporary sheet (I use a query from SQL-server). The final layout is created with a VBA macro.