You may have to Automate to an Excel Print Preview.
This means you will be working with Excel Page Setup (for Headers), Cell Merges (for fancy stuff) and Excels print Previews:
To force a print preview:

oExcel.ActiveWorkBook.PrintPreview()

To Build an Excel Header using automation

.ActiveSheet.PageSetup.RightHeader = cdow(date())+[ ]+cmonth(date());
+str(day(date()),3)+str(year(date()),5)+[:]+left(time(),5);
+Chr(10) + "Page &P of  &N" + Chr(10) + "Ref:&F"

Merge cell commands:

* Column Headers
.Range("E1:F1").Select
.Selection.MergeCells=.t.
.Selection.HorizontalAlignment=3

You can record Excel macros, and convert them to VFP compliant automation. I have a procedure I used a couple years back that you study as you work your project. I'll email a sample Excel Print Preview VFP Automation if it will help!


>What is the best way to create Excel/ import from XL / export to XL
> data between Excel and VFP . I looking for complex spreadheets,
> with headers subgroups/subtottals grandTotals at end of Excel.
>
> Any code, tools or suggestions ?
>
> Thanks
> George