Changeset 18 for trunk/grails-app/services/nl/tno/metagenomics/SampleExcelService.groovy

Timestamp:

Mar 8, 2011, 11:59:30 AM (13 years ago)

Author:

robert@…

Message:

Fixed issue #11: export of excel sample data is now column wise

File:

• trunk/grails-app/services/nl/tno/metagenomics/SampleExcelService.groovy (modified) (2 diffs)

trunk/grails-app/services/nl/tno/metagenomics/SampleExcelService.groovy

@@ -304 +304 @@
                 }
                 
+                // Transpose data and create new headers
+                data = data.transpose();
+                
+                // Add field names in front of the data
+                for( int i = 0; i < data.size(); i++ ) {
+                        data[ i ] = [] + fields[ "descriptions" ][ "all" ][ i ] + data[ i ]
+                }
+                
                 // Create excel file
                 def sheetIndex = 0;
@@ -311 +319 @@
 
                 // Put the headers on the first row
-                excelService.writeHeader( wb, fields[ "descriptions" ][ "all" ], sheetIndex );
-                excelService.writeData( wb, data, sheetIndex, 1 );
+                //excelService.writeHeader( wb, data[ 0 ], sheetIndex );
+                excelService.writeData( wb, data, sheetIndex, 0 );
 
                 // Auto resize columns