I've just noticed that if the excel file exists already and I choose to overwrite it, that is when the blank rows get added in. If I manually delete the file before running the export it works properly!

Really weird, but at least I can now work around it.

>Do you have empty rows in the CA cursor?
>
>>
>>I'm using Craig Boyd's GridExtras class to allow data to be exported to Excel. I'm adjusting the default code so that rather than just the data in a grid gets exported, but the data from a specified cursor which may or may not be tied to a grid.
>>
>>The data are getting exported, but so are lots of blank rows.
>>
>>This is the code that creates the excel file:
>>
><snip>
>>
>>Stepping through this code shows that the m.loCursorAdapter.Alias has the correct data in it prior to the TABLEUPDATE(.T.,.T.,m.loCursorAdapter.Alias) and the return value is .T.
>>
>>So why should there be all these blank rows in the Excel file?
>>
>>I've never worked with cursoradapters before so if I need to provide more info, let me know.