¶ÁÈ¡excel£¨JXL£©¡¾Êä³öΪhtml¸ñʽ¡¿
package test;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;
import jxl.Cell;
import jxl.Range;
import jxl.Sheet;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.CellFormat;
import jxl.format.Colour;
import jxl.format.VerticalAlignment;
public class JXLReadExcel {
public static void main(String[] args){
try {
System.out.println(getExcelInfo("D:\\businessStat1.xls"));
//getExcelInfo("D:\\businessStat1.xls");
//getProperties();
//toHexString();
} catch (Exception e) {
e.printStackTrace();
}
}
private static String getExcelInfo(String path) throws Exception{
StringBuffer sb = new StringBuffer();
File sourcefile = new File(path);
InputStream is = new FileInputStream(sourcefile);
Workbook rwb = Workbook.getWorkbook(is);
Sheet sheet = rwb.getSheet(0);
int colnum = sheet.getColumns();
int rownum = sheet.getRows();
Map<String,String> map[] = getRowSpanColSpanMap(sheet);
sb.append("<table border='0' cellspacing='1'>");
for(int row = 0; row < rownum; row ++) {
sb.append("<tr>");
for(int col = 0; col < colnum; col ++) {
Cell cell = sheet.getCell(col, row);
String content = cell.getContents();
&nbs
Ïà¹ØÎĵµ£º
HTMLÓïÑÔÓï·¨´óÈ«
<! - - ... - -> Åú×¢
<!> ÅÜÂíµÆ
<marquee>...</marquee>ÆÕͨ¾í¶¯
<marquee behavior=slide>...</marquee>»¬¶¯
<marquee behavior=scroll>...</marquee>Ô¤Éè¾í¶¯
<marquee behavior=alternate>...</marquee>À´»Ø¾í¶¯
& ......
ÖÚËùÖÜÖª£¬¶ÔÓÚÁ´½ÓºÍͼƬ£¬ÎÒÃÇ¿ÉÒÔͨ¹ýÌí¼Ótitle
Êô
ÐÔÒÔÏÔʾһЩ˵Ã÷ÎÄ×Ö£¬Ò»°ãÇé¿öÏ£¬ÕâЩÎÄ×Ö¶¼ÊÇÏÔʾ³ÉÒ»ÐУ¬ÄÇôÓÐûÓа취ÈÃËüÒÔ¶àÐеķ½Ê½ÏÔÊ¾ÄØ£¿½â¾öµÄ·½·¨ÓÐÁ½ÖÖ£º
1.½«title
Êô
ÐԷֳɼ¸ÐÐÀ´Ð´£¬ÀýÈ磺
<a href=#" title
="˵Ã÷Ò»
˵Ã÷¶þ
˵Ã÷
Èý">Ó¡ÏóÅÉ</a> ......
ÈçºÎʹÓÃHTML Help Workshop
ÓÃHTML Help WorkshopÖÆ×÷chmÎļþºÜ·½±ã£¬ÏÂÃæ¾ÍÒÔ“ÖлªËÑË÷±¦CHINASSB”µÄÈí¼þ˵Ã÷ΪÀý£¬½éÉÜÖÆ×÷µÄ¾ßÌå²½Öè¡£
Ò»¡¢ÖÆ×÷ǰµÄ×¼±¸¹¤×÷
ÓÉÓÚchm°ïÖúÎļþÊÇ»ùÓÚHTMLÎļþÌØÕ÷µÄ£¬ËùÒÔǰÆÚ±àдHTMLÎļþµÄ×¼±¸¹¤×÷ºÜÖØÒª¡£HTML Help WorkshopµÄ½ÇÉ«¾ÍÏñÊÇÒ»¸ö×ܹ ......
À´×Ô£ºhttp://9host.cn/html/20074221602392654.html
×î½üÔÚ¸ãÍøÒ³±à³Ì£¬×ܽáÁËframeset µÄһЩʹÓü¼ÇÉ£¬¹©´ó¼Ò²Î¿¼Å¶£¬»¹ÊÇÏÈÆÊÎöһϿò¼Ü°É£¡
¡ö ¿ò¼Ü±ê¼Ç
¡¡¡¡<FRAMESET> <FRAME>
¡¡¡¡<NOFRAMES>
¡¡¡¡<IFRAME>
¡¡¡¡ÓûÃ÷°×±¾Æª¡¾HTML³¹µ×ÆÊÎö¡¿Ö®±ê¼Ç·ÖÀ࣬Çë¿´ ¡¾±ê¼ÇÒ»ÀÀ¡¿ ......