package?test;

import?java.io.File;
import?java.io.FileInputStream;
import?java.io.FileNotFoundException;
import?java.io.IOException;
import?java.text.DecimalFormat;
import?java.text.SimpleDateFormat;
import?java.util.linkedList;
import?java.util.List;

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;
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;

public?class?ReadExcel?{
	/**
	?*?對外提供讀取excel?的方法
	?*?*/
	public?static?Listject>>?readExcel（File?file）?throws?IOException?{
		String?fileName?=?file.getName（）;
		String?extension?=?fileName.lastIndexOf（“.“）?==?-1???““?:?fileName
				.substring（fileName.lastIndexOf（“.“）?+?1）;
		if?（“xls“.equals（extension））?{
			return?read2003Excel（file）;
		}?else?if?（“xlsx“.equals（extension））?{
			return?read2007Excel（file）;
		}?else?{
			throw?new?IOException（“不支持的文件類型“）;
		}
	}

	/**
	?*?讀取?office?2003?excel
	?*?
	?*?@throws?IOException
	?*?@throws?FileNotFoundException
	?*/
	private?static?Listject>>?read2003Excel（File?file）
			throws?IOException?{
		Listject>>?list?=?new?linkedListject>>（）;
		HSSFWorkbook?hwb?=?new?HSSFWorkbook（new?FileInputStream（file））;
		HSSFSheet?sheet?=?hwb.getSheetAt（0）;
		object?value?=?null;
		HSSFRow?row?=?null;
		HSSFCell?cell?=?null;
		int?counter?=?0;
		for?（int?i?=?sheet.getFirstRowNum（）;?counter?				.getPhysicalNumberOfRows（）;?i++）?{
			row?=?sheet.getRow（i）;
			if?（row?==?null）?{
				continue;
			}?else?{
				counter++;
			}
			Listject>?linked?=?new?linkedListject>（）;
			for?（int?j?=?row.getFirstCellNum（）;?j?<=?row.getLastCellNum（）;?j++）?{
				cell?=?row.getCell（j）;
				if?（cell?==?null）?{
					continue;
				}
				DecimalFormat?df?=?new?DecimalFormat（“0“）;//?格式化?number?String
															//?字符
				SimpleDateFormat?sdf?=?new?SimpleDateFormat（
						“yyyy-MM-dd?HH:mm:ss“）;//?格式化日期字符串
				DecimalFormat?nf?=?new?DecimalFormat（“0.00“）;//?格式化數字
				switch?（cell.getCellType（））?{
				case?XSSFCell.CELL_TYPE_STRING:
					System.out.println（i?+?“行“?+?j?+?“?列?is?String?type“）;
					value?=?cell.getStringCellValue（）;
					break;
				case?XSSFCell.CELL_TYPE_NUMERIC:
					System.out.println（i?+?“行“?+?j
							+?“?列?is?Number?type?;?DateFormt:“
							+?cell.getCellstyle（）.getDataFormatString（））;
					if?（“@“.equals（cell.getCellstyle（）.getDataFormatString（）））?{
						value?=?df.format（cell.getNumericCellValue（））;
					}?else?if?（“General“.equals（cell.getCellstyle（）
							.getDataFormatString（）））?{
						value?=?nf.format（cell.getNumericCellValue（））;
					}?else?{
						value?=?sdf.format（HSSFDateUtil.getJavaDate（cell
								.ge