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;
}
Ïà¹ØÎĵµ£º
Crescent Eve(http://www.kashim.com/eve/
)ÊÇÃâ·ÑµÄHTML,CSSµÄ±à¼Æ÷.
ºÍ¼Çʱ¾ÀàËÆ,·Ç³£¼ò½à.
Ö÷ÒªÓÐÒÔÏÂ4¸ö¹¦ÄÜ
HTMLµÄtagÊäÈëÌáʾ
tagÊôÐÔµÄÊäÈëÌáʾ
HTMLµÄÓï·¨¼ì²é
HTMLÔ¤ÀÀ
ÔÚ±à¼HTML»ÃæÊ±·Ç³£ÓÐÓÃ.
Crescent EveÊǷdz£Ð¡µÄÒ»¸ö±à¼Æ÷,²Ù×÷Ò²·Ç³£¼ò ......
string str = a.ToString();
str = Regex.Replace(str, @"</?span[^>]*>", "", RegexOptions.IgnoreCase);
str = Regex.Replace(str, @"&#[^>]*;", "", RegexOptions.IgnoreCase);
str = Regex.Replace(str, @"</?marquee[^>]*>", "", RegexOptions.IgnoreCase);
str = Regex.Replace(str, ......
<%@ page contentType="text/html;charset=GBK"%>
<%@page import="java.util.*"%>
<%@page import="java.io.*" %>
<%
//ÔÚÕâÀïÈç¹ûд³É“WEB-INF\templates\template.htm”³ÌÐò»á±¨´í
String filePath = request.getRealPath("/")+"WEB-INF/templates/template.htm"; &nbs ......
WEB·þÎñÆ÷¿Ø¼þÊÇHTML¿Ø¼þµÄÒ»ÖÖÀ©Õ¹,Çø±ðÊÇ:
1)ǰÕß¿ÉÒÔ´¥·¢·þÎñÆ÷¿Ø¼þÌØÓеÄʼþ£¬ºóÕßÖ»ÄÜͨ¹ý»ØµÝµÄ·½Ê½´¥·¢·þÎñÆ÷ÉϵÄÒ³Ãæ¼¶Ê¼þ¡£
2)ÊäÈ뵽ǰÕßÖеÄÊý¾ÝÔÚÇëÇóÖ®¼ä¿ÉÒÔά»¤£¨¼´¾ßÓÐ״̬¹ÜÀí¹¦ÄÜ£©,¶øºóÕßÎÞ·¨×Ô¶¯Î¬»¤Êý¾Ý£¬Ö»ÄÜʹÓÃÒ³Ãæ¼¶µÄ½Å±¾À´±£´æºÍ»Ö¸´¡£
3)ǰÕß¿ÉÒÔ×Ô¶¯¼ì²âä¯ÀÀÆ÷²¢µ÷Õûµ½Ç¡µ±µÄÏÔʾ£¬¶øº ......