js 匯出到excel實例教程

轉自：

儲存到Excel

序列 th> 姓名 年齡 性別 01 張三 18 女孩 02 李四 20 女 &lt ;tr> 03 王五 22 男&lt ;/td> 04 張飛 男 男

/ * * 預設實作轉換函數，如果需要其他功能，則需要自行擴充 * 參數： * tableID : HTML中Table物件id屬性值 * 詳細查看查看以下TableToExcel物件定義 */ function saveAsExcel(tableID) { var tb = new TableToExcel(tableID); tb.setFontStyle("快遞新"); tb.setFontSize(10);## tb.setTableBorder(2); tb.setColumnWidth(7); tb.isLineWrap(true ); tb.getExcelFile();#}## ee ##* 功能：HTML中表格物件轉換為Excel通用物件. * 參數：tableID HTML中表格物件的ID屬性值 * 說明： * 能適應複雜的HTML中Table物件的自動轉換，能夠自動根據行列擴充資訊 * 合併Excel中的儲存格，客戶端需要安裝有Excel * 詳細的屬性、方法參考說明參考：Excel的Microsoft Excel Visual Basic參考 * 示範： * var tb = new TableToExcel('demoTable'); * tb.setFontStyle("快遞新"); * tb.setFontSize(10); //推薦取值10 * tb.setFontColor(6); // 一般情況不用設定 * tb.setBackGround(4); // 一般情況不用設定 * tb.setTableBorder(2); //推薦取值2 * tb.setColumnWidth(10); //推薦取值10 * tb.isLineWrap(false); * tb.isAutoFit(true); * * tb.getExcelFile(); * 如果設定了單元格自適應，則設定儲存格寬度空白 * 版本：1.0 * BUG提交：QQ:18234348或 */ function TableToExcel(tableID) { this.tableBorder = - 1; // 親密類型，-1沒有親密可取1/2/3/4 this.backGround = 0; // 背景顏色：白色可取色盤中的顏色編號 1/2/3/4.... this.fontColor = 1; // 字體顏色：黑色 this.fontSize = 10; // 字體大小 this.fontStyle = "宋體"; // 字型類型 this.rowHeight = -1; //行高 this.columnWidth = -1; //列寬 this.lineWrap = true; // 是否自動換行 this.textAlign = -4108; //內容橫座標預設為居中 this.autoFit = false; // 是否自適應寬度 this.tableID = tableID; }

TableToExcel.prototype.setTableBorder = function (excelBorder) { this.tableBorder = excelBorder; } ;

TableToExcel.prototype.setBackGround = 函數(excelColor) { this.backGround = excelColor; };

TableToExcel.prototype.setColor = 函數(Fontor) { this.fontColor = excelColor; }; #

TableToExcel.prototype.setFontSize = function (#FontSize) { this.fontSize = excelSize;

######################'#################################################################4444}; # ###TableToExcel.prototype.setFontStyle = function (excelFont) {### this.fontStyle = excelFont;###};### TableToExcel.prototype.setRowHeight = 函數 (excelRowHeight) { this.rowHeight = excelRowHeight; #};

TableToExcel.prototype. this.columnWidth = excelColumnWidth; };

TableToExcel.prototype.isLineWrap = function (lineWrap) { if (lineWrap == false || lineWrap == true) {# .lineWrap = lineWrap; } }; #

TableToExcel.prototype.setTextAlign = 函數(textAlign) { this.textAlign = textAlign; }; #}; #};

}; TableToExcel.prototype.isAutoFit = function (autoFit) { if (autoFit == true || autoFit == false) this.autoFit = autoFit; #///1轉換主函數 TableToExcel.prototype.getExcelFile = function () { var jXls, myWorkbook, myWorksheet, myHTMLTableCell, myExcelCell, myExcelCell2; . # # jXls = new ActiveXObject('Excel.Application'); }

catch (e) { alert("無法啟動Excel!\nagen" e. \ n\n如果您確信您的電腦中已經安裝了Excel，「+ 」那麼請調整IE的安全等級。選項→ 安全性→ 自訂等級→ 對沒有標記為安全的ActiveX 進行初始化和腳本執行→ 啟用"); return false; }

jXls.Visible = true; } jXls.Visible = true; } jXls.Visible = true; }

jXls.Visible = true; } jXls.Visible = true; # myWorkbook = jXls.Workbooks.Add(); jXls.DisplayAlerts = false; myWorkbook.Worksheets(3).Delete(); #myWorkbook.Worksheets(3).Delete();

#Delrkbook.Worksheets(2). # jXls.DisplayAlerts = true; myWorksheet = myWorkbook.ActiveSheet;

var readRow = 0，readCol = 0; var totalRow = 0，totalCol = 0 ; 0 ; //設定行高、列寬 if (this.columnWidth != -1) myWorksheet.Columns.ColumnWidth = this.columnWidth;#el myWorksheet .Columns.ColumnWidth = 7; if (this.rowHeight != -1) myWorksheet.Rows.RowHeight = this.rowHeight;##

/ 取得對應行、列數 var obj = document.all.tags("table"); for (x = 0; x if (obj[x].id == this.tableID) { tabNum = x; for (i = 0 ; i myHTMLTableCell = obj[x].rows(0). totalCol =totalCol + myCellColSpan; } 問題## for ( i = 0; i excelTable[i] = new Array(); for (t = 0; t = false; } }

//開始轉換表格 for (z = 0; z readRow = z + 1; readRow = z + 1; # for (c = 0; c myHTMLTableCell = obj[tabNum].rows(z).cells(c);# my = myHTMLTableCell.colSpan; myCellRowSpan = myHTMLTableCell.rowSpan; for (y = 1;# for (y = 1 y readCol = y; , ## if (myCellColSpan * myCellRowSpan > 1) { myEx一個 ell2 = myWorksheet .Cells(readRow + myCellRowSpan - 1, readCol + myCellColSpan - 1); myWorksheet.Range(myExcelCell, mycelCell2). myWorks Cell.Hori zontalAlignment = this.textAlign; myExcelCell.Font .Size = this.fontSize; myExcelCell.Font.Name = this.fontStyle; myExcelCell.Interior.ColorIndex = this.backGround; myExcelCell.Font .ColorIndex = this.fontColor; if (this.tableBorder != -1) { this.tableBorder; myWorksheet.Range (myExcelCell, myExcelCell2).Borders(2).Weight = this.tableBorder; myWorksheet.Range(myExcelCell, myordercelCell2). myWorks myWorksheet.Range( myExcelCell, myExcelCell2 ).Borders(4).Weight = this.tableBorder; }

myExcelCell.Value = myHTMLTableCell.行 for (col = readCol; col } readCol = readCol + myCellColSpan; } else { myColcelCell = myWorksheet。 myExcelCell.Value = myHTMLTableCell.innerText; myExcelCell.HorizontalAlignment = this. textAlign; myExcelCell.Font.Size = this.fontSize; myExcelCell.wrapText = this.lineWrap; myExcelCell.Interior.ColorIndex = 這個。 myExcelCell.Borders(1).Weight = this.tableBorder; myExcelCell。 myExcelCell.Borders(4).Weight = this.tableBorder; } excelTable[readRow][readCol] = true; readCol = readCol + 1; }## true) myWorksheet .Columns. AutoFit;

jXls.UserControl = true; jXls = null; myWorkbook = null; myWorksheet = null; }; ##}; ##}; >

序列 th><br>	姓名	年齡	性別
01	張三	18	女孩
02	李四	20女
03	王五	22	男< ;/td><br>
張飛	男	男