Export DataGrid to CSV

by krishna
February 25, 2009

I was in difficult situation working on exporting datagrid to CSV, Excel, & PDF. The below code works for CSV & MS-Excel.

Later, I will update the code for PDF format..

DataGridExporter.as

package components.grid.export {
import mx.collections.IViewCursor;
import mx.controls.DataGrid;
import mx.controls.dataGridClasses.DataGridColumn;

public class DataGridExporter {

private static var csvSeparator:String = “,”;
private static var lineSeparator:String = “n”;

public static function exportCSV(dg:DataGrid):String {
var columns:Array = dg.columns;
var columnCount:int = columns.length;
var headerGenerated:Boolean = false;
var dataProvider:Object = dg.dataProvider;
var rowCount:int = dataProvider.length;

var cursor:IViewCursor = dataProvider.createCursor ();
var j:int = 0;
var data:String = “”; var header:String = “”;

//loop through rows
while (!cursor.afterLast) {
var obj:Object = cursor.current;
//loop through all columns for the row
for(var k:int = 0; k < columnCount; k++) {
var column:DataGridColumn = columns[k];
//Exclude column data which is invisible (hidden)
if(!column.visible) {
continue;
} // if(!column.visible)

var colData:String = column.itemToLabel(obj);
if (colData.indexOf(“,”) > 0 )
colData = (“””+ colData +”””);

data += colData;

if(k < (columnCount -1)) {
data += csvSeparator;
} // if(k < (columnCount -1))
//generate header of CSV, only if it’s not genereted yet
if (!headerGenerated) {
header += column.headerText;
if (k < columnCount – 1) {
header += csvSeparator;
} // if (k < columnCount – 1)
} // if (!headerGenerated)
} // for(var k:int = 0; k < columnCount; k++)
headerGenerated = true;

if (j < (rowCount – 1)) {
data += lineSeparator;
} // if (j < (rowCount – 1))
j++;
cursor.moveNext ();
}

return (header + lineSeparator + data);
}
}

MXML

private function exportCSV():void {
var csvData:String = DataGridExporter.exportCSV(datagridLoginHistory);
var variables:URLVariables = new URLVariables();
variables.fileData = csvData;
variables.fileName = “LoginHistory.csv”;
var u:URLRequest = new URLRequest(“ExportData.jsp”);
u.data = variables;
u.method = URLRequestMethod.POST;
navigateToURL(u,”_self”);
}

ExportData.JSP

<%@ page language=”java” contentType=”text/html;charset=UTF-8″ pageEncoding=”UTF-8″ %>
<%@page import=”java.io.*”%>
<%
String fileName = request.getParameter(“fileName”);
String fileData = request.getParameter(“fileData”);

response.setContentType(“application/octet-stream”);
response.setHeader(“Content-Disposition”, “attachment;filename=”” + fileName + “””);

try {
int byteLength = fileData.getBytes().length;

ServletOutputStream sos = response.getOutputStream();
InputStream in = new ByteArrayInputStream(fileData.getBytes(“UTF-8”));
byte[] outputByte = new byte[byteLength]; // [4096];
//copy binary contect to output stream
while(in.read(outputByte, 0, byteLength) != -1) {
sos.write(outputByte, 0, byteLength);
}
in.close();
sos.flush();
sos.close();
} catch(IOException e) {
out.println(e.getMessage());
}
%>

I was in difficult situation working on exporting datagrid to CSV, Excel, & PDF. The below code works for CSV & MS-Excel. Later, I will update the code for PDF format.. DataGridExporter.as package components.grid.export { import mx.collections.IViewCursor; import mx.controls.DataGrid; import mx.controls.dataGridClasses.DataGridColumn; public class DataGridExporter { private static var csvSeparator:String = “,”; private static var lineSeparator:String…

February 25, 2009