Changeset 297 for trunk/grails-app/taglib

Timestamp:

Mar 22, 2010, 2:18:30 PM (13 years ago)

Author:

tabma

Message:

• imported data is now being saved in the database (be sure that you choose the correct fieldtypes anywhere/anytime when testing with the Study Excel file)

File:

• trunk/grails-app/taglib/dbnp/importer/ImporterTagLib.groovy (modified) (2 diffs)

trunk/grails-app/taglib/dbnp/importer/ImporterTagLib.groovy

@@ -17 +17 @@
 import dbnp.studycapturing.Template
 import dbnp.studycapturing.TemplateFieldType
+import org.apache.poi.hssf.usermodel.HSSFCell
+import org.apache.poi.ss.usermodel.DataFormatter
 
 class ImporterTagLib {
@@ -160 +162 @@
         out << res
     }
+
+    /**
+    * @param cell HSSFCell variable
+    * @return good representation of variable (instead of toString())
+    */
+    def displayCell = { attrs ->        
+        def cell = attrs['cell']
+        def df = new DataFormatter()
+
+        switch (cell.getCellType()) {
+            case HSSFCell.CELL_TYPE_STRING      :   out << cell.getStringCellValue()
+                                                    break
+            case HSSFCell.CELL_TYPE_NUMERIC     :   out << df.formatCellValue(cell)
+                                                    break
+        }
+    }
 }