deleting blank rows from excel export in classic asp/vb script application

[danielmallard]

I have a export to excel facility in my classic asp /vbscript application that uses \[code\]<%Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "attachment; filename=Inquiry-Test.xls"%> \[/code\]to generate the excel from html table. by doing so, I am getting couple of blank rows into the excel file generated.Any code snippets how can I detect the blank rows and delete them?