Hi .I can not speak English . I use a translator.
I’ll just say the point. We are used to purchase the 3.5 Pro version while you are using the previous dhtmlx3.0 grid.
use the (dhtmlxgrid_export.js) scripts previous versions of excel_export, there is no problem to download.
However, there is an error to use version 3.5 JS file operations such as:
[Fatal Error] :1:1: Content is not allowed in prolog.
org.xml.sax.SAXParseException: Content is not allowed in prolog.
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:249)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:284)
at com.dhtmlx.xml2excel.ExcelXmlParser.setXML(ExcelXmlParser.java:35)
at com.dhtmlx.xml2excel.ExcelWriter.generate(ExcelWriter.java:47)Turning to be downloaded before the script again. However, I think because you can not use the features that have been added, and you want to use a version of the 3.5.
I originally source was used was used as modified as follows.
dhtmlXGridObject.prototype.toPDF=function(url,fileName,chkUse,mode,header,footer,rows){
mode = mode || "color";
var full_color = mode == "full_color";
var grid = this;
grid._asCDATA = true;
eXcell_ch.prototype.getContent = function(){
return this.getValue();
};
eXcell_ra.prototype.getContent = function(){
return this.getValue();
};
function xml_top(profile) {
var spans = [];
for (var i=1; i<grid.hdr.rows.length; i++){
spans[i]=[];
for (var j=0; j<grid._cCount; j++){
var cell = grid.hdr.rows[i].childNodes[j];
if (!spans[i][j])
spans[i][j]=[0,0];
if (cell)
spans[i][cell._cellIndexS]=[cell.colSpan, cell.rowSpan];
}
}
var xml = "<rows profile='"+profile+"'";
if (header)
xml+=" header='"+header+"'";
if (footer)
xml+=" footer='"+footer+"'";
xml+="><head>"+grid._serialiseExportConfig(spans).replace(/^<head/,"<columns").replace(/head>$/,"columns>");
for (var i=2; i < grid.hdr.rows.length; i++) {
var empty_cols = 0;
var row = grid.hdr.rows[i];
var cxml="";
for (var j=0; j < grid._cCount; j++) {
if ((grid._srClmn && !grid._srClmn[j]) || (grid._hrrar[j])) {
empty_cols++;
continue;
}
var s = spans[i][j];
var rspan = (( s[0] && s[0] > 1 ) ? ' colspan="'+s[0]+'" ' : "");
if (s[1] && s[1] > 1){
rspan+=' rowspan="'+s[1]+'" ';
empty_cols = -1;
}
var val = "";
for (var k=0; k<row.cells.length; k++){
if (row.cells[k]._cellIndexS==j) {
if (row.cells[k].getElementsByTagName("SELECT").length)
val="";
else
val = _isIE?row.cells[k].innerText:row.cells[k].textContent;
val=val.replace(/[ \n\r\t\xA0]+/," ");
break;
}
}
if (!val || val==" ") empty_cols++;
cxml+="<column"+rspan+"><![CDATA["+val+"]]></column>";
};
if (empty_cols != grid._cCount)
xml+="\n<columns>"+cxml+"</columns>";
};
xml+="</head>\n";
xml+=xml_footer();
return xml;
};
function xml_body() {
var xml =[];
if (rows)
for (var i=0; i<rows.length; i++)
xml.push(xml_row(grid.getRowIndex(rows[i])));
else
for (var i=0; i<grid.getRowsNum(); i++)
xml.push(xml_row(i));
return xml.join("\n");
}
function xml_footer() {
var xml =["<foot>"];
if (!grid.ftr) return "";
for (var i=1; i < grid.ftr.rows.length; i++) {
xml.push("<columns>");
var row = grid.ftr.rows[i];
for (var j=0; j < grid._cCount; j++){
if (grid._srClmn && !grid._srClmn[j]) continue;
if (grid._hrrar[j]) continue;
for (var k=0; k<row.cells.length; k++){
var val = "";
var span = "";
if (row.cells[k]._cellIndexS==j) {
val = _isIE?row.cells[k].innerText:row.cells[k].textContent;
val=val.replace(/[ \n\r\t\xA0]+/," ");
if (row.cells[k].colSpan && row.cells[k].colSpan!=1)
span = " colspan='"+row.cells[k].colSpan+"' ";
break;
}
}
xml.push("<column"+span+"><![CDATA["+val+"]]></column>");
}
xml.push("</columns>");
};
xml.push("</foot>");
return xml.join("\n");
};
function get_style(node, style){
return (window.getComputedStyle?(window.getComputedStyle(node, null)[style]):(node.currentStyle?node.currentStyle[style]:null))||"";
};
function xml_row(ind){
if (!grid.rowsBuffer[ind]) return "";
var r = grid.render_row(ind);
if (r.style.display=="none") return "";
var xml = "<row>";
for (var i=0; i < grid._cCount; i++) {
if (((!grid._srClmn)||(grid._srClmn[i]))&&(!grid._hrrar[i])){
var cell = grid.cells(r.idd, i);
if (full_color){
var text_color = get_style(cell.cell,"color");
var bg_color = get_style(cell.cell,"backgroundColor");
var bold = get_style(cell.cell, "font-weight") || get_style(cell.cell, "fontWeight");
var italic = get_style(cell.cell, "font-style") || get_style(cell.cell, "fontStyle");
var align = get_style(cell.cell, "text-align") || get_style(cell.cell, "textAlign");
if (bg_color == "transparent" || bg_color == "rgba(0, 0, 0, 0)") bg_color = "rgb(255,255,255)";
xml+="<cell bgColor='"+bg_color+"' textColor='" + text_color + "' bold='" + bold + "' italic='" + italic + "' align='"+align+"'>";
} else
xml+="<cell>";
xml+="<![CDATA["+(cell.getContent?cell.getContent():cell.getTitle())+"]]></cell>";
}
};
return xml+"</row>";
}
function xml_end(){
var xml = "</rows>";
return xml;
}
if (grid._fake){
var st_hr = [].concat(grid._hrrar);
for (var i=0; i < grid._fake._cCount; i++)
grid._hrrar[i]=null;
}
var d=document.createElement("div");
d.style.display="none";
document.body.appendChild(d);
var uid = "form_"+grid.uid();
d.innerHTML = '<form id="'+uid+'" method="post" target="_blank" action="'+url+'" accept-charset="utf-8" enctype="application/x-www-form-urlencoded"><input type="hidden" name="grid_xml" id="grid_xml"/><input type="hidden" name="fileName" id="fileName" value="'+fileName+'"/><input type="hidden" name="chkUse" id="chkUse" value="'+chkUse+'"/> </form>';
document.getElementById(uid).firstChild.value = xml_top(mode).replace("\u2013", "-") + xml_body() + xml_end();
document.getElementById(uid).submit();
d.parentNode.removeChild(d);
if (grid._fake)
grid._hrrar = st_hr;
grid = null;
};
dhtmlXGridObject.prototype._serialiseExportConfig=function(spans){
var out = "<head>";
for (var i = 0; i < this.hdr.rows[0].cells.length; i++){
if (this._srClmn && !this._srClmn[i]) continue;
if (this._hrrar[i]) continue;
var sort = this.fldSort[i];
if (sort == "cus"){
sort = this._customSorts[i].toString();
sort=sort.replace(/function[\ ]*/,"").replace(/\([^\f]*/,"");
}
var s = spans[1][i];
var rpans = (( s[1] && s[1] > 1 ) ? ' rowspan="'+s[1]+'" ' : "")+(( s[0] && s[0] > 1 ) ? ' colspan="'+s[0]+'" ' : "");
out+="<column "+rpans+" width='"+this.getColWidth(i)+"' align='"+this.cellAlign[i]+"' type='"+this.cellType[i] + "' hidden='" + ((this.isColumnHidden && this.isColumnHidden(i)) ? 'true' : 'false')
+"' sort='"+(sort||"na")+"' color='"+(this.columnColor[i]||"")+"'"
+(this.columnIds[i]
? (" id='"+this.columnIds[i]+"'")
: "")+">";
if (this._asCDATA)
out+="<![CDATA["+this.getHeaderCol(i)+"]]>";
else
out+=this.getHeaderCol(i);
var z = this.getCombo(i);
if (z)
for (var j = 0; j < z.keys.length; j++)out+="<option value='"+z.keys[j]+"'>"+z.values[j]+"</option>";
out+="</column>";
}
return out+="</head>";
};
if (window.eXcell_sub_row_grid)
window.eXcell_sub_row_grid.prototype.getContent=function(){ return ""; };
dhtmlXGridObject.prototype.toExcel = dhtmlXGridObject.prototype.toPDF;(I do not remember where did receive a file, I use to add only the parts you want to check the check box and the name of file.)
So wish a quick response. Thanks for reading .bye