Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ò³Ãæ±í¸ñµ¼³öµ½excel×ܽá


<table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" align="center">html ±í¸ñµ¼³öµÀExcel</td>
</tr>
<tr>
<td>ÁбêÌâ1</td>
<td>ÁбêÌâ2</td>
......

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

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

ʹÓÃHTML Help WorkshopÖÆ×÷CHM

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

html ʹÓÃJSÔö¼Ó±í¸ñÐÐÐÅÏ¢

<script language="javascript">
   function addItem()
 {
  var oTable = document.getElementById("whtable");
  var oTbody = oTable.tBodies[0];
   var v = oTbody.rows.length;
   oTbody.insertRow(v); 
   oTbody.rows[v].id="itemtr ......

Html Table Ñùʽ


¿òÏßÖÆ×÷³£ÓôúÂë
´úÂë
º¬Òå
<table>...</table>
½¨Á¢±í¸ñ£¬ËùÓеÄÆäËû±ê¼Ç¶¼ÐèÒªÔڴ˱ê¼ÇÖÐ
 
 
<table width=* heigth=*></table>
É趨±í¸ñ¿í¶ÈwidthºÍ¸ß¶Èheight£¬ÊôÐÔÖµ¿ÉÒÔʹÓõãÊý£¬È磺width=50£¬Ò²¿ÉÒÔʹÓðٷֱȣ¬È磺width=50%¡£
<table bgcolor=*></ta ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ