¶ÁÈ¡excel£¨POI£©¡¾×ª»»Îªhtml¡¿

package test;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFPalette;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;
public class POIReadExcel {
 
 public static void main(String[] args){
  
  try {
   POIReadExcel poire = new POIReadExcel();
   
   String path = "D:\\test.xls";
   
   File sourcefile = new File(path);
   
   InputStream is = new FileInputStream(sourcefile);
   
   POIFSFileSystem fs = new POIFSFileSystem( is );
   
   HSSFWorkbook wb = new HSSFWorkbook(fs);
   
   System.out.println(poire.getExcelInfo(wb));
   
   is.close();
   
  } catch (Exception e) {
   
   e.printStackTrace();
  }
 }
 
 public String getExcelInfo(HSSFWorkbook wb) throws Exception{
  
  StringBuffer sb = new StringBuffer();
  Sheet sheet = wb.getSheetAt(0);
  
  int lastRowNum = sheet.getLastRowNum();
  
  Map<String,String> map[] = getRowSpanColSpanMap(sheet);
  
  sb.append("<table border='0' cellspacing='1' width='100%'>");
  
  HSSFRow row = null;
  
 &nbs