java获取Excel的导出

import java.io.*;

import org.apache.commons.io.FileUtils;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;



public class POIExceldc {

	public static void main(String[] args) throws IOException {
		//需要解析的文件
		File file=new File("d:/learn/poidr.xls");
		//创建Excel,读取文件内容
		HSSFWorkbook workbook=new HSSFWorkbook(FileUtils.openInputStream(file));
        //第一种方法,获取第一张工作表,名字为sheet0,workbook.getSheet("sheet0")
		//HSSFSheet sheet=workbook.getSheet("sheet0");
		
		 //第二种方法,获取第一张工作表,workbook.getSheet("sheet0")
		HSSFSheet sheet=workbook.getSheetAt(0);
		
		int firstRowNum=0;
		//获取sheet中最后一行行号
		int lastRowNum=sheet.getLastRowNum();
		for (int i=firstRowNum;i<=lastRowNum;i++)
		{
			HSSFRow row=sheet.getRow(i);
			//获取当前行的最后单元格列号
			int lastCellNum=row.getLastCellNum();
			for(int j=0;j<lastCellNum;j++)
			{
				HSSFCell cell=row.getCell(j);
				String value=cell.getStringCellValue();
				System.out.print(value+" ");
			}
			System.out.println();
		}
		
		
	}

}

  

原文地址:https://www.cnblogs.com/wangxiaoqun/p/6347000.html