header() function...

[enickols]

I'm using the follow code segment to export some data to Excel:

header("Content-Type: application/ms-excel");
header("Content-Disposition: attachment; filename=exported_data.xls");

Everything appears to be working okay. However, I have to click "Open" two times before Excel launches and the data is inserted. Any ideas why this is happening?

Thanks in advance,
EJ

[tha_mink]

I do it this way and it always works for me...

header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=somefile.xls");
header("Pragma: no-cache");
header("Expires: 0");

[enickols]

I think I had it like that at first. But I still had to press "open" twice. Does yours work with only one click?

Thanks!