1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
/*
Copyright (c) 2004-2011, The Dojo Foundation All Rights Reserved.
Available via Academic Free License >= 2.1 OR the modified BSD license.
see: http://dojotoolkit.org/license for details
*/
if(!dojo._hasResource["dojox.grid.enhanced.plugins.exporter.CSVWriter"]){ //_hasResource checks added by build. Do not use _hasResource directly in your code.
dojo._hasResource["dojox.grid.enhanced.plugins.exporter.CSVWriter"] = true;
dojo.provide("dojox.grid.enhanced.plugins.exporter.CSVWriter");
dojo.require("dojox.grid.enhanced.plugins.exporter._ExportWriter");
dojox.grid.enhanced.plugins.Exporter.registerWriter("csv",
"dojox.grid.enhanced.plugins.exporter.CSVWriter");
dojo.declare("dojox.grid.enhanced.plugins.exporter.CSVWriter",
dojox.grid.enhanced.plugins.exporter._ExportWriter, {
// summary:
// Export grid to CSV format.
_separator: ',',
_newline: "\r\n",
constructor: function(/* object? */writerArgs){
// summary:
// CSV default separator is ','.
// But we can also use our own.
// writerArgs: object?
// {separator:'...'}
if(writerArgs){
this._separator = writerArgs.separator ? writerArgs.separator : this._separator;
this._newline = writerArgs.newline ? writerArgs.newline : this._newline;
}
this._headers = [];
this._dataRows = [];
},
_formatCSVCell: function(/* string */cellValue){
// summary:
// Format cell value to follow CSV standard.
// See: http://en.wikipedia.org/wiki/Comma-separated_values
// tags:
// private
// cellValue: string
// The value in a cell.
// returns:
// The formatted content of a cell
if(cellValue === null || cellValue === undefined){
return '';
}
var result = String(cellValue).replace(/"/g, '""');
if(result.indexOf(this._separator) >= 0 || result.search(/[" \t\r\n]/) >= 0){
result = '"' + result + '"';
}
return result; //String
},
beforeContentRow: function(/* object */arg_obj){
// summary:
// Overrided from _ExportWriter
var row = [],
func = this._formatCSVCell;
dojo.forEach(arg_obj.grid.layout.cells, function(cell){
//We are not interested in indirect selectors and row indexes.
if(!cell.hidden && dojo.indexOf(arg_obj.spCols,cell.index) < 0){
//We only need data here, not html
row.push(func(this._getExportDataForCell(arg_obj.rowIndex, arg_obj.row, cell, arg_obj.grid)));
}
}, this);
this._dataRows.push(row);
//We do not need to go into the row.
return false; //Boolean
},
handleCell: function(/* object */arg_obj){
// summary:
// Overrided from _ExportWriter
var cell = arg_obj.cell;
if(arg_obj.isHeader && !cell.hidden && dojo.indexOf(arg_obj.spCols,cell.index) < 0){
this._headers.push(cell.name || cell.field);
}
},
toString: function(){
// summary:
// Overrided from _ExportWriter
var result = this._headers.join(this._separator);
for(var i = this._dataRows.length - 1; i >= 0; --i){
this._dataRows[i] = this._dataRows[i].join(this._separator);
}
return result + this._newline + this._dataRows.join(this._newline); //String
}
});
}
|
