guys nid some help...im trying to pass my datas from sql to an excel worksheet..ive have made the transfer but it still prompts me to either open the file or save the file..
is there a way to automatically transfer the data and open the excel worksheet??..
i think the answer is in the header configuration but im still a new at this..
this is my header configuration :
PHP Code:
header ( "Expires: Mon, 1 Apr 1974 05:00:00 GMT");
header ( "Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT" );
header ( "Pragma: no-cache" );
header ( "Content-type: application/octet-stream; name=$this->ExcelDataName".".xls");
header ( "Content-Disposition: attachment; filename=$this->ExcelDataName".".xls");
header ( "Content-Description: MID Gera excel" );
print ( $this->armazena_dados);