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

¶ÁÈ¡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ÖÐIDÓëNameµÄÇø±ð2

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

ÈçºÎʹÓÃHTML Help Workshop

ÈçºÎʹÓÃHTML Help Workshop
  ÓÃHTML Help WorkshopÖÆ×÷chmÎļþºÜ·½±ã£¬ÏÂÃæ¾ÍÒÔ“ÖлªËÑË÷±¦CHINASSB”µÄÈí¼þ˵Ã÷ΪÀý£¬½éÉÜÖÆ×÷µÄ¾ßÌå²½Öè¡£
  Ò»¡¢ÖÆ×÷ǰµÄ×¼±¸¹¤×÷
  ÓÉÓÚchm°ïÖúÎļþÊÇ»ùÓÚHTMLÎļþÌØÕ÷µÄ£¬ËùÒÔǰÆÚ±àдHTMLÎļþµÄ×¼±¸¹¤×÷ºÜÖØÒª¡£HTML Help WorkshopµÄ½ÇÉ«¾ÍÏñÊÇÒ»¸ö×ܹ ......

Html Table Ñùʽ


¿òÏßÖÆ×÷³£ÓôúÂë
´úÂë
º¬Òå
<table>...</table>
½¨Á¢±í¸ñ£¬ËùÓÐµÄÆäËû±ê¼Ç¶¼ÐèÒªÔڴ˱ê¼ÇÖÐ
 
 
<table width=* heigth=*></table>
É趨±í¸ñ¿í¶ÈwidthºÍ¸ß¶Èheight£¬ÊôÐÔÖµ¿ÉÒÔʹÓõãÊý£¬È磺width=50£¬Ò²¿ÉÒÔʹÓðٷֱȣ¬È磺width=50%¡£
<table bgcolor=*></ta ......

¹ØÓÚHTMLµÄFormµÄgetºÍpost


formĬÈϵÄÌá½»·½Ê½ÊÇget,ËùÒԺܶàʱºòÐèÒªÎÒÃÇ×Ô¼ºÖ¸¶¨methodΪpost
ʹÓÃgetµÄʱºò,action=ºóÃæ×Ô¼ºÐ´µÄ²ÎÊýÊÇÎÞ·¨´øµ½·þÎñÆ÷¶ËµÄ,ÇÒget·½Ê½Ìá½»formµÄʱºò,Êǽ«formÖеļüÖµÒÔ²ÎÊýµÄ·½Ê½Æ´µ½urlºóÃæµÄ.
post·½Ê½Ìá½»µÄ±íµ¥ÊÇ¿ÉÒÔ»ñÈ¡actionºóÃæ×Ô¼ºÐ´µÄ²ÎÊýµÄ.
Èç¹û±íµ¥ÖдæÔÚͬÃûµÄÏî,ÎÒÃÇ¿ÉÒÔͨ¹ýrequest.getPa ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ