php report to excel การขึ้นบรรทัดใหม่ กำหนดขนาดคอลัมน์

<?php 
session_start();
$strExcelFileName="ตารางสอน $name $term_code-$year_code.xls";
header("Content-Type: application/x-msexcel; name=\"$strExcelFileName\"");
header("Content-Disposition: inline; filename=\"$strExcelFileName\"");
header("Pragma:no-cache");
if($_GET["page"] != '')$page = $_GET["page"];
else $page = 0;
$path = "../../include/";
include($path."database_info.php");

?>

 <table align="center" width="100%">
        <tr>
        <td align="center" style="font-size:20;color:#000;font-weight: bold;" colspan="14">ตารางอบรม TOEIC การเตรียมความพร้อมภาษาอังกฤษเพื่อการทำงาน ภาคเรียนที่ <?php echo $term_code."/".$year_code ?></td>
        </tr>
        <tr>
        <td align="center" style="font-size:20;color:#000;font-weight: bold;" colspan="14">โดย อ.<?php echo $name?></td>
        </tr>
        <tr>&nbsp;</tr>
 </table>
 <table width="50%" border="0" cellpadding="0" cellspacing="0">
 <tr>
 <td width="7%" valign="top">
 <table width="50%" border="1" cellspacing="10" cellpadding="0">
 <tr>
 <td height="34" align="center"rowspan="2"><span class="style11">วัน/เวลา</span></td>
 </tr>
 <tr>
 </tr>
 <tr>
 <td height="50" align="center"><span class="style11">จันทร์</span></td>
 </tr>
 <tr>
 <td height="50" align="center"><span class="style11">อังคาร</span></td>
 </tr>
 <tr>
 <td height="50" align="center"><span class="style11">พุธ</span></td>
 </tr>
 <tr>
 <td height="50" align="center"><span class="style11">พฤหัสบดี</span></td>
 </tr>
 <tr>
 <td height="50" align="center"><span class="style11">ศุกร์</span></td>
 </tr>
 <tr>
 <td height="50" align="center"><span class="style11">เสาร์</span></td>
 </tr>
 <tr>
 <td height="50" align="center"><span class="style11">อาทิตย์</span></td>
 </tr>
 </table>
 
<?
 echo '<td width="100%" align="center" valign="top">';
 echo '<table border="1" width="100%" align="center" cellspacing="1">';
  echo '<tr>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>1</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>2</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>3</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>4</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>5</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>6</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>7</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>8</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>9</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>10</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>11</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>12</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>13</span></td>';
 echo '</tr>';
 echo '<tr>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>08.00 - 09.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>09.00 - 10.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>10.00 - 11.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>11.00 - 12.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>12.00 - 13.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>13.00 - 14.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>14.00 - 15.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>15.00 - 16.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>16.00 - 17.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>17.00 - 18.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>18.00 - 19.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>19.00 - 20.00</span></td>';
 echo '<td align="center" style="font-size:10;color:#000;"><span>20.00 - 21.00</span></td>';
 echo '</tr>';
 
 echo'<tr>';
//$k=0;
for($i=0;$i<=6;$i++){
	for($j=8;$j<=20;$j++){
		//print_r($j);
		//echo "      ";
		$t_start =(string)$j;
		$t_start = $t_start.".00";
		$sql = "select * from colearning a 
				INNER JOIN subject b ON a.subject_id = b.subject_id
				INNER JOIN build c ON a.build_id = c.build_id
				INNER JOIN room d ON a.room_id = d.room_id
				where UID = '$uid' and d_id = '$i' and t_start = '$t_start' and term_code = '$term_code' and year_code = '$year_code'";
		$query_sql = $db->query($sql);
		$rec = $query_sql->fetch();
		//print_r($rec);
		$start = (int)$rec['t_start'];   
		$end = (int)$rec['t_end'];
		if(($j==$start)&&($i==$rec['d_id'])){
		$h_sum = $end-$start;
		$sum=$h_sum*1;
		$namegroup = $rec['namegroup'];
		$n_subject = $rec['SUBJECT_NAME_TH'];
		$build = $rec['BUILD_CODE'];
		$room = $rec['ROOM_CODE'];
		
		
		echo '<td height="50" bgcolor="#E6E6FA" style="font-size:14;color:#000;" rowspan="1"  colspan="'.$sum.'" align="center">'." กลุ่ม ".$namegroup." ตึก ".$build." ห้อง ".$room.'</td>';
		$j=($j+$h_sum)-1;
			}
		else{
	echo '<td height="50" colspan="1"></td>';
}
		}
		echo'</tr>';
		}
		echo'</table>';
		echo'</td>';
//}		 	
?>

</table>