¶ÁÈ¡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
Ïà¹ØÎĵµ£º
½ñÌ죬×öÏîÄ¿µÄʱºòͻȻ¿´µ½<a target="_blank"></a>Õâ¸ö,¾ÍÍøÉϲéѯÁËÏ ¾ßÌåÈçÏ£¬»¹Ñ§µ½ÆäËû¶îÍâµÄ֪ʶ£¬(*^__^*) ÎûÎû……
targetÊÇ´ò¿ªÁ´½ÓʱÓÃʲôĿ±ê´ò¿ª£¬ÊÇÔÚд°¿ÚÖдò¿ª¾ÍÓÃtarget=_blank£¬ÔÚ¸¸´°¿ÚÖдò¿ª¾ÍÓÃtarget=_parent£¬ÔÚµ±Ç°´°¿ÚÖдò¿ª¾ÍÓÃtarget=_self,
target=_top±íʾÔÚ¶ ......
1¡¢Ð½¨ÖÆ×÷chmÎļþµÄ¹¤³Ì
<1> н¨Ò»¸ö´æ´¢CHM¹¤³ÌºÍÖÆ×÷ÆäÔ´ÎļþµÄÎļþ¼Ð¡£ÃüÃûΪchm¡£
<2> ´ò¿ªHTMLHelp Workshop¡£
<3> н¨Ò»¸öproject¡£
<4> ½«project´æ´¢ÔÚÎļþ¼ÐchmÖС£ProjectÃüÃûΪ£ºhelp¡££¨´ËÃû×ÖÊÇ.chmÎļþµÄÃû×Ö£©¡£
<5> Ñ¡Ôñ±àÒëʱҪÉú³ÉµÄÎļþ¡£ ......
Í¬Ò»ÃæÖеÄÌø×ª ͨ¹ýÃèµã Ö÷ÒªÓõ½ window.location.hash Ö¸¶¨ÃèµãλÖÃ
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Ty ......
¿òÏßÖÆ×÷³£ÓôúÂë
´úÂë
º¬Òå
<table>...</table>
½¨Á¢±í¸ñ£¬ËùÓÐµÄÆäËû±ê¼Ç¶¼ÐèÒªÔڴ˱ê¼ÇÖÐ
<table width=* heigth=*></table>
É趨±í¸ñ¿í¶ÈwidthºÍ¸ß¶Èheight£¬ÊôÐÔÖµ¿ÉÒÔʹÓõãÊý£¬È磺width=50£¬Ò²¿ÉÒÔʹÓðٷֱȣ¬È磺width=50%¡£
<table bgcolor=*></ta ......
À´×Ô£ºhttp://9host.cn/html/20074221602392654.html
×î½üÔÚ¸ãÍøÒ³±à³Ì£¬×ܽáÁËframeset µÄһЩʹÓü¼ÇÉ£¬¹©´ó¼Ò²Î¿¼Å¶£¬»¹ÊÇÏÈÆÊÎöһϿò¼Ü°É£¡
¡ö ¿ò¼Ü±ê¼Ç
¡¡¡¡<FRAMESET> <FRAME>
¡¡¡¡<NOFRAMES>
¡¡¡¡<IFRAME>
¡¡¡¡ÓûÃ÷°×±¾Æª¡¾HTML³¹µ×ÆÊÎö¡¿Ö®±ê¼Ç·ÖÀ࣬Çë¿´ ¡¾±ê¼ÇÒ»ÀÀ¡¿ ......