<% '******************************************************* '* ASP 101 Sample Code - http://www.asp101.com/ * '* * '* This code is made available as a service to our * '* visitors and is provided strictly for the * '* purpose of illustration. * '* * '* http://www.asp101.com/samples/license.asp * '* * '* Please direct all inquiries to webmaster@asp101.com * '******************************************************* %> <% ' Tells the browser to use Excel to open the file Response.ContentType = "application/vnd.ms-excel" ' Your data can come from ANYWHERE! Since that's not the ' point of this sample, I'm just hand writing a table ' below, but it could easily be generated from a database ' as illustrated in some of our other samples. ' Everything that follows is plain HTML... what you see ' in Excel is based on Excel's interpretation of it. ' It picks up the formulas and emulates the formatting ' pretty well... %>

Name	Sales	Commission
David Andersen	6420	=(B2 * 0.05)
Laura Callahan	3675	=(B3 * 0.05)
Frank Edwards	3840	=(B4 * 0.05)
Chris Graham	4050	=(B5 * 0.05)
Owen Ingraham	4750	=(B6 * 0.05)
Robert King	5290	=(B7 * 0.05)
Greg Miller	5640	=(B8 * 0.05)
Ian Ostrander	3965	=(B9 * 0.05)
Howard Quinn	5865	=(B10 * 0.05)
Tammy Steel	3570	=(B11 * 0.05)
Debra Underwood	3790	=(B12 * 0.05)
Mark White	4500	=(B13 * 0.05)
Quincy Youngs	4420	=(B14 * 0.05)
Totals:	=SUM(B2:B14)	=SUM(C2:C14)