>>>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
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
