Changeset 7818

Timestamp:

03/12/08 01:46:20 (5 years ago)

Author:

ryugate

Message:

apache/POI.scala:

MyRow#row?：存在しなければ作って返すようにした。
setCell系を整備（Sheet,Row,Col）

Location:

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

Files:

• POI.scala (modified) (7 diffs)
• POISpecification.scala (modified) (3 diffs)

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

@@ -3 +3 @@
 /**
 * POI wrapper
-* 2008/2/18
+* 2008/3/12
 */
 object POI {
@@ -25 +25 @@
   */
   class MyBook(hssf_book:HSSFWorkbook) {
-    def sheet(index:int  ) = hssf_book.getSheetAt(index-1)
+    def sheet(index:int  ) = hssf_book.getSheetAt(index-1)                      // index start from 1
     def sheet(name:String) = hssf_book.getSheet(name) match {
       case null => throw new NoSuchElementException(name + "(Sheet not found)")
@@ -51 +51 @@
   */
   class MySheet(hssf_sheet:HSSFSheet) {
-    def row(ri:int) = hssf_sheet.getRow(ri-1)
+    def row(ri:Int) = hssf_sheet.getRow(ri-1) match {                           // index start from 1
+      case null => hssf_sheet.createRow(ri-1)
+      case row => row 
+    }
     def col(ci:int) = new Col(this, ci)
 
@@ -77 +80 @@
     def each[V](f:HSSFRow => V) = eachRows(0 to getLastRowNum)(f)
     
+    def getLastRowNum = hssf_sheet.getLastRowNum
+
     //--------------------------------------------
-    def createRow(rownum:int) = hssf_sheet.createRow(rownum-1)
-    
-    def getLastRowNum = hssf_sheet.getLastRowNum
+    def setCell(ri:Int, ci:Int, value:String, encoding:Short):HSSFCell = row(ri).setCell(ci, value, encoding)
+    def setCell(ri:Int, ci:Int, value:String):HSSFCell = row(ri).setCell(ci, value)
   }
   implicit def HSSFSheetToExtSheet(sheet:HSSFSheet) = new MySheet(sheet)
@@ -88 +92 @@
   */
   class MyRow(hssf_row:HSSFRow) {
-    def get(cellnum:int) = hssf_row match {
+    def get(cellnum:int) = hssf_row.getCell((cellnum-1).toShort) match {        // index start from 1
       case null => None
-      case _ => hssf_row.getCell((cellnum-1).toShort) match {
-        case null => None
-        case v    => new Some(v)
-      }
+      case v    => new Some(v)
     }
 
@@ -117 +118 @@
 
     //--------------------------------------------
-    def createCell(cellnum:int) = hssf_row.createCell(cellnum.toShort)
-
-    def setCell(cellnum:int, value:String, encoding:Short):HSSFCell = {
-      val cell = hssf_row.createCell(cellnum.toShort)
+    def setCell(ci:int, value:String, encoding:Short):HSSFCell = {              // index start from 1
+      val cell = hssf_row.createCell((ci-1).toShort)
       cell.setEncoding(encoding)
       cell.setCellValue(value)
@@ -152 +151 @@
       
     def each[V](f:HSSFCell => V) = eachCells(0 to sheet.getLastRowNum)(f)
+
+    //--------------------------------------------
+    def setCell(cellnum:int, value:String, encoding:Short):HSSFCell = sheet.row(cellnum).setCell(colIdx, value, encoding)
+    def setCell(cellnum:int, value:String):HSSFCell = sheet.row(cellnum).setCell(colIdx, value)
   }
   

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

@@ -11 +11 @@
   import org.apache.poi.hssf.usermodel.HSSFCell
   import org.apache.poi.hssf.usermodel.HSSFCell._
+  import org.apache.poi.hssf.usermodel.HSSFCellStyle
   
   import java.lang._
   import java.io.FileInputStream
+  import java.io.FileOutputStream
   
   "POI module" should {
@@ -50 +52 @@
       sheet1.cell(100,100) must throwException(new NoSuchElementException)
 
-      sheet1.row(100) must beNull
+      sheet1.row(100) must notBeNull
       sheet1.col(100) must notBeNull
 
@@ -65 +67 @@
     "create and get Sheet" in {
       val bk = new HSSFWorkbook
-      bk.createSheet("test")
+      val style = bk.createCellStyle
+      style.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM)
+
+      val sheet = bk.createSheet("test")
       bk.sheet(1) must notBeNull
-      bk.sheet("hoge") must throwException(new NoSuchElementException)
+      sheet.row(1).setCell(1,"hoge").setCellStyle(style) 
+      sheet.col(2).setCell(2,"piyo").setCellStyle(style)
+      sheet.setCell(3,3,"HOGE").setCellStyle(style)
+
+      bk.write(new FileOutputStream("testdata/testoutput.xls"))
+      
     }