Exporting into Excel

Results 1 to 2 of 2

Thread: Exporting into Excel

  1. #1
    Join Date
    Dec 1969

    Default Exporting into Excel

    Each time I run through my DO loop in Vbscript I would like to open a new sheet in Excel. I am creating a class list of students, therefore each sheet will contain a new class. Anyone know how to do this?<BR>Thanks!!

  2. #2
    e3 Guest

    Default RE: Exporting into Excel

    Not sure this is what you want, but this will create an excel spreadsheet and send it to the browser which then can be downloaded or viewed.<BR><BR>response.ContentType = "application/vnd.ms-excel"<BR>response.AddHeader "content-disposition", "inline; filename=myfile.xls"<BR><BR>then just do your normal output into a table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts