⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 excelexport.htm

📁 delphi实现EXCEL复杂导入导出功能的类
💻 HTM
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
<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=gb2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="ExcelExport.files/filelist.xml">
<link rel=Edit-Time-Data href="ExcelExport.files/editdata.mso">
<link rel=OLE-Object-Data href="ExcelExport.files/oledata.mso">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>MC SYSTEM</o:Author>
  <o:LastAuthor>MC SYSTEM</o:LastAuthor>
  <o:Created>2008-09-30T10:11:26Z</o:Created>
  <o:LastSaved>2008-09-30T10:11:29Z</o:LastSaved>
  <o:Company>MC SYSTEM</o:Company>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
</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;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	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:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	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:black;
	font-size:8.0pt;
	font-family:"MS Sans Serif", sans-serif;
	mso-font-charset:0;}
.xl25
	{mso-style-parent:style0;
	color:black;
	font-size:8.0pt;
	font-family:"MS Sans Serif", sans-serif;
	mso-font-charset:0;
	mso-number-format:"mm\\\/dd\\\/yyyy";}
.xl26
	{mso-style-parent:style0;
	color:black;
	font-size:8.0pt;
	font-family:"MS Sans Serif", sans-serif;
	mso-font-charset:0;
	mso-number-format:"General Date";}
.xl27
	{mso-style-parent:style0;
	color:black;
	font-size:8.0pt;
	font-family:"MS Sans Serif", sans-serif;
	mso-font-charset:0;
	mso-number-format:"\@";}
.xl28
	{mso-style-parent:style0;
	color:black;
	font-size:8.0pt;
	font-family:"MS Sans Serif", sans-serif;
	mso-font-charset:0;
	mso-number-format:Standard;}
.xl29
	{mso-style-parent:style0;
	color:black;
	font-size:8.0pt;
	font-family:"MS Sans Serif", sans-serif;
	mso-font-charset:0;
	mso-number-format:"\0022￥\0022\#\,\#\#0\.00";}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>ExcelExport</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>10695</x:WindowHeight>
  <x:WindowWidth>18195</x:WindowWidth>
  <x:WindowTopX>480</x:WindowTopX>
  <x:WindowTopY>30</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<body link=blue vlink=purple>

<table x:str border=0 cellpadding=0 cellspacing=0 width=1668 style='border-collapse:
 collapse;table-layout:fixed;width:1252pt'>
 <col width=73 span=2 style='mso-width-source:userset;mso-width-alt:2336;
 width:55pt'>
 <col width=95 style='mso-width-source:userset;mso-width-alt:3040;width:71pt'>
 <col width=136 style='mso-width-source:userset;mso-width-alt:4352;width:102pt'>
 <col width=73 style='mso-width-source:userset;mso-width-alt:2336;width:55pt'>
 <col width=72 span=12 style='width:54pt'>
 <col width=95 style='mso-width-source:userset;mso-width-alt:3040;width:71pt'>
 <col width=73 span=2 style='mso-width-source:userset;mso-width-alt:2336;
 width:55pt'>
 <col width=113 style='mso-width-source:userset;mso-width-alt:3616;width:85pt'>
 <tr height=19 style='height:14.25pt'>
  <td height=19 class=xl24 width=73 style='height:14.25pt;width:55pt'>OrderNo</td>
  <td class=xl24 width=73 style='width:55pt'>CustNo</td>
  <td class=xl24 width=95 style='width:71pt'>SaleDate</td>
  <td class=xl24 width=136 style='width:102pt'>ShipDate</td>
  <td class=xl24 width=73 style='width:55pt'>EmpNo</td>
  <td class=xl24 width=72 style='width:54pt'>ShipToContact</td>
  <td class=xl24 width=72 style='width:54pt'>ShipToAddr1</td>
  <td class=xl24 width=72 style='width:54pt'>ShipToAddr2</td>
  <td class=xl24 width=72 style='width:54pt'>ShipToCity</td>
  <td class=xl24 width=72 style='width:54pt'>ShipToState</td>
  <td class=xl24 width=72 style='width:54pt'>ShipToZip</td>
  <td class=xl24 width=72 style='width:54pt'>ShipToCountry</td>
  <td class=xl24 width=72 style='width:54pt'>ShipToPhone</td>
  <td class=xl24 width=72 style='width:54pt'>ShipVIA</td>
  <td class=xl24 width=72 style='width:54pt'>PO</td>
  <td class=xl24 width=72 style='width:54pt'>Terms</td>
  <td class=xl24 width=72 style='width:54pt'>PaymentMetho<span
  style='display:none'>d</span></td>
  <td class=xl24 width=95 style='width:71pt'>ItemsTotal</td>
  <td class=xl24 width=73 style='width:55pt'>TaxRate</td>
  <td class=xl24 width=73 style='width:55pt'>Freight</td>
  <td class=xl24 width=113 style='width:85pt'>AmountPaid</td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td height=19 class=xl24 align=right style='height:14.25pt' x:num>1003</td>
  <td class=xl24 align=right x:num>1351</td>
  <td class=xl25 align=right x:num="32245">04/12/1988</td>
  <td class=xl26 align=right x:num="32266.5">1988-5-3 12:00</td>
  <td class=xl24 align=right x:num>114</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27>UPS</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27>FOB</td>
  <td class=xl27>Credit</td>
  <td class=xl28 align=right x:num="1250">1,250.00</td>
  <td class=xl24 align=right x:num>4.5</td>
  <td class=xl29 align=right x:num="0">￥0.00</td>
  <td class=xl29 align=right x:num="0">￥0.00</td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td height=19 class=xl24 align=right style='height:14.25pt' x:num>1004</td>
  <td class=xl24 align=right x:num>2156</td>
  <td class=xl25 align=right x:num="32250">04/17/1988</td>
  <td class=xl26 align=right x:num="32251">1988-4-18 0:00</td>
  <td class=xl24 align=right x:num>145</td>
  <td class=xl27>Maria Eventos<span style='display:none'>h</span></td>
  <td class=xl27>PO Box 737</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27>Johannesburg</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27>2042</td>
  <td class=xl27>Republic So. A<span style='display:none'>frica</span></td>
  <td class=xl27>27-11-4432458</td>
  <td class=xl27>DHL</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27>FOB</td>
  <td class=xl27>Check</td>
  <td class=xl28 align=right x:num="7885">7,885.00</td>
  <td class=xl24 align=right x:num>0</td>
  <td class=xl29 align=right x:num="0">￥0.00</td>
  <td class=xl29 align=right x:num="7885">￥7,885.00</td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td height=19 class=xl24 align=right style='height:14.25pt' x:num>1005</td>
  <td class=xl24 align=right x:num>1356</td>
  <td class=xl25 align=right x:num="32253">04/20/1988</td>
  <td class=xl26 align=right x:num="32163.5">1988-1-21 12:00</td>
  <td class=xl24 align=right x:num>110</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27>UPS</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27>FOB</td>
  <td class=xl27>Visa</td>
  <td class=xl28 align=right x:num="4807">4,807.00</td>
  <td class=xl24 align=right x:num>0</td>
  <td class=xl29 align=right x:num="0">￥0.00</td>
  <td class=xl29 align=right x:num="4807">￥4,807.00</td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td height=19 class=xl24 align=right style='height:14.25pt' x:num>1006</td>
  <td class=xl24 align=right x:num>1380</td>
  <td class=xl25 align=right x:num="34644">11/06/1994</td>
  <td class=xl26 align=right x:num="32454.5">1988-11-7 12:00</td>
  <td class=xl24 align=right x:num>46</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27>Emery</td>
  <td class=xl27>P101324</td>
  <td class=xl27>FOB</td>
  <td class=xl27>Visa</td>
  <td class=xl28 align=right x:num="31987">31,987.00</td>
  <td class=xl24 align=right x:num>0</td>
  <td class=xl29 align=right x:num="0">￥0.00</td>
  <td class=xl29 align=right x:num="0">￥0.00</td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td height=19 class=xl24 align=right style='height:14.25pt' x:num>1007</td>
  <td class=xl24 align=right x:num>1384</td>
  <td class=xl25 align=right x:num="32264">05/01/1988</td>
  <td class=xl26 align=right x:num="32265">1988-5-2 0:00</td>
  <td class=xl24 align=right x:num>45</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27>US Mail</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27>FOB</td>
  <td class=xl27>Visa</td>
  <td class=xl28 align=right x:num="6500">6,500.00</td>
  <td class=xl24 align=right x:num>0</td>
  <td class=xl29 align=right x:num="0">￥0.00</td>
  <td class=xl29 align=right x:num="6500">￥6,500.00</td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td height=19 class=xl24 align=right style='height:14.25pt' x:num>1008</td>
  <td class=xl24 align=right x:num>1510</td>
  <td class=xl25 align=right x:num="32266">05/03/1988</td>
  <td class=xl26 align=right x:num="32267">1988-5-4 0:00</td>
  <td class=xl24 align=right x:num>12</td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
  <td class=xl27 x:str=""></td>
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -