Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

htmlÒ³Ãæ±í¸ñµ¼³öµ½excel×ܽá


<table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" align="center">html ±í¸ñµ¼³öµÀExcel</td>
</tr>
<tr>
<td>ÁбêÌâ1</td>
<td>ÁбêÌâ2</td>
<td>Àà±êÌâ3</td>
<td>ÁбêÌâ4</td>
<td>ÁбêÌâ5</td>
</tr>
<tr>
<td>aaa</td>
<td>bbb</td>
<td>ccc</td>
<td>ddd</td>
<td>eee</td>
</tr>
<tr>
<td>AAA</td>
<td>BBB</td>
<td>CCC</td>
<td>DDD</td>
<td>EEE</td>
</tr>
<tr>
<td>FFF</td>
<td>GGG</td>
<td>HHH</td>
<td>III</td>
<td>JJJ</td>
</tr>
</table>
1¡¢jsµÄ·½·¨
A¡¢½«Õû¸ö±í¸ñ¿½±´µ½EXCELÖÐ
function method1(tableid) {
var curTbl = document.getElementById(tableid);
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var sel = document.body.createTextRange();
sel.moveToElementText(curTbl);
sel.select();
sel.execCommand("Copy");
oSheet.Paste();
oXL.Visible = true;
}
 B¡¢¶ÁÈ¡±í¸ñÖÐÿ¸öµ¥Ôªµ½EXCELÖУº
function method2(tableid)
{
var curTbl = document.getElementById(tableid);
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var Lenr = curTbl.rows.length;
for (i = 0; i < Lenr; i++)
{
var Lenc = curTbl.rows(i).cells.length;
for (j = 0; j < Lenc; j++)
{
oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText;
}


Ïà¹ØÎĵµ£º

ʹÓÃPerlµÄHTML::TreeBuilder::XPathÀ´½âÎöÍøÒ³ÄÚÈÝ

Ô­ÎĵØÖ·£ºhttp://www.php-oa.com/2009/09/24/perl-html-tree-builder-xpath.html
ת¹ýÀ´ ÂýÂýÑо¿
Ç¿´óµÄPerlÖÐ,Óг¬¼¶¶àÇ¿´óµÄÄ£¿é,ÈÃÎÒÃDz»ÔÚÐèÒªÖظ´µÄ·¢Ã÷ÂÖ×Ó.ÏÂÃæÕâ¸ö¾ÍÊÇÒ»¸öÇ¿´óµÄÄ£¿é.HTML::TreeBuilder::XPath.ËüÄÜÏóxmlÒ»Ñù½âÎöÍøÕ¾.ÔõôʹÓþͲ»Ï¸½²ÁË,ÈçÏÂ,¼ûʵÀý,ÎÒÊÇ´Óalexa.comÍøÕ¾µÃµ½ÎÒµÄÍøÕ¾ÅÅÃûµÄÒ» ......

ÏÂÀ­¿òÊ÷,HTML´úÂë

     ºÜ¶àʱºò£¬ÎÒÃÇÐèÒª½«ÏÂÀ­¿òÀïÃæµÄÊý¾ÝÓÃÊ÷ÏÔʾ³öÀ´£¬ÕâÑù»á±ãÓÚ¿Í»§µÃµ½ÇåÎúµÄÊý¾Ý£¬¶øÇұȽÏÖ±½Ó£¬ÁÀ³öÒÔÏÂHTML´úÂ룬¿ÉÒÔÖ±½Ó¸´ÖƵ½HTML´úÂëÀïÃæÔËÐУ¡
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-tran ......

ÔÚHTMLÖÐǶÈëPDF´úÂë

<OBJECT height="700" width="800" border="0" classid="clsid:CA8A9780-280D-11CF-A24D-444553540000"
>
<PARAM NAME="_Version" VALUE="65539">
<PARAM NAME="_ExtentX" VALUE="20108">
<PARAM NAME="_ExtentY" VALUE="10866">
<PARAM NAME="_StockProps" VALUE="0">
<PARA ......

¼òÊöHTML¿Ø¼þÓëWeb·þÎñÆ÷¿Ø¼þµÄÇø±ð

WEB·þÎñÆ÷¿Ø¼þÊÇHTML¿Ø¼þµÄÒ»ÖÖÀ©Õ¹,Çø±ðÊÇ:
1)Ç°Õß¿ÉÒÔ´¥·¢·þÎñÆ÷¿Ø¼þÌØÓеÄʼþ£¬ºóÕßÖ»ÄÜͨ¹ý»ØµÝµÄ·½Ê½´¥·¢·þÎñÆ÷ÉϵÄÒ³Ã漶ʼþ¡£
2)ÊäÈ뵽ǰÕßÖеÄÊý¾ÝÔÚÇëÇóÖ®¼ä¿ÉÒÔά»¤£¨¼´¾ßÓÐ״̬¹ÜÀí¹¦ÄÜ£©,¶øºóÕßÎÞ·¨×Ô¶¯Î¬»¤Êý¾Ý£¬Ö»ÄÜʹÓÃÒ³Ã漶µÄ½Å±¾À´±£´æºÍ»Ö¸´¡£
3)Ç°Õß¿ÉÒÔ×Ô¶¯¼ì²âä¯ÀÀÆ÷²¢µ÷Õûµ½Ç¡µ±µÄÏÔʾ£¬¶øº ......

ÖØз¢ÏÖHTML±í

    ¸ù¾ÝÎÒ×î½üµÄһЩʵ¼ùÒÔ¼°ÔÚºÍһЩ¶ÁÕß½øÐйØÓÚHTML±í¸ñµÄʹÓÃÎÊÌ⹵֮ͨºó£¬¾ö¶¨Ð´ÕâƪÎÄÕ¡£×ܵÄÀ´Ëµ£¬ÎÒ×¢Òâµ½ÓÉÓÚÎóµ¼ÐÔÐÅÏ¢£¬ËûÃǶÔÓÚtableµÄʹÓÃÓÐÖÖÏÈÈëΪÖ÷µÄÑá¶ñ¡£ÊÂʵÉϺܶàÈË»á˵”ÎÒ¿´µ½ÓÀÔ¶²»Ó¦¸ÃʹÓñí¸ñ”µÄ˵·¨£¬µ«ÊÇÕâ¾ø¶ÔÊÇ´íÎóµÄ£¡Õâ¸ö½¨ÒéÖ»ÊÇÕë¶ÔʹÓÃHTML±í¸ñÀ´¶¨ÒåÍøÒ³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ