HTML To Excel

[njagi]

Day
Time
Unit
Lecturer
Monday
8.00am To 1.00 Pm
BCT 2406 Project Research and definition
 
 
 
 
 
Tuesday
8.00am To 10.00am
BCT 2405 Client Server Systems & Computing
JB Kariuki

 
12.00noon To 2.00PM
BCT 2405 Computer Graphics System
Kihongo

 
2.00PM To 5.00 PM
BCT 2405 Computer Graphics System
Kihongo

 
 
 
 
Wednesday
7.00am To 10.00am
BCT 2405 Client Server Systems & Computing
JB Kariuki

 
11.00noon To 1.00PM
BCT 2403 Knowledge Based Systems
George Okeyo
 
 
 
 
Thursday
7.00am To 10.00am
BCT 2403 Knowledge Based Systems
George Okeyo

 
11.00am To 12.00 PM
BCT 2401 Operations Research
P Kihara

 
12.00am To 2.00 PM
BCT 2404 Decision Support System
L Mburu

 
3.00am To 6.00 PM
BCT 2404 Decision Support System
L Mburu

 
 
 
 
Friday
9.00am To 10.00am
BCT 2401 Operations Research
P Kihara

 
11.00am To 2.00 PM
Research Methodology
L Mengo

 
2.00PM To 4.00 PM
Research Methodology
L Mengo

 
 
 
 

[piers]

easiest way I know is to view it in a web browser and then highlight the information and copy it to excel.

[tirivamwe]

use the following code:

i have just included the first row and hope you will not have problems with the rest:

<?php


echo "<table cellspacing='4' cellpadding='4' border=1 align=center>";
echo"<tr>";
echo"<td>Day</td>";
echo"<td>Time</td>";
echo"<td>Unit</td>";
echo"<td>Lecturer</td>";
echo"</tr>";

echo"</table>";















header("Content-type: application/octet-stream");

# replace excelfile.xls with whatever you want the filename to default to
header("Content-Disposition: attachment; filename=excelfile.xls");
header("Pragma: no-cache");
header("Expires: 0");


?> 
  
  
</p>
</body>
</html>

please if found this code helpful, can you add my reputation

[jwf3148]

This works for me !!! Thank you very much !!!

[rui.penso]

can i format the table columns? like tell the column to act as a number?
i getting 1231 instead 1.23443E+14 of 123443211234000

[sainiweb]

thanx

[ddellostritto]

Hi! A little late, but.... I found the following 'library' easy to use.

http://innovationsdesign.net/wb_2.7/pages/tech-resources/downloads/desktop_write.php

Using php, could you pass what you want to pass into excel via a variable and your set.

Hope it helps.