Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¶ÁÈ¡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


Ïà¹ØÎĵµ£º

htmlÀïtitleÊôÐÔ»»Ðеķ½·¨

ÖÚËùÖÜÖª£¬¶ÔÓÚÁ´½ÓºÍͼƬ£¬ÎÒÃÇ¿ÉÒÔͨ¹ýÌí¼Ótitle
Êô
ÐÔÒÔÏÔʾһЩ˵Ã÷ÎÄ×Ö£¬Ò»°ãÇé¿öÏ£¬ÕâЩÎÄ×Ö¶¼ÊÇÏÔʾ³ÉÒ»ÐУ¬ÄÇôÓÐûÓа취ÈÃËüÒÔ¶àÐеķ½Ê½ÏÔÊ¾ÄØ£¿½â¾öµÄ·½·¨ÓÐÁ½ÖÖ£º
1.½«title
Êô
ÐԷֳɼ¸ÐÐÀ´Ð´£¬ÀýÈ磺
<a href=#" title
="˵Ã÷Ò»
˵Ã÷¶þ
˵Ã÷
Èý">Ó¡ÏóÅÉ</a> ......

target±êÇ©ÊôÐÔµÄÒâÒåºÍÆäËûhtml³£Óñê¼Ç

½ñÌ죬×öÏîÄ¿µÄʱºòͻȻ¿´µ½<a target="_blank"></a>Õâ¸ö,¾ÍÍøÉϲéѯÁËÏ ¾ßÌåÈçÏ£¬»¹Ñ§µ½ÆäËû¶îÍâµÄ֪ʶ£¬(*^__^*) ÎûÎû……
targetÊÇ´ò¿ªÁ´½ÓʱÓÃʲôĿ±ê´ò¿ª£¬ÊÇÔÚд°¿ÚÖдò¿ª¾ÍÓÃtarget=_blank£¬ÔÚ¸¸´°¿ÚÖдò¿ª¾ÍÓÃtarget=_parent£¬ÔÚµ±Ç°´°¿ÚÖдò¿ª¾ÍÓÃtarget=_self,
target=_top±íʾÔÚ¶ ......

HTMLÖÐIDÓëNameµÄÇø±ð2

¿ÉÒÔ˵¼¸ºõÿ¸ö×ö¹ýWeb¿ª·¢µÄÈ˶¼Îʹý£¬µ½µ×ÔªËØµÄIDºÍNameÓÐÊ²Ã´Çø±ð°¢£¿ÎªÊ²Ã´ÓÐÁËID»¹ÒªÓÐNameÄØ?!
¶øÍ¬ÑùÎÒÃÇÒ²¿ÉÒԵõ½×îclassicalµÄ´ð°¸£ºID¾ÍÏñÊÇÒ»¸öÈ˵ÄÉí·ÝÖ¤ºÅÂ룬¶øName¾ÍÏñÊÇËûµÄÃû×Ö£¬IDÏÔÈ»ÊÇΨһµÄ£¬¶øNameÊÇ¿ÉÒÔÖØ¸´µÄ¡£
nameÔ­À´ÊÇΪÁ˱êʶ֮Ó㬵«ÊÇÏÖÔÚ¸ù¾Ý¹æ·¶£¬¶¼½¨ÒéÓÃidÀ´±êÊ¶ÔªËØ¡£
ÒÔÏÂÖ»ÄÜÓ ......

ʹÓÃHTML Help WorkshopÖÆ×÷CHM

 
1¡¢Ð½¨ÖÆ×÷chmÎļþµÄ¹¤³Ì
<1>  Ð½¨Ò»¸ö´æ´¢CHM¹¤³ÌºÍÖÆ×÷ÆäÔ´ÎļþµÄÎļþ¼Ð¡£ÃüÃûΪchm¡£
<2>   ´ò¿ªHTMLHelp Workshop¡£
<3> н¨Ò»¸öproject¡£
<4> ½«project´æ´¢ÔÚÎļþ¼ÐchmÖС£ProjectÃüÃûΪ£ºhelp¡££¨´ËÃû×ÖÊÇ.chmÎļþµÄÃû×Ö£©¡£
<5> Ñ¡Ôñ±àÒëʱҪÉú³ÉµÄÎļþ¡£ ......

Ö÷Á÷ÓÊÏäÄÜÕý³£ÏÔʾµÄHTMLÓʼþµÄ¼¼ÇÉ

¼¸ºõÿ¸ö»áÔ±ÖÆÍøÕ¾¶¼ÐèҪͨ¹ýºǫ́·¢ËÍÓʼþÀ´Óë»áÔ±½øÐйµÍ¨£¬Èç×¢²áÈ·ÈÏ¡¢ÓªÏúÍÆ¹ã¡£ÕâЩÓÉÕ¾·½·¢¸ø»áÔ±µÄÐżþ£¬ÍùÍù´¿Îı¾¸ñʽÒѲ»ÄÜÂú×ã½çÃæºÍ½»»¥µÄÒªÇó£¬ÕâʱºòÎÒÃǾÍÐèÒª·¢ËÍHTMLÒ³Ãæ¡£ÓÉÓÚHTMLÓʼþ²»ÊǶÀÁ¢µÄHOSTÔÚ±¾Õ¾µÄÒ³Ãæ£¬ÊǼÄÈËÀéϵġ£ËùÒÔ±àдHTMLÓʼþÓë±àдHTMLÒ³ÃæÓкܴóµÄ²»Í¬¡£ÒòΪ£¬¸÷ÃæÏòÍøÃñµÄÖ÷Á÷ÓÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ