package cn.com.warlock.common2.excel;

import java.io.IOException;
import java.util.List;

import org.apache.commons.lang3.RandomUtils;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

import cn.com.warlock.common2.excel.ExcelPerfModeReader;
import cn.com.warlock.common2.excel.ExcelWriter;
import cn.com.warlock.common2.excel.helper.ExcelBeanHelper;
import cn.com.warlock.common2.excel.model.ExcelMeta;
import cn.com.warlock.common2.excel.model.TitleMeta;

public class ExcelTest {

    /**
     * @param args
     * @throws IOException
     * @throws InvalidFormatException
     */
    public static void main(String[] args) throws InvalidFormatException, IOException {

        List<PersonSalaryInfo> list = new ExcelPerfModeReader("/Users/warlock/Desktop/人员导入模板.xlsx")
                .read(PersonSalaryInfo.class);

        System.out.println(list.get(0));

        //		String excelFilePath = "/Users/ayg/Desktop/test110.xlsx";
        //		ExcelWriter writer = new ExcelWriter(excelFilePath);
        //		writer.write(list, PersonSalaryInfo.class);
        //		writer.close();
        //		System.out.println(excelFilePath);

        //		ExcelMeta excelMeta = ExcelBeanHelper.getExcelMeta(PersonSalaryInfo.class);
        //		// 写标题
        //		for (int i = 1; i <= excelMeta.getTitleRowNum(); i++) {
        //			for (int j = 1; j <= excelMeta.getTitleColumnNum(); j++) {
        //				TitleMeta titleMeta = excelMeta.getTitleMeta(i, j);
        //				System.out.println(i + "-" + j + "-" + (titleMeta == null ? "" : titleMeta.getTitle()));
        //			}
        //		}
    }

}