hi ,
i want to convert my file into excel and word format in linux how can i do that.
whe i used to work in windows i was doing like
inmy file i.e
header("Content-Type: application/vnd.ms-excel")
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
now in linux
im using OpenOffice.org Calc and writter so how can i do that
thanx
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I convert into excel all the time. I found my answer in a pear module.
http://pear.php.net/packag
It is absolutely excellent and very easy to work with.
Good Luck!
Josh Rogers
hi,
Thanx for the excellent support,
But my code is not working.
Actually my code is lik this
tabexcel.php
<html>
<head>
<title> excel File</title>
<script language="javascript">
function code(){
document.test.action = "test.php";
document.test.submit();
}
</script>
</head>
<body>
<form name="test">
<input name="Generate" type="button" value="Generate" onClick="javascript:code()
</form>
</body>
</html>
test.php
<?php
$query = "select firstname,lastname,salary from trainee_emp";
$db_conn = ocilogon( "..", "..", "..." );
$parsed = ociparse($db_conn, $query);
ociexecute($parsed);
$nrows = ocifetchstatement($parsed,
$data = "FIRSTNAME\tLASTNAME\tSALA
if($nrows!=0){
for ($i = 0; $i < $nrows; $i++ ){
$fn = $result["FIRSTNAME"][$i];
$ln = $result["LASTNAME"][$i];
$sal = number_format($result["SAL
$data .= "$fn\t$ln\t$sal\n"; // This will generate data into csv format
}
}
header("Content-type: application/vnd.sun.xml.ca
//header("Content-disposit
print $data;
exit;
?>
When i run this code in windows and write header("Content-type: application/vnd.ms-excel")
it doesnt work so pl tell me what is d solution.
thanx
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I will leave the following recommendation for this question in the Cleanup topic area:
Split: WoodyRoundUp & joshlrogers
Any objections should be posted here in the next 4 days. After that time, the question will be closed.
Huji
EE Cleanup Volunteer
Business Accounts
Answer for Membership
by: WoodyRoundUpPosted on 2005-07-05 at 00:59:41ID: 14366487
i think it's the same.
i use both of these to create csv file.
but, i am not sure about excel. did you try it and it failed?