首页 > 代码库 > groovy : poi 读取 Excel xlsx
groovy : poi 读取 Excel xlsx
下载 poi-bin-3.10-FINAL-20140208.zip 解压后
copy
poi-3.10-FINAL-20140208.jar
poi-ooxml-3.10-FINAL-20140208.jar
poi-ooxml-schemas-3.10-FINAL-20140208.jar
ooxml-lib\dom4j-1.6.1.jar
ooxml-lib\dom4j-1.6.1.jar
ooxml-lib\xmlbeans-2.3.0.jar
to D:\groovy-1.8.9\lib\
read_xlsx.groovy 代码如下
import javax.swing.JFileChooser import javax.swing.filechooser.FileFilter import javax.swing.filechooser.FileNameExtensionFilter import java.io.File; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; class ReadExcel { static void main(args) { def getFilename ={ def initDir='D:/' def chooser=new JFileChooser(initDir) def filter = new FileNameExtensionFilter('Excel', 'xlsx') chooser.setFileFilter(filter) chooser.setDialogTitle("Open") if(chooser.showSaveDialog() == JFileChooser.APPROVE_OPTION) return chooser.getSelectedFile() else if(chooser.showSaveDialog() == JFileChooser.CANCEL_OPTION) return null else return null } def filename = getFilename() as String def outfile = new File(filename.replace('xlsx','txt')); def fp = outfile.newPrintWriter(); println filename XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(filename)); (0..<wb.numberOfSheets).each{ XSSFSheet sheet = wb.getSheetAt(it) int rows = sheet.physicalNumberOfRows println " sheet:\"" + wb.getSheetName(it) + "\" has " + rows + " row(s)." (0..<rows).each{ r -> XSSFRow row = sheet.getRow(r) if (row != null) { int cells = row.physicalNumberOfCells // println "\nROW " + row.rowNum + " has " + cells + " cell(s)." (0..<cells).each{ c -> XSSFCell cell = row.getCell(c) if (cell == null) fp.print '\t'; else if (cell.getCellType() == XSSFCell.CELL_TYPE_BOOLEAN) fp.print cell.getBooleanCellValue()+'\t'; else if (cell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC) fp.print cell.getNumericCellValue()+'\t'; else fp.print cell.getStringCellValue()+'\t'; } fp.println ''; } } } fp.flush(); fp.close(); } }
groovy : poi 读取 Excel xlsx
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。