Grails 操作Excel

 import jxl.*
import java.io.*
import org.springframework.web.multipart.MultipartHttpServletRequest
import org.springframework.web.multipart.commons.CommonsMultipartFile

 

    def upload ={

     MultipartHttpServletRequest mpr = (MultipartHttpServletRequest)request
     CommonsMultipartFile file = (CommonsMultipartFile) mpr.getFile("file") #获取上传的file

      

    def filename = file.getOriginalFilename()  #检查file的类型
        def fileExtension
        int i = filename.lastIndexOf('.')
        if ((i >-1) && (i < (filename.length() - 1)))
            fileExtension=filename.substring(i + 1)
        else
        {
          redirect(action:list)
          return
        }
        if(!fileExtension.equals('xls'))
        {
          redirect(action:list)
          return
        }

 

        dataBaseService.excelUpload(file.inputStream)

        redirect(action:list)

}

 

   def excelUpload = {fileStream ->        

        Workbook workbook = Workbook.getWorkbook(fileStream) #获取excel中的sheet
        Sheet sheet = workbook.getSheet(0)

        for(int row=1;row<sheet.rows;row++)         

     {

                resName = sheet.getCell(0,row).contents   #注意 这里的0是列 row是行 这是获取第0列的函数 getCell

                .............

        }

}

 

主要用到

import jxl.*
import org.springframework.web.multipart.MultipartHttpServletRequest
import org.springframework.web.multipart.commons.CommonsMultipartFile

 

j'xl是jxl.jar JExcelAPI的库 还有