One of the solutions:

sele * from yourtable into cursor curs1 readwrite
calc sum(OrdCnt) to ln
appe blank
appe blank
repl ordCnt with ln
copy to ... xls

You may need to extend the length of the OrdCnt in case there is not enough space for the total. Like:

sele ..., 0000000000.00 + OrdCnt as OrdCnt from yourtable into cursor curs1 readwrite

>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.
>
>Thanks