本文實例講述了java使用POI讀取properties文件並寫到Excel的方法。分享給大家供大家參考。具體實現方法如下：
package com.hubberspot.code;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.util.Enumeration;import java.util.HashMap;import java.util.Iterator;import java.util.Properties;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFCellStyle;import org.apache .poi.hssf.usermodel.HSSFRichTextString;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.hssf.util.HSSFColor;public class ReadWriteXlsProperties { // Create a HashMap which will store the properties HashMap< String, String > propMap = new HashMap< String, String >(); public static void main(String[ ] args) { // Create object of ReadWriteXlsProperties ReadWriteXlsProperties readWriteXlsDemo = new ReadWriteXlsProperties(); // Call method readProperties() it take path to properties file readWriteXlsDemo.readProperties("config.properties"); // Call method writeToExcel() it will take path to excel file readWriteXlsDemo.writeToExcel("test.xls"); } private void readProperties(String propertiesFilePath) { // Create a File object taking in path of properties // file File propertiesFile = new File(propertiesFilePath); / / If properties file is a file do below stuff if(propertiesFile.isFile()) { try { // Create a FileInputStream for loading the properties file FileInputStream fisProp = new FileInputStream(propertiesFile); // Create a Properties object and load // properties key and value to it through FileInputStream Properties properties = new Properties(); properties.load(fisProp); // Create a object of Enumeration and call keys() // method over properties object created above // it will return us back with a Enumeration types Enumeration< Object > keysEnum = properties.keys(); // Looping over the elements of Enumeration while(keysEnum.hasMoreElements()) { // Extracting the key and respective values from it. String propKey = (String) keysEnum.nextElement(); String propValue = (String)properties.getProperty(propKey); // After extracting the key and value from the properties file // we will store the values in a HashMap. propMap.put( propKey.toLowerCase( ).trim(),propValue.toLowerCase().trim()); } // printing the HashMap and closing the file FileInputStream System.out.println("Properties Map ... /n" + propMap); fisProp.close (); } catch(FileNotFoundException e) { e.printStackTrace(); } catch(IOException e) { e.printStackTrace(); } } } private void writeToExcel(String excelPath) { // Create a Workbook using HSSFWorkbook object HSSFWorkbook workBook = new HSSFWorkbook(); // Create a sheet with name "properties" by // the createSheet method of the Workbook HSSFSheet worksheet = workBook.createSheet("Properties"); // Create a row by calling createRow method of the // Worksheet HSSFRow row = worksheet.createRow((short) 0); // Create a cell style by calling createCellStyle() // from the workbook HSSFCellStyle cellStyle = workBook.createCellStyle(); // setting of the foreground and fill pattern by calling methods // of HSSFCellStyle as setFillForegroundColor() and setFillPattern() cellStyle.setFillForegroundColor(HSSFColor.GOLD.index); cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); // Create a HSSFCell from the row object created above HSSFCell cell1 = row.createCell (0); // Setting the value of the cell as the keys by calling // setCellValue() method over the HSSFCell cell1.setCellValue(new HSSFRichTextString("Keys")); // Giving it the style created above. cell1. setCellStyle(cellStyle); HSSFCell cell2 = row.createCell(1); cell2.setCellValue(new HSSFRichTextString("Values")); cell2.setCellStyle(cellStyle); // Create a Iterator and as propMap is a HashMap // it is converted to a HashSet by calling keySet() method // which will return with Set. // Iterator object is pointed to keys of Set Iterator< String > iterator = propMap.keySet().iterator(); // Looping across the elements of Iterator while(iterator.hasNext()) { // Creating a new row from the worksheet // at the last used row + 1 location HSSFRow rowOne = worksheet.createRow(worksheet.getLastRowNum()+1); // Creating two cells in the row at 0 and 1 position. HSSFCell cellZero = rowOne.createCell(0); HSSFCell cellOne = rowOne.createCell(1); // extracting key and value from the map and set String key = (String) iterator.next (); String value = (String) propMap.get(key); // setting the extracted keys and values in the cells cellZero.setCellValue(new HSSFRichTextString(key)); cellOne.setCellValue(new HSSFRichTextString(value)); } try{ FileOutputStream fosExcel =null; // Creating a xls File File fileExcel = new File(excelPath); // Setting the File to FileOutputStream fosExcel = new FileOutputStream(fileExcel); // Writing the contents of workbook to the xls workBook.write (fosExcel); // Flushing the FileOutputStream fosExcel.flush(); // Closing the FileOutputStream fosExcel.close(); }catch(Exception e){ e.printStackTrace(); } }}希望本文所述對大家的java程序設計有所幫助。