如何通过html表格值来优化表格单元格 [英] how to pass html table values to excel sheet cells

问题描述

function toExcel(tableID)
{    
    var detailsTable = document.getElementById(tableID);
    var oExcel = new ActiveXObject("Scripting.FileSystemObject");
    var oBook = oExcel.Workbooks.Add;
    var oSheet = oBook.Worksheets(1);
    for (var y=0;y<detailsTable.rows.length;y++)
    {
        for (var x=0;x<detailsTable.rows(y).cells.length;x++)
        {
            oSheet.Cells(y+1,x+1) =detailsTable.rows(y).cells(x).innerText;
        }
    }
    oExcel.Visible = true;
    oExcel.UserControl = true;
} 

推荐答案

<script language="javascript">
function runApp()
{
        var Excel, Book;
        var x=myTable.rows;
        Excel = new ActiveXObject("Excel.Application");
        Excel.Visible = true;
        Book = Excel.Workbooks.Add();
        for (i = 0; i < x.length; i++)
        {
            var y = x[i].cells;
            for (j = 0; j < y.length; j++)
            {
                Book.ActiveSheet.Cells( i+1, j+1).Value = y[j].innerText;
            }
        }
}
</script>

HTML代码

<table id="myTable">
    ....
</table>
<form>
   <input type="button" onclick="runApp()" value="Export">
</form>

这应该可以胜任。

这篇关于如何通过html表格值来优化表格单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！