Html報表用Excel打開保持表格線【Html報表模板】
注：本人調試的最簡版，前兩處紅色部分是為了輸出Excel表格線；x:str表示輸出為文本樣式，避免被輸出為科學計數法。
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns:x="urn:schemas-microsoft-com:office:excel">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>XX銀行業務狀況表</title>
<!--[if gte mso 9]>
<xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>XX銀行業務狀況表</x:Name>
<x:WorksheetOptions>
<x:Selected />
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml>
<![endif]-->
<style type="text/css">
<!--
table { font-family: Arial; font-size: 9pt; border-collapse:collapse; width: 270mm; min-width: 270mm; max_width: 270mm; }
.title { text-align:center; font-size:25px; font-weight:bold; padding:25px; }
.tblborder td { border:0.5pt solid #000000; border-collapse:collapse; width:100px; }
.left { text-align: left; }
.center { text-align: center; }
.right { text-align: right; }
-->
</style>
</head>
<body>
<table>
<tr>
<td colspan="9" class="title">XX銀行業務狀況表</td>
</tr>
<tr>
<td width="33%">城區支行日報</td>
<td width="33%">報表日期：XXXX 至 XXXX</td>
<td class="right">幣種：人民幣元</td>
</tr>
</table>
<table class="tblborder">
<tr class="center">
<td rowspan="2">項目代號</td>
<td rowspan="2">項目名稱</td>
<td colspan="2">期初余額</td>
<td colspan="2">本期發生額</td>
<td colspan="2">期末余額</td>
<td rowspan="2">項目代號</td>
</tr>
<tr class="center">
<td>借方</td>
<td>貸方</td>
<td>借方</td>
<td>貸方</td>
<td>借方</td>
<td>貸方</td>
</tr>
<tr>
<td>10</td>
<td>一、資產類</td>
<td class="right" x:str>100861008610086</td>
<td class="right" x:str>100101001010010</td>
<td class="right" x:str>000000000000000</td>
<td class="right" x:str>111111111111111</td>
<td class="right" x:str>100001000010000</td>
<td class="right" x:str>777777777777777</td>
<td>10</td>
</tr>
<tr>
<td>1001</td>
<td>現金</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>1001</td>
</tr>
<tr>
<td>100</td>
<td>合計</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>100</td>
</tr>
</table>
<table>
<tr>
<td width="25%">行長(主任):</td>
<td width="25%">處(科)長：</td>
<td width="25%">復核:</td>
<td width="25%">制表:</td>
</tr>
</table>
</body>
</html>
浙公網安備 33010602011771號