Thread: Export to Excel file prompt

Hi All,

Ok, I have the following button to prompt to export asp page data to excel...

Code:

function exportToExcel(){
      answer = confirm("Are you sure you want to export? Click Save and export to your computer!") 
      if (answer == 1)
          location.href = "TestExcel.asp?DistrictID=<%= sDistricts %>&TypeID=<%= sTypeID %>"
}

The TestExcel.asp page uses:

Code:

Response.ContentType = "application/vnd.ms-excel"

Well, if I pass TypeID=1 or 2 or nothing it works fine...but when passing =3 it doesn't work...

when you get the prompt to "Open" or "Save" it displays you the

FileName:
Type:
From:

Well, instead of showing the normal info like so:

Code:

FileName: TestExcel.asp
Type: Microsoft Excel Worksheet, 218kb
From: servername

when I pass =3 it shows me this and doesn't download:

Code:

FileName: ...TestExcel_asp?DistrictID=2TypeID=3
Type: Microsoft Excel Worksheet, 25.0kb
From: servername

Ok, I had another thread regarding removing the formatcurrency...I removed those from this excel.asp page and all is good..

Just found this could also be related to a field name does not exist in query. As soon as I removed all worked fine.