Agregue la página visitada al sitio confiable
Copiar código del código de la siguiente manera:
// Exportar a Excel, tenga en cuenta que no debe haber comentarios en la marca de la tabla, porque los nodos de los niños contarán las anotaciones en
// Si hay un error, debe cerrar Excel, de lo contrario, el proceso de Excel continuará ejecutándose
// TD solo puede tener un valor de entrada
// No debe haber formación entre no -td, de lo contrario, el informe está faltando ";"
// Página de cita Agregar <script type = "text/javascript" src = "execl.js"> </script>
// Agregar botón <input style = "Height: 26px" type = "button" name = "btnexcel" value = "export Excel" onClick = "exportExcel (this, 'tableenr', '', '')";
// Establecer la ID y la clase de la tabla en Tablenr
function exportExcel (btn, tabid, strcols, stitle, sheader, sfooter) {
// alerta ('SSSS');
btn.style.cursor = "espera";
event.returnValue = false;
//intentar{
var tab = document.getElementById (tabid);
// if (tab == null) tab = document.getElementById ("DG")
// if (tab == null) tab = document.getElementById ("db")
// if (tab == null) tab = document.getElementById (tabid)
if (tab == null) {
Alerta ("falta de objetos de tabla");
btn.style.cursor = "manual";
Devolver;
}
var t = tab.firstchild;
var filas = t.childnodes.length;
// Alerts (T.NodeName);
var tds = t.childnodes [0] .childnodes.length;
var cols = 0;
para (var i = 0; i <tds; i ++) {
var td = t.childnodes [0] .childnodes [i];
if (parseInt (td.colspan)> 1) {
Cols += parseint (td.colspan);
}
demás {
Cols ++;
}
}
intentar {
var oxl = new ActiveXObject ("Excel.Application");
} catch (e) {
alerta ("¡Asegúrese de que Excel esté instalado y permita que Excel se ejecute!");
alerta ("No se puede iniciar Excel, asegúrese de que Excel esté instalado en su computadora!/N/N. Sitio de confianza. DE ACUERDO );
btn.style.cursor = "manual";
Devolver;
}
oxl.workbooks.add ();
var lay = oxl.activeworkbook;
var osheets = obook.worksheets;
var osheet = obook.sheets (1);
var xlrow = 1;
// Agregar el título
if ((stiction == "") || (typeof (stital) == "indefinido") || (stital == null)) {
var t_tdheadc = document.getElementById ("tdheadc");
if (t_tdheadc! = null) {
Stitle = t_tdheadc.inntext;
var sk = stital.lastindexof ("->") +3;
stitle = stitle.substring (sk);
}
}
Osheet.Cells (1, 1) = stitle;
Osheet.Range (Osheet.Cells (Xlrow, 1), Osheet.Cells (xlrow, color).
oxl.selection.horizontalalignment = 3;
oxl.selection.merGeCells = true;
xlrow ++;
//subtitular
Ifader (sheader == "") ||
sheader = "" ;;
}
if (sheader! = "") {{
Osheet.Cells (2, 1) = sheader;
Osheet.Range (Osheet.Cells (Xlrow, 1), Osheet.Cells (xlrow, color).
//oxl.selection.horizontalallyign = 3;
oxl.selection.merGeCells = true;
xlrow ++;
}
var winx = (screen.width -300) / 2;
var winy = (screen.eight - 120) / 2;
var win = window.open ("", "", "directorios = 0, ubicación = 0, memubar = 0, Scrollbars = 0, status = 0, Barra de herramientas = 0, ancho = 230, altura = 75, izquierda =" + winx + ", top =" + winy);
win.document.write ('<html> <title>' + stitle + 'exportar Excel </title> <body> <div ID = "m_pub_wzs_progress_x" style = "Background: White; Overflow: Hidden; Padding-Top: 0 ; Pantalla: Ninguna; Posición: Absolute; Izquierda: 10px; Top: 25px; "> <table id =" m_pub_wzs_progress_tab "border = 0 celular = 1 bgcolor ="#ccccccc "style =" visual ;
Win.document.write ('<trding = 17> <td width = 4 bgcolor = "#000088"> </td> <td width = 4 bgcolor = "#000088"> </td> <td width = 4 bgcolor = "#000088"> </td> <td width = 4 bgcolor = "#000088"> </td> <td width = 4 bgcolor = "#000088"> </td> <td width = 4 bgcolor = "" #000088 "> </td> <td width = 4 bgcolor ="#000088 "> </td> <td width = 4 bgcolor ="#000088 "> </td> <td width = 4 bgcolor ="#000088 "> </td> <td width = 4 bgcolor ="#000088 "> </td> <td width = 4 bgcolor ="#000088 "> </td> <td width = 4 bgcolor ="#000088 "> </td> <td width = 4 bgcolor = "#000088"> </td> <td width = 4 bgcolor = "#000088"> </td> <td width = 4 bgcolor = "#ccccccc"> </<// td> <td width = 4 bgcolor = "#cccccccc"> </td> <td width = 4 bgcolor = "#ccccccc"> </td> <td width = 4 bgcolor = "#cccccc"> </td>> <td width = 4 bgcolor = "#cccccccc"> </td> <td width = 4 bgcolor = "#ccccccc"> </td> <td width = 4 bgcolor = "#cccccc"> </td> <td> width = 4 bgcolor = "#ccccccc"> </td> <td width = 4 bgcolor = "#cccccc"> </td> <td width = 4 bgcolor = "#cccccc"> </td> <td width = 4 bgcolor = "#cccccc"> </td> <td width = 4 bgcolor = "#ccccccc"> </td> <td width = 4 bgcolor = "#cccccc"> </td> <td width = 4 bgcolor = "#Cccccc"> </td> <td width = 4 bgcolor = "#cccccc"> </td> <td width = 4 bgcolor = "#cccccc"> </td> ');
Win.document.write ('</tr> </table> <br> <span id = "m_pub_wzs_progress_percent" style = "font-size: 10pt; vertical-align: middle; color: negro; fon-family: canción estilo "> total ' + filas +' filas, exportado <font id =" sx "color ="#cc0000 "> </font> filas! </span> </div> <br/> <br/> <br/> <br/br/> /> <Br /> <Script Law = "JavaScript"> var osx = document.getElementById ("sx"); ; i ++) {var td = tr.cells [i]; GetElementById ("m_pub_wzs_progress_x");
//win.document.write("<Div style = 'font-size: 10pt; Font-Family: 安'> total " + filas +", exportó <font id = 'sx' color = '#cc0000'> << /font> línea! </div> ");
//win.m_pub_wzs_progress_show (0, filas);
strcols = ","+strcols+",";
var arowspans = new Array ();
para (var i = 0; i <cols; i ++) {
arowspans [i] = 1;
}
var isProgresserr = false;
para (var i = 0; i <shows; i ++) {
//btn.value = i;
if (! isProgresserr) {
intentar {
win.m_pub_wzs_progress_show (filas, i+1);
}
Catch (e) {
isProgresserr = True;
}
}
var fila = t.childnodes [i];
var xlcol = 0;
Var VIWCOL = -1;
var colorx = -1;
var colorpans = 1;
para (var h = 0; h <cols; h ++) {
if (arowspans [h]> 1) {{
xlcol ++;
arowspans [h]-;
VIWCOL ++;
continuar;
}
demás {
Colinx ++;
}
var td = t.childnodes [i] .childnodes [colinx];
if (td == null) continuar;
colspans = td.colspan;
var showspan = td.rowspan;
if (isnan (showspan)) showspan = 1;
para (var k = 0; k <td.colspan; k ++) {
VIWCOL ++;
xlcol ++;
Arowspans [viwcol] = showspan;
}
H+= td.colspan-;
If (td.classname == "Hidenode") {{
xlcol ---;
continuar;
}
var s = "";
If (td.haschildnodes () && td.firstchild.nodename.tologycase () == "entrada") {
if (td.firstchild.type.tologycase () == "texto") {{
s = td.firstchild.value;
}
Más if (td.firstchild.type.tologycase () == "radio") {// Si es un cuadro de selección único, atravesado todo el cuadro de selección única en el cuadro, busque el valor seleccionado
para (var k = 0; k <td.childnodes.length; k ++) {
var cn = td.childnodes [k];
if (cn.nodename.tolowercase () == "input" && cn.type.tolowercase () == "radio" && cn.ecked) {
S = CN.Value;
Romper;
}
}
}
}
demás {
s = td.inntext;
}
if (strcols.indexof ("," + (xlcol-1) + ",")! =-1) {
shell.cells (xlrow, xlcol) .NumberFormatLocal = '@';
}
if (td.rowspan> 1 || td.colspan> 1) {{
shellheet.range (sheet.cells (xlrow, xlcol), sheet.cells (xlrow-1+td.rowspan, xlcol-td.colspan+1)). select ();
oxl.selection.merGeCells = true;
Osheet.Cells (xlrow, xlcol). Horizontalallyignment = 3;
//osheet.cells (i +td.rowspan, xlcol-td.colspan +1).
Osheet.Cells (xlrow, xlcol-td.colspan+1).
} Demás {
Osheet.Cells (xlrow, xlcol).
}
}
xlrow ++;
}
// Agregar la cola
if ((sfooter == "") || (typeof (sfooter) == "subfined") || (sfooter == null) {
sfooter = "";
}
var d = nueva fecha ();
var subuse = "" ;;
if ((window.parent! = null) && (window.parent.parent! = null) {
intentar {
Suser = Window.Parent.Parent.BottomFrame.Document.getElementById ("Labuser").
}
Catch (ex)
}
}
Var sfooterDefault = "Watchman:" + Suser + "Tiempo de tiempo:" + d.getfulfyLear () + "-" + (d.getMound () + 1) + "-" + d.getDate () + "" + d.gethours () +":" +d.getminutes () +":" +d.getSeconds () +"";
Osheet.Cells (xlrow, 1) = sfooterDefault + sfooter;
Osheet.Range (Osheet.Cells (xlrow, 1), Osheet.Cells (xlrow, color).
oxl.selection.merGeCells = true;
Osheet.Range (Osheet.Cells (1, 1), Osheet.Cells (1,1)).
Osheet.columns.autofit ();
para (var i = 1; i <xlrow; i ++) {
Osheet.rows (i) .RowHeight = Osheet.rows (i) .RowHeight + 6;
}
if (! isProgresserr) {// Cierre la barra de progreso
win.close ();
}
oxl.visible = true;
oxl.userControl = true;
oxl = nulo;
Obook = nulo;
Osheets = nulo;
Osheet = nulo;
btn.style.cursor = "manual";
}