Grails 操作Excel

来源：互联网发布：中国西方古典音乐知乎编辑：程序博客网时间：2024/05/17 05:57

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的库还有