>>>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. Basically, I'll be taking individual report fields and putting their contents into specific cells on specific worksheets in the output workbook.
>
>Would you be able to get it approximately right in a cursor or dbf? If so, at one stage we were able to rename the dbf as an xls and Excel would open it. If it's a fancy pants Excel sheet, check out XFRX or Foxypreviewer that may be able to save you a heap of effort...

The report needs about 10 views and a couple of cursoradapters to drive it :) So no, I can't easily get the output into a single cursor/DBF. You're right though, Excel will open Fox2x-style DBFs directly (without renaming the extension).

It will be (somewhat) fancy-pants and I've been working with Greg Green's VFPxWorkbookXLSX class: https://github.com/ggreen86/XLSX-Workbook-Class