Index: lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java,v
diff -u -r1.3 -r1.4
--- lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java	28 Oct 2013 14:08:39 -0000	1.3
+++ lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java	5 Jan 2014 16:12:14 -0000	1.4
@@ -140,6 +140,8 @@
 	}
 
 	if (data != null) {
+	    int maxColumnSize = 0;
+	    
 	    // Print data
 	    for (int rowIndex = 0; rowIndex < data.length; rowIndex++) {
 
@@ -148,12 +150,25 @@
 
 		Row row = sheet.createRow(rowIndex + rowIndexOffset);
 
-		for (int columnIndex = 0; columnIndex < data[rowIndex].length; columnIndex++) {
+		int columnSize = data[rowIndex].length;
+		for (int columnIndex = 0; columnIndex < columnSize; columnIndex++) {
 		    ExcelCell excelCell = data[rowIndex][columnIndex];
 		    createCell(excelCell, columnIndex, row);
 		}
+		
+		//calculate max column size
+		if (columnSize > maxColumnSize) {
+		    maxColumnSize = columnSize;
+		}
 	    }
+	    
+	    //autoSizeColumns
+	    for (int i=0; i < maxColumnSize; i++) {
+		sheet.autoSizeColumn(i);
+	    }
+	    
 	}
+	
     }
 
     public static void createCell(ExcelCell excelCell, int cellnum, Row row) {