JS导出Excel
JS :
<script type="text/javascript">
function gethtml() {
var fTableElement, strcell, rows, cols, style, excelstr;
fTableElement = document.getElementById("table1");
excelstr = "<html><head><!--<xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>工作表标题</x:Name><x:WorksheetOptions><x:print><x:ValidPrinterInfo /></x:print></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head>";
excelstr += "<table border='1'>";
//excelstr = "<table border='1'>";
for (i = 0; i < fTableElement.rows.length; i++) {
excelstr += "<tr>";
for (j = 0; j < fTableElement.rows[i].cells.length; j++) {
rows = fTableElement.rows[i].cells[j].rowSpan;
cols = fTableElement.rows[i].cells[j].colSpan;
style = fTableElement.rows[i].cells[j].align;
excelstr += "<td colspan=" + cols + " rowspan=" + rows + " align=" + style + ">";
for (k = 0; k < fTableElement.rows(i).cells(j).children.length; k++) {
if (fTableElement.rows(i).cells(j).children[k].type == undefined || fTableElement.rows(i).cells(j).children[k].type == "") {
excelstr += fTableElement.rows(i).cells(j).children[k].innerText;
}
else {
if (fTableElement.rows(i).cells(j).children[k].type == "text")
{
excelstr += fTableElement.rows(i).cells(j).children[k].value;
}
}
}
if (fTableElement.rows(i).cells(j).children.length == 0) {
excelstr += fTableElement.rows(i).cells(j).innerText;
}
excelstr += "</td>";
}
excelstr += "</tr>";
}
excelstr += "</table></html>";
return excelstr;
}
function XExportToExcel() {
var fHtml = gethtml();
var fSaveWindow = window.open();
fSaveWindow.document.open("text/html", "gb2312");
fSaveWindow.document.write(fHtml);
fSaveWindow.document.execCommand("SaveAs", true, "table.xls");
fSaveWindow.close();
}
</script>
html:
<div>
<table id='table1'>
<tr>
<td>1</td>
<td>ksdj</td>
<td><a href='#'>sds</a></td>
</tr>
<tr>
<td>2</td>
<td>ksdfdssssssssdj</td>
<td>
<asp:Button ID="Button1" runat="server" Text="Button" /></td>
</tr>
<tr>
<td>3</td>
<td>ssss</td>
<td><input type='button' value='按钮'/></td>
</tr>
</table>
</div>
<div>
<input type='button' value="导出" οnclick="XExportToExcel();" />
</div>