Kali ini dengan format XML nya, kelebihannya bisa ditampilkan di web browser, tinggal mengganti ekstensinya dengan .html
kelemahannya codingnya agak sulit, dan fungsi asli excelnya tidak tercover semuanya, misal untuk membuat grafik, dsb
<startcode>
< ?php
header("Cache-Control: no-cache, no-store, must-revalidate");
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=namaFile.xls");
//isi file excel (pakai xml)
echo '
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
</meta><meta name=ProgId content=Excel.Sheet>
</meta><meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="data.xls_files/filelist.xml">
</link><link rel=Edit-Time-Data href="data.xls_files/editdata.mso">
</link><link rel=OLE-Object-Data href="data.xls_files/oledata.mso">
<!--[if gte mso 9]><xml>
<o :DocumentProperties>
</o><o :LastAuthor>bambangriadi</o>
<o :Created>2008-06-13T04:50:40Z</o>
<o :LastSaved>2008-06-13T04:50:40Z</o>
<o :Version>11.5606</o>
</xml>< ![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@page
{margin:1.0in .75in 1.0in .75in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
border:none;
mso-protection:locked visible;
mso-style-name:Normal;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
color:white;
text-align:center;
border:.5pt solid black;
background:#666699;
mso-pattern:auto none;
white-space:normal;}
.xl25
{mso-style-parent:style0;
color:white;
text-align:center;
border-top:.5pt solid black;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;
background:#666699;
mso-pattern:auto none;
white-space:normal;}
.xl26
{mso-style-parent:style0;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:.5pt solid black;
background:white;
mso-pattern:auto none;
white-space:normal;}
.xl27
{mso-style-parent:style0;
border-top:none;
border-right:.5pt solid black;
border-bottom:.5pt solid black;
border-left:none;
background:white;
mso-pattern:auto none;
white-space:normal;}
.xl28
{mso-style-parent:style0;
font-size:12.0pt;
font-weight:700;
text-align:center;
white-space:normal;}
.xl29
{mso-style-parent:style0;
border-top:none;
border-right:none;
border-bottom:.5pt solid black;
border-left:none;
white-space:normal;}
-->
</style>
<!--[if gte mso 9]><xml>
<x :ExcelWorkbook>
</x><x :ExcelWorksheets>
</x><x :ExcelWorksheet>
</x><x :Name>average_01-3-2008To27-3-2008</x>
<x :WorksheetOptions>
<x :Selected/>
<x :DoNotDisplayGridlines/>
</x><x :Panes>
</x><x :Pane>
</x><x :Number>3</x>
<x :ActiveRow>25</x>
<x :ActiveCol>11</x>
<x :ProtectContents>False</x>
<x :ProtectObjects>False</x>
<x :ProtectScenarios>False</x>
<x :WindowHeight>9900</x>
<x :WindowWidth>19005</x>
<x :WindowTopX>120</x>
<x :WindowTopY>30</x>
<x :ProtectStructure>False</x>
<x :ProtectWindows>False</x>
</xml>< ![endif]-->
</link></meta></head>
<body link=blue vlink=purple>
<table x:str border=0 cellpadding=0 cellspacing=0 width=380 style="border-collapse:
collapse;table-layout:fixed;width:285pt">
<col width=55 style="mso-width-source:userset;mso-width-alt:2011;width:41pt">
</col><col width=230 style="mso-width-source:userset;mso-width-alt:8411;width:173pt">
</col><col width=43 style="mso-width-source:userset;mso-width-alt:1572;width:32pt">
</col><col width=52 style="mso-width-source:userset;mso-width-alt:1901;width:39pt">
<tr height=21 style="mso-height-source:userset;height:15.75pt">
<td colspan=4 height=21 class=xl28 width=380 style="height:15.75pt;
width:285pt">DATA PEGAWAI</td>
</tr>
<tr height=21 style="mso-height-source:userset;height:15.75pt">
<td colspan=4 height=21 class=xl28 width=380 style="height:15.75pt;
width:285pt">PT METRO KU</td>
</tr>
<tr height=17 style="height:12.75pt">
<td colspan=4 height=17 class=xl29 width=380 style="height:12.75pt;
width:285pt"> </td>
</tr>
<tr height=17 style="height:12.75pt">
<td height=17 class=xl24 width=55 style="height:12.75pt;border-top:none;
width:41pt">No</td>
<td class=xl25 width=230 style="border-top:none;width:173pt">Nama</td>
<td class=xl25 width=43 style="border-top:none;width:32pt">Umur</td>
<td class=xl25 width=52 style="border-top:none;width:39pt">Status</td>
</tr>
<tr height=17 style="height:12.75pt">
<td height=17 class=xl26 width=55 style="height:12.75pt;width:41pt"> 1</td>
<td class=xl27 width=230 style="width:173pt">Ruadi</td>
<td class=xl27 align=right width=43 style="width:32pt" x:num>23</td>
<td class=xl27 width=52 style="width:39pt">L</td>
</tr>
<tr height=17 style="height:12.75pt">
<td height=17 class=xl26 width=55 style="height:12.75pt;width:41pt"> 2</td>
<td class=xl27 width=230 style="width:173pt">Pak Min</td>
<td class=xl27 align=right width=43 style="width:32pt" x:num>14</td>
<td class=xl27 width=52 style="width:39pt">L</td>
</tr>
<tr height=17 style="height:12.75pt">
<td height=17 class=xl26 width=55 style="height:12.75pt;width:41pt"> 3</td>
<td class=xl27 width=230 style="width:173pt">Liana</td>
<td class=xl27 align=right width=43 style="width:32pt" x:num>51</td>
<td class=xl27 width=52 style="width:39pt">P</td>
</tr>
< ![if supportMisalignedColumns]>
<tr height=0 style="display:none">
<td width=55 style="width:41pt"></td>
<td width=230 style="width:173pt"></td>
<td width=43 style="width:32pt"></td>
<td width=52 style="width:39pt"></td>
</tr>
< ![endif]>
</col></table>
</body>
';
?>
</startcode>
simpan dengan nama data.xls
untuk menampilkan ke web browser simpan dengan nama data.html
gitu kan…
Oktober 20th, 2009 at 11:08
saya ingin tanya…saya menggunakan http://www.webdesignforum.com/5442-dynamically-created-multiple-sheet-excel-file-asp-idea-might-work-php-too.html untuk membuat xls dg asp. ketika mengenerate xls akan keluar pop up window yg akan tertutup ketika xls terbuka tetapi ketika saya coba di ie6 pop up itu tidak tertutup..apakah ada settingan atau codingan yg bs mengclosenya.tx