Changeset 203 for trunk/grails-app/services
- Timestamp:
- Feb 18, 2010, 8:10:35 AM (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/grails-app/services/dbnp/importer/ImporterService.groovy
r169 r203 19 19 import org.apache.poi.poifs.filesystem.POIFSFileSystem 20 20 import org.apache.poi.ss.usermodel.DataFormatter 21 21 import dbnp.importer.Column 22 22 23 23 class ImporterService { … … 43 43 def sheet = wb.getSheetAt(sheetindex) 44 44 def datamatrix_start = sheet.getFirstRowNum() + 1 45 def header = [] 45 //def header = [] 46 def header = [:] 46 47 def df = new DataFormatter() 48 47 49 48 50 for (HSSFCell c: sheet.getRow(sheet.getFirstRowNum())) { … … 54 56 switch (c.getCellType()) { 55 57 case HSSFCell.CELL_TYPE_STRING: 56 header .add (columnindex:c.getColumnIndex(), value:df.formatCellValue(c), celltype:datamatrix_celltype);58 header[c.getColumnIndex()] = new dbnp.importer.Column(value:df.formatCellValue(c), type:datamatrix_celltype); 57 59 break 58 60 case HSSFCell.CELL_TYPE_NUMERIC: 59 header .add (columnindex:c.getColumnIndex(), value:df.formatCellValue(c), celltype:datamatrix_celltype);61 header[c.getColumnIndex()] = new dbnp.importer.Column(value:df.formatCellValue(c), type:datamatrix_celltype); 60 62 break 61 63 case HSSFCell.CELL_TYPE_BLANK: 62 header .add (columnindex:c.getColumnIndex(), value:"-", celltype:datamatrix_celltype);64 header[c.getColumnIndex()] = new dbnp.importer.Column(value:df.formatCellValue(c), type:datamatrix_celltype); 63 65 break 64 66 default: 65 header .add (columnindex:c.getColumnIndex(), value:df.formatCellValue(c), celltype:datamatrix_celltype);67 header[c.getColumnIndex()] = new dbnp.importer.Column(value:df.formatCellValue(c), type:datamatrix_celltype); 66 68 break 67 69 }
Note: See TracChangeset
for help on using the changeset viewer.