table导出到excel的两种方法

QXHao 2021-08-28 原文

需要下载jquery.table2excel.js插件引用后

<script type="text/javascript" src="<%=request.getContextPath()%>/js/jquery-1.4.2.min.js"></script>

<script src="<%=request.getContextPath()%>/js/jquery.table2excel.js"></script>

jquery

function exportexcel(){

                $("#tableServer").table2excel({

                    exclude: ".noExl",

                    name: "Excel Document Name",

                    filename: "myFileName",

                    exclude_img: true,

                    exclude_links: true,

                    exclude_inputs: true

                });

            }
tableServer 导出table的id  .noExl是不需要导出的标签的class 哪行不需要导出class 加上noExl 
 
js代码
 
function ExportToExcel() {

                var elTable = document.getElementById("tableServer"); //你的tableID

                var oRangeRef = document.body.createTextRange();

                oRangeRef.moveToElementText(elTable);

                oRangeRef.execCommand("Copy");

                try {

                    var appExcel = new ActiveXObject("Excel.Application");

                } catch (e) {

                    alert("If you change your mind, refresh your page  and select \'yes\' to download excel.");

                    return;

                }

                appExcel.Visible = true;

                appExcel.Workbooks.Add().Worksheets.Item(1).Paste();

                appExcel = null;

            }