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())); // } // } } }