关于表格导出EXCEL问题,表格单元格里是一个input的text类型,如何实现呢?高手进来看看
<SCRIPT LANGUAGE="javascript">
<!--
function AutomateExcel()
{
// Start Excel and get Application object.
var oXL = new ActiveXObject("Excel.Application");
// Get a new workbook.
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var table = document.all.data;
var hang = table.rows.length;
var lie = table.rows(0).cells.length;
// Add table headers going cell by cell.
for (i=0;i<hang;i++){
for (j=0;j<lie;j++){
oSheet.Cells(i+1,j+1).value = table.rows(i).cells(j).innerText;
}
}
oXL.Visible = true;
oXL.UserControl = true;
}
//-->
</SCRIPT>
<table id="data" border=1 width=100% height=200 bordercolorlight="#000000" bordercolordark="#000000" style="border-collapse: collapse">
<tr>
<td width="20%" height="30">1</td>
<td width="20%" height="30">2</td>
<td width="20%" height="30">3</td>
<td width="20%" height="30">4</td>
<td width="20%" height="30">5</td>
</tr>
<tr>
<td width="20%" height="30">1</td>
<td width="20%" height="30">2</td>
<td width="20%" height="30">3</td>
<td width="20%" height="30">4</td>
<td width="20%" height="30">5</td>
</tr>
</table>
<input type="button" name="out_excel" onclick="AutomateExcel();" value="导出到excel" class="notPrint">
就是说把
<td width="20%" height="30">1</td>
换成
<td width="20%" height="30">><input type="text" size="16" value="1"></td>
小弟没分了,只能跪求.
问题点数：0、回复次数：0Top
