NuSphere Forums Forum Index
NuSphere Forums
Reply to topic
export data to excel


Joined: 31 Mar 2005
Posts: 1
Reply with quote
hello!
i just discovered a really cool feature that i never noticed before in phped that allow you to export your data to MSexcel (into column format).
Code:
<?php
print "col1\tcol2\tcol3\tcol4\tcol5\tcol6\n";
print "1234\t568456\t12341234\t45674567\t23452345\t6785678\n";
print "4352345\t23452345\t34563456\t34252345\t3456345634\t56\n";
?>

after you run the code right click in the output window and there is an option to export to excel. by using the tab delimiter (\t) excel will place the items into columns!
enjoy,
jaan
(sorry i had to use a new username because i forgot my old one!)
View user's profileFind all posts by ipfreelySend private message
Site Admin

Joined: 13 Jul 2003
Posts: 8342
Reply with quote
it's rather feature of Internet Explorer integrated into phped.
View user's profileFind all posts by dmitriSend private messageVisit poster's website
export data to excel
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 5 Hours  
Page 1 of 1  

  
  
 Reply to topic