Excel工资单自动发送邮件java实现

package com.niwopay.send; import com.niwopay.framework.email.EmailHandler; import java.io.*; import java.text.MessageFormat; import java.util.ArrayList; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import java.util.Properties; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; public class sendSalary { public static void main(String[] args) throws FileNotFoundException, IOException { Properties prop = new Properties(); InputStream in = new BufferedInputStream(new FileInputStream("mail.properties")); prop.load(new InputStreamReader(in, "utf-8")); String content = prop.getProperty("content"); List list = readExcel(); Iterator it = list.iterator(); while (it.hasNext()) { Map map = (Map)it.next(); String tmpContent = MessageFormat.format(content, new Object[] { map.get("0"), map.get("1"), map.get("2"), map.get("3"), map.get("4"), map.get("5"), map.get("6"), map.get("7"), map.get("8"), map.get("9"), map.get("10"), map.get("11"), map.get("12"), map.get("13"), map.get("14"), map.get("15"), map.get("16"), map.get("17"), map.get("18"), map.get("19"), map.get("20"), map.get("21"),map.get("22"),map.get("23"),map.get("24"),map.get("25"),map.get("26"),map.get("27"),map.get("28"),map.get("29") }); new EmailHandler(((String)map.get("mail")).trim(), ((String)map.get("0")).substring(0, 4) + ((String)map.get("1")).substring(0,2) + "工资单", tmpContent).send(); } } public static List<Map<String, String>> readExcel() throws FileNotFoundException, IOException { Properties prop = new Properties(); InputStream in = new BufferedInputStream(new FileInputStream("mail.properties")); prop.load(new InputStreamReader(in, "utf-8")); String spath = prop.getProperty("filename"); HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(spath)); HSSFSheet aSheet = workbook.getSheetAt(0); int rownum = aSheet.getLastRowNum(); List list = new ArrayList(); for (int i = 1; i <= rownum; i++) { Map map = new HashMap(); if (aSheet.getRow(i).getCell((short)1) != null) { /*map.put("1", aSheet.getRow(i).getCell((short)1).getStringCellValue()); if (aSheet.getRow(i).getCell((short)2).getCellType() == 0) map.put("2", String.valueOf(aSheet.getRow(i).getCell((short)2).getNumericCellValue())); else if (aSheet.getRow(i).getCell((short)2).getCellType() == 1) { map.put("2", aSheet.getRow(i).getCell((short)2).getStringCellValue()); }*/ map.put("0", String.valueOf(aSheet.getRow(i).getCell((short)0).getStringCellValue())); map.put("1", String.valueOf(aSheet.getRow(i).getCell((short)1).getStringCellValue())); map.put("2", String.valueOf(aSheet.getRow(i).getCell((short)2).getStringCellValue())); if (aSheet.getRow(i).getCell((short)2).getCellType() == 0) map.put("3", String.valueOf(aSheet.getRow(i).getCell((short)3).getNumericCellValue())); else if (aSheet.getRow(i).getCell((short)2).getCellType() == 1) { map.put("3", aSheet.getRow(i).getCell((short) 3).getStringCellValue()); } map.put("4", String.valueOf(aSheet.getRow(i).getCell((short)4).getStringCellValue())); map.put("5", String.valueOf(aSheet.getRow(i).getCell((short)5).getNumericCellValue())); map.put("6", String.valueOf(aSheet.getRow(i).getCell((short)6).getNumericCellValue())); map.put("7", String.valueOf(aSheet.getRow(i).getCell((short)7).getNumericCellValue())); map.put("8", String.valueOf(aSheet.getRow(i).getCell((short)8).getNumericCellValue())); map.put("9", String.valueOf(aSheet.getRow(i).getCell((short)9).getNumericCellValue())); map.put("10", String.valueOf(aSheet.getRow(i).getCell((short)10).getNumericCellValue())); map.put("11", String.valueOf(aSheet.getRow(i).getCell((short)11).getNumericCellValue())); map.put("12", String.valueOf(aSheet.getRow(i).getCell((short)12).getNumericCellValue())); map.put("13", String.valueOf(aSheet.getRow(i).getCell((short)13).getNumericCellValue())); map.put("14", String.valueOf(aSheet.getRow(i).getCell((short)14).getNumericCellValue())); map.put("15", String.valueOf(aSheet.getRow(i).getCell((short)15).getNumericCellValue())); map.put("16", String.valueOf(aSheet.getRow(i).getCell((short)16).getNumericCellValue())); map.put("17", String.valueOf(aSheet.getRow(i).getCell((short)17).getNumericCellValue())); map.put("18", String.valueOf(aSheet.getRow(i).getCell((short)18).getNumericCellValue())); map.put("19", String.valueOf(aSheet.getRow(i).getCell((short)19).getNumericCellValue())); map.put("20", String.valueOf(aSheet.getRow(i).getCell((short)20).getNumericCellValue())); map.put("21", String.valueOf(aSheet.getRow(i).getCell((short)21).getNumericCellValue())); map.put("22", String.valueOf(aSheet.getRow(i).getCell((short)22).getNumericCellValue())); map.put("23", String.valueOf(aSheet.getRow(i).getCell((short)23).getNumericCellValue())); map.put("24", String.valueOf(aSheet.getRow(i).getCell((short)24).getNumericCellValue())); map.put("25", String.valueOf(aSheet.getRow(i).getCell((short)25).getNumericCellValue())); map.put("26", String.valueOf(aSheet.getRow(i).getCell((short)26).getNumericCellValue())); map.put("27", String.valueOf(aSheet.getRow(i).getCell((short)27).getNumericCellValue())); map.put("28", String.valueOf(aSheet.getRow(i).getCell((short)28).getNumericCellValue())); map.put("29", String.valueOf(aSheet.getRow(i).getCell((short)29).getNumericCellValue())); map.put("mail", aSheet.getRow(i).getCell((short)30).getStringCellValue()); list.add(map); } } return list; } }