>Trying to Export a table into XLS Spreadsheet, the data in the table is being grouped. I want to be able to Insert an empty row and automatically calculate the total of a Column called OrdCnt below the empty row to display totals of OrdCnt.


Use COM Automation. Anything you want to do in Excel, you can record a macro for it then translate the VBA generated code to VFP (it's fairly similar and easy).

First you take a reference with:

oExcel = CreateObject("Excel.Application")

then you have access to the whole Excel DOM.

See: http://fox.wikis.com/wc.dll?Wiki~AutomationExamples