¶ÁÈ¡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
Ïà¹ØÎĵµ£º
¸ñʽ±êÇ©ÊÇǶÌ×ÔÚ<body></body>Ö®Äڵġ£
1.<br>»Ø³µ ±íÊ¾Ç¿ÖÆÐԵĻ»ÐУ¬Êǵ¥¶À±êÇ©¡£
2.<nobr></nobr>²»»»ÐÐ ±íʾÔÚ±ê¼ÇÄÚ²»»»ÐС£ÓÃÓÚ·ÀÖ¹ä¯ÀÀÆ÷½«±êÇ©¶ÔÖеÄÄÚÈÝ×Ô¶¯»»ÐС£
±ÈÈ磺ÎÒÃÇËùдµÄ´úÂë»òÆäËû²»ÄÜ·Ö¿ªµÄ¶«Î÷¡£
3.<wbr></wbr>Ç¿ÖÆ»»ÐÐ ÆäÔÚ<nobr></ ......
Adobe·¢²¼HTML 5¿ª·¢¹¤¾ß »ùÓÚDreamweaver
Adobe¹«Ë¾ÔÚÉÏÖܾÙÐеÄGoogle I/O¿ª·¢Õß´ó»áÉÏ·¢²¼ÁËÃæÏò¿ª·¢ÕߺÍÉè¼ÆÊ¦µÄHTML 5¹¤¾ß×飬Adobe HTML5 Pack¡£
Adobe HTML5 PackÊǶÔAdobe Dreamweaver CS5µÄÀ©Õ¹£¬ÎªAdobe Creative Suite 5 Óû§ÌṩÁ˸ü¶àµÄ´´ÔìÐÔ¹¦ÄÜ¡£Óû§¿ÉÒÔ¸üÇáËɵش´½¨ºÍÓÅ»¯Æä×÷Æ·¡£
&n ......
¿òÏßÖÆ×÷³£ÓôúÂë
´úÂë
º¬Òå
<table>...</table>
½¨Á¢±í¸ñ£¬ËùÓÐµÄÆäËû±ê¼Ç¶¼ÐèÒªÔڴ˱ê¼ÇÖÐ
<table width=* heigth=*></table>
É趨±í¸ñ¿í¶ÈwidthºÍ¸ß¶Èheight£¬ÊôÐÔÖµ¿ÉÒÔʹÓõãÊý£¬È磺width=50£¬Ò²¿ÉÒÔʹÓðٷֱȣ¬È磺width=50%¡£
<table bgcolor=*></ta ......
Django
ÓµÓÐһЩ
±ãÀûµÄÄÚ½¨¹¤¾ß°ïÖúÄãÉú³É³£¼ûµÄ·ÇHTML
ÄÚ
ÈÝ:
RSS/Atom
¾ÛºÏÎļþ
Õ¾µãµØÍ¼ (
Ò»¸öXML
¸ñʽÎļþ,
×î³õÓÉGoogle
¿ª·¢,
ÓÃÓÚ¸øËÑË÷ÒýÇæÌáʾÏßË÷)
»ù´¡:
ÊÓͼºÍMIME
ÀàÐÍ
´ÓÒ»¸öÊÓͼ·µ»ØÒ»¸ö·Ç HTML
ÄÚ
ÈݵĹؼüÊÇÔÚ¹¹ÔìÒ»¸ö HttpResponse
Àà
ʱ,
ÐèÒªÖ¸¶¨ mimetype
²ÎÊý¡£ ͨ
¹ ......
formĬÈϵÄÌá½»·½Ê½ÊÇget,ËùÒԺܶàʱºòÐèÒªÎÒÃÇ×Ô¼ºÖ¸¶¨methodΪpost
ʹÓÃgetµÄʱºò,action=ºóÃæ×Ô¼ºÐ´µÄ²ÎÊýÊÇÎÞ·¨´øµ½·þÎñÆ÷¶ËµÄ,ÇÒget·½Ê½Ìá½»formµÄʱºò,Êǽ«formÖеļüÖµÒÔ²ÎÊýµÄ·½Ê½Æ´µ½urlºóÃæµÄ.
post·½Ê½Ìá½»µÄ±íµ¥ÊÇ¿ÉÒÔ»ñÈ¡actionºóÃæ×Ô¼ºÐ´µÄ²ÎÊýµÄ.
Èç¹û±íµ¥ÖдæÔÚͬÃûµÄÏî,ÎÒÃÇ¿ÉÒÔͨ¹ýrequest.getPa ......