When exporting tree to excel, '-' character is attached.

[tbum]

I have two questions. Please help.

First, when exporting tree to excel, a '-' character is appended.
Can you change this character to another character?

The second is to create a function that expands only to level 2 nodes among all nodes in the tree and collapses below that level. Which method is the best way? Wouldn't it be better to collapse all nodes and then use expandTo to show level 2?

Code: [Select]


  datagrid = this.getData();
                            var target = 2;
                            var targetLevel = target -1;
                            var targetItem = [];
                            $.each(datagrid,function(i,v){
                                if(targetLevel > v.pq_level){
                                    targetItem.push(v);
                                }
                            });


                            var tree = this.Tree();
                            tree.collapseAll();
                            if(targetItem.length > 0){
                                tree.expandNodes(targetItem);
                            }


[paramvir]

1. use eachCell method of pq.excel to iterate over all cells in worksheet and update cell values.

Code: [Select]

listener: function() {
var w = this.exportExcel({ workbook: true, render: true });
pq.excel.eachCell(w.sheets, function( cell, ci, ri, si ){
//do something with each cell.
if(cell.value && cell.value[0]=="-"){
var matches = cell.value.match(/^((-\s)+)(.*)/);
cell.value = "+ ".repeat( matches[1].length ) + matches[3];
}
});
var blob = pq.excel.exportWb({ workbook: w, type: 'blob' });
    saveAs(blob, "pqGrid.xlsx" );
}

https://paramquery.com/pro/api#method-eachCell


2. Looking into it.

[paramvir]

Regarding 2nd question, your logic is correct.

If you want to do that during initialization of treegrid, then you can use pq_close property of a node to initialize open / close property of a node.