Problem in Export to excel in Php

[dd2308]

Hello Everyone,

I want to transfer data in export from my php reports.
it works also. but the problem is when i open that .xls file in notepad i can view all my data. i don't want this.my data will be unsecure.can anybody tell me solution??
code is as below:

$xlsfile = "Total Addtion".date("m-d-Y-hiA").".xls";

header('Content-type: application/ms-excel');
header("Content-Disposition: attachment; filename=$xlsfile");
header("Pragma: no-cache");
 header("Content-Transfer-Encoding: binary ");

[pritaeas]

So what do you want ?

[dd2308]

when i open it in notepad javascrit can be viewed also sometime query if they arey coded as echo

[dd2308]

if u open a normal excel file in notepad u can't read anything .

[pritaeas]

Maybe you are outputting the wrong thing. Hard to say without any code.