`
收藏列表
标题 标签 来源
Excel读取 excel, poi 
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class Excel {
    public static void main(String args[])
    {   try
    	{
    	File formFile = new File("d:\\test.xls");
    	InputStream is = new FileInputStream(formFile); 
    	HSSFWorkbook workbook = new HSSFWorkbook(is);
    	
    	HSSFSheet sheet = workbook.getSheetAt(0);
        int rows = sheet.getPhysicalNumberOfRows();
        
        for (int r = 0; r <= rows; r++) {
        	HSSFRow row = sheet.getRow(r);
        	if (row != null) 
        	{
        		int cells = row.getPhysicalNumberOfCells();
        		String value = "";
        		for (short c = 0; c < cells; c++) 
        		{
        			HSSFCell cell = row.getCell(c);
        			
        			if (cell != null) 
        			{
						switch (cell.getCellType())
						{
							case HSSFCell.CELL_TYPE_FORMULA:
								value = cell.getStringCellValue();
								break;
							case HSSFCell.CELL_TYPE_NUMERIC:
								if (HSSFDateUtil.isCellDateFormatted(cell)) {
									value = HSSFDateUtil.getJavaDate(
											cell.getNumericCellValue())
											.toLocaleString().substring(0, 10);
								} else {
									value = (long) cell.getNumericCellValue()
											+ "";
								}
								break;
							case HSSFCell.CELL_TYPE_STRING:
								value = cell.getStringCellValue();
								break;
							default:
								value = "";
						}
						
						System.out.println(value);
        			}
        		
        		
        		}
        	}
        }
    	}
        catch(IOException e)
        {
        	e.printStackTrace();
        }
    }
}
Global site tag (gtag.js) - Google Analytics