package?net.virtue.common.fileUtil;

import?java.io.File;
import?java.io.FileInputStream;
import?java.io.IOException;
import?java.lang.reflect.InvocationTargetException;
import?java.text.DecimalFormat;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;
import?org.apache.commons.beanutils.BeanUtils;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.ss.usermodel.Cell;
import?org.apache.poi.ss.usermodel.DataFormatter;
import?org.apache.poi.ss.usermodel.Row;
import?org.apache.poi.ss.usermodel.Sheet;
import?org.apache.poi.ss.usermodel.Workbook;
import?org.apache.poi.xssf.usermodel.XSSFWorkbook;
import?lombok.extern.slf4j.Slf4j;
import?net.virtue.model.DroneAircraft;
@Slf4j
public?class?ExlUtil?{

	/*?解析excel工具類使用方法demo?*/
	public?static?void?main（String[]?args）?{
		File?excelFile?=?new?File（“D://無人機(jī)批量上傳模板?（5）.xlsx“）;
		int?sheetNum?=?0;
		int?startRowNum?=?1;
		int?startColumn?=?0;
		Map?relMap?=?new?HashMap（）;
		relMap.put（0?“serialNumber“）;
		relMap.put（1?“model“）;
		relMap.put（2?“emptyWeight“）;
		relMap.put（3?“maxTaskLoad“）;
		relMap.put（4?“maxTakeOffWeight“）;
		relMap.put（5?“maxCruisingSpeed“）;
		relMap.put（6?“maxEnduranceMileage“）;
		relMap.put（7?“maxEnduranceTime“）;
		relMap.put（8?“manufacturerCode“）;
		try?{
			List?list?=?paserExcel2Obj（excelFilesheetNumstartRowNumstartColumnDroneAircraft.classrelMap）;
			for?（DroneAircraft?droneAircraft?:?list）?{
				System.out.println（droneAircraft）;
			}
			System.out.println（“parse?success“）;
		}?catch?（IllegalAccessException?e）?{
			e.printStackTrace（）;
		}?catch?（InvocationTargetException?e）?{
			e.printStackTrace（）;
		}?catch?（InstantiationException?e）?{
			e.printStackTrace（）;
		}?catch?（IOException?e）?{
			e.printStackTrace（）;
		}
	}
	
	/**
	?*?將excel轉(zhuǎn)化為javaBean
	?*?@param?excelFile?待讀取的excel文件
	?*?@param?sheetNum?sheet頁序號（取值從0開始）
	?*?@param?startRowNum?數(shù)據(jù)起始行號（若第一行為標(biāo)題行，則起始行號為1）
	?*?@param?startColumn?數(shù)據(jù)起始列號（若從第一列開始，則起始列號為0）
	?*?@param?claz?目標(biāo)對象javaBean
	?*?@param?relMap?javaBean的屬性與excel列的對應(yīng)關(guān)系??例：
map.put（0“username“）;?

													????????
map.put（1“password“）;?

	?*?
	?*?@return?List
	?*?@throws?InstantiationException?
	?*?@throws?InvocationTargetException?
	?*?@throws?IllegalAccessException?
	?*?@throws?IOException?
	?*/
	public?static??List?paserExcel2Obj（File?excelFile?int?sheetNum?int?startRowNum?int?startColumn
			Class?claz?Map?relMap）throws?IllegalAccessException?InvocationTargetException?InstantiationException?IOException?{
		List?list?=?new?ArrayList<>（）;

		/*?1、讀入文件?*/
		Workbook?workbook?=?readExcel（excelFile）;

		/*?2、解析excel?*/
		if?（workbook?!=?null）?{
			Sheet?sheet?=?workbook.getSheetAt（sheetNum）;
			int?lastRowNum?=?sheet.getLastRowNum（）;
			list?=?paserSheet2Obj（sheet?startRowNum?startColumn?lastRowNum?cl