Miguel, In this example getInventory() is a function that simply loops through all the rows of a result set and output a <tr> for each one.

gistfile1.txt

<%
if (Request["type"] == "inventorySpreadsheet") {
  	Response.ContentType = "application/vnd.ms-excel";
	Response.AddHeader("Content-Disposition", "attachment; filename=inventory.xls");%>
		<table class="datatable" border="1">
			<thead>
				<tr>
					<th>Description</th>
					<th>Lot/Receiver</th>
					<th>Qty On Hand</th>
					<th>REC#</th>
					<th>SO#</th>
					<th>PO#</th>
				</tr>
			</thead>
			<tbody>
				<% getInventory(); %>
			</tbody>
		</table><%
	}
%>