Changeset 7820 for lang/scala

Timestamp:

03/12/08 02:01:59 (9 months ago)

Author:

ryugate

Message:

apache/POI.scala

setValue系：既にcellが存在する場合はそれを取得するようにした。

Location:

lang/scala/sandbox/src/jp/ryugate/apache

Files:

• POI.scala (modified) (2 diffs)
• POISpecification.scala (modified) (1 diff)

lang/scala/sandbox/src/jp/ryugate/apache/POI.scala

@@ -97 +97 @@
     }
 
+    def getOrCreate(ci:int) = get(ci) match {                                   // index start from 1
+      case None    => hssf_row.createCell((ci-1).toShort)
+      case Some(v) => v
+    }
+
     def apply(cellnum:int) = get(cellnum) match {
       case None => throw new NoSuchElementException(cellnum + " (Cell not found)")
@@ -118 +123 @@
 
     //--------------------------------------------
-    def setCell(ci:int, value:String, encoding:Short):HSSFCell = {              // index start from 1
-      val cell = hssf_row.createCell((ci-1).toShort)
+    def setCell(ci:int, value:String, encoding:Short):HSSFCell = {
+      val cell = getOrCreate(ci)
       cell.setEncoding(encoding)
       cell.setCellValue(value)

lang/scala/sandbox/src/jp/ryugate/apache/POISpecification.scala

@@ -73 +73 @@
       bk.sheet(1) must notBeNull
       sheet.row(1).setCell(1,"hoge").setCellStyle(style) 
-      sheet.col(2).setCell(2,"piyo").setCellStyle(style)
+      sheet.col(1).setCell(1,"piyo")
       sheet.setCell(3,3,"HOGE").setCellStyle(style)