function TXLManager($table){
    var $this = this;
    $this.$table = $table;
 
    if(typeof window.jQuery == 'undefined')
        throw "TXLManager Error - jQuery must be required!"
 
    $this.addTopRowInTable = function(data, style, colspan){
        if(data == null) data = "";
        var css = {
            border: "0",
            background: "inherit"
        };
        if(style && !style.length){
            $.each(Object.keys(style), function(index, key){
                css[key] = style[key];
            });
        }
        if(typeof data != "string" && data.length){
            if((style && !style.length) || typeof style == "string")
                throw "Cannot use style of object type with multiple data!";
            else if(style && data.length != style.length)
                throw "Missmatched style array! style.length must equals to data.length!";
            else if((colspan && !colspan.length) || typeof colspan == "string")
                throw "Cannot use colspan of object type with multiple data!";
            else if(colspan && data.length != colspan.length)
                throw "Missmatched colspan array! colspan.length must equals to data.length!";
        }
        var tr = $this.$table.find("tbody tr");
        if(tr.length){
            var $tr = $(tr[0]);
            var cols = $tr.children("td");
            if(!cols) return false;
            cols = cols.length;
 
            var $newTr = $("<tr/>");
            if(typeof data != "string" && data.length){
                $.each(data, function(index, data){
                    var tmpCSS = {};
                    $.each(Object.keys(css), function(idx, key){
                        tmpCSS[key] = css[key];
                    });
                    $.each(Object.keys(style[index]), function(idx, key){
                        tmpCSS[key] = style[index][key];
                    });
                    var $newTd = null;
                    if(colspan)
                        $newTd = $("<td/>", { colspan: colspan[index] });
                    else $newTd = $("<td/>");
                    $newTd.text(data);
                    $newTd.css(tmpCSS);
                    $newTr.append($newTd);
                });
            }else{
                var $newTd = $("<td/>",{
                    colspan: cols
                });
                $newTd.text(data);
                $newTd.css(css);
                $newTr.append($newTd);
            }
            var html = $newTr.wrap("<div>").parent().html();
            $newTr.unwrap();
            $newTr.remove();
            if($this.$table.children("thead").length){
                $this.$table.children("thead").html(
                    html
                    + $this.$table.children("thead").html()
                    );
            }else{
                $this.$table.children("tbody").html(
                    html
                    + $this.$table.children("tbody").html()
                    );
            }
        }
        return $this;
    }
 
    $this.addLeftColInTable = function(data, style){
        if(data == null) data = "";
        var css = {
            border: "0",
            background: "inherit",
            width: "10px"
        };
        if(style){
            $.each(Object.keys(style), function(index, key){
                css[key] = style[key];
            });
        }
        if($this.$table.find("colgroup").length){
            var $colgroup = $table.children("colgroup");
            var $col = $("<col/>");
            $col.css(css);
            var html = $col.wrap("<div>").parent().html();
            $col.unwrap();
            $col.remove();
            $colgroup.html(html + $colgroup.html());
        }
        if($this.$table.find("thead").length){
            $.each($($this.$table.find("thead")).children("tr"), function(index, tr){
                var $tr = $(tr);
                var $newTd = $("<td>");
                $newTd.text(data);
                $newTd.css(css);
                var html = $newTd.wrap("<div>").parent().html();
                $newTd.unwrap();
                $newTd.remove();
                $tr.html(html + $tr.html());
            });
        }
        if($this.$table.find("tbody").length){
            $.each($($this.$table.find("tbody")).children("tr"), function(index, tr){
                var $tr = $(tr);
                var $newTd = $("<td>");
                $newTd.text(data);
                $newTd.css(css);
                var html = $newTd.wrap("<div>").parent().html();
                $newTd.unwrap();
                $newTd.remove();
                $tr.html(html + $tr.html());
            });
        }
        return $this;
    }
 
    $this.wrapTable = function(data, style){
        if(data == null) data = "";
        var css = {
            border: "0",
            background: "inherit",
            width: "10px"
        };
        if(style){
            $.each(Object.keys(style), function(index, key){
                css[key] = style[key];
            });
        }
        var tr = $this.$table.find("tbody tr");
        if(!tr.length) return;
        var $tr = $(tr[0]);
        var cols = $tr.children("td");
        if(!cols) return false;
        cols = cols.length;
 
        if($this.$table.find("colgroup").length){
            var $colgroup = $table.children("colgroup");
            var $col = $("<col/>");
            $col.css(css);
            $colgroup.append($col);
        }
        if($this.$table.find("thead").length){
            $.each($($this.$table.find("thead")).children("tr"), function(index, tr){
                var $tr = $(tr);
                var $newTd = $("<td>");
                $newTd.text(data);
                $newTd.css(css);
                $tr.append($newTd);
            });
        }
        if($this.$table.find("tbody").length){
            $.each($($this.$table.find("tbody")).children("tr"), function(index, tr){
                var $tr = $(tr);
                var $newTd = $("<td>");
                $newTd.text(data);
                $newTd.css(css);
                $tr.append($newTd);
            });
            var $tbody = $($this.$table.find("tbody")[0]);
            var $newTr = $("<tr/>");
            for(var i = 0; i < cols + 1; i++){
                var $newTd = $("<td>");
                $newTd.text(data);
                $newTd.css({
                    border: "0",
                    background: "inherit"
                });
                $newTr.append($newTd);
            }
            $tbody.append($newTr);
        }
        return $this;
    }
 
    $this.removeAllColumnAt = function(idx){
        var colgroup = $this.$table.find("colgroup col");
        var thead = $this.$table.find("thead tr");
        var tbody = $this.$table.find("tbody tr");
        if(colgroup && colgroup.length && colgroup.length > idx)
            $(colgroup[idx]).remove();
        if(thead && thead.length){
            var tr = $(thead[0]).children("th");
            if(tr && tr.length && tr.length > idx) $(tr[idx]).remove();
        }
        if(tbody && tbody.length){
            $.each(tbody, function(index, tr){
                var td = $(tr).children("td");
                if(td && td.length && td.length > idx) $(td[idx]).remove();
            });
        }
        return $this;
    }
 
    $this.setCSSToTable = function(selector, style){
        var $elements = $($this.$table.find(selector));
        $.each($elements, function(index, element){
            $(element).css(style);
        });
        return $this;
    }
 
    $this.exportTableToExcel = function(filename, splitter){
        var tab_text='<table style="display: none; border: 0; border-collapse:collapse;">';
        var textRange; var j=0;
        tab = $this.$table[0]; // id of table
        for(j = 0 ; j < tab.rows.length ; j++)
            tab_text=tab_text+tab.rows[j].innerHTML+"</tr>";
        tab_text=tab_text+"</table>";
        tab_text= tab_text.replace(/<A[^>]*>|<\/A>/g, "");//remove if u want links in your table
        tab_text= tab_text.replace(/<img[^>]*>/gi,""); // remove if u want images in your table
        tab_text= tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params
        if(splitter) tab_text= tab_text.replace(/<br\s*[\/]?>/gi, splitter);//"\r\n");
 
        var ua = window.navigator.userAgent;
        var msie = ua.indexOf("MSIE ");
 
        if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer
        {
            var userAgent = navigator.userAgent.toLowerCase();
            var ie_Version = parseFloat((userAgent.match(/.*(?:rv|ie)[\/: ](.+?)([ \);]|$)/) || [])[1]);
            if(ie_Version <= 9){
                var txtArea1 = window.open("#", "_blank", "toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no, width=10, height=10, visible=none", '');
                txtArea1.document.open("txt/html","replace");
                txtArea1.document.write(tab_text);
                txtArea1.document.close();
                txtArea1.focus();
                txtArea1.document.execCommand("SaveAs", true, filename + ".xls");
                txtArea1.close();
            } else {
                var uri = 'data:application/vnd.ms-excel;base64,'
                var template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body>{table}</body></html>';
                var ctx = {worksheet: filename || 'Worksheet', table: tab_text};
                var blob = new Blob([TXLManager.utils.format(template, ctx)],
                    {type:"application/vnd.ms-excel;charset=utf-8"});
                window.navigator.msSaveOrOpenBlob(blob, filename + '.xls');
            }
        }
        else{                 //other browser not tested on IE 11
            var uri = 'data:application/vnd.ms-excel,' + encodeURIComponent(tab_text);
            var link = document.createElement("a");
            link.href = uri;
 
            //set the visibility hidden so it will not effect on your web-layout
            link.style = "visibility:hidden";
            link.download = filename + ".xls";
 
            //this part will append the anchor tag and remove it after automatic click
            document.body.appendChild(link);
            link.click();
            document.body.removeChild(link);
        }
 
        return $this;
    };
 
    $this.getHTML = function(){
        var $temp = $("<div/>");
        var html = $this.$table.wrap($temp).parent().html();
        $this.$table.unwrap();
        $temp.remove();
        return html;
    }
 
    return {
        addTopRowInTable: $this.addTopRowInTable,
        addLeftColInTable: $this.addLeftColInTable,
        wrapTable: $this.wrapTable,
        removeAllColumnAt: $this.removeAllColumnAt,
        setCSSToTable: $this.setCSSToTable,
        exportTableToExcel: $this.exportTableToExcel,
        getHTML: $this.getHTML
    };
}
 
TXLManager.utils = {};
TXLManager.utils.base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) };
TXLManager.utils.format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) };