¶ÁÈ¡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
Ïà¹ØÎĵµ£º
<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>
......
½ñÌ죬×öÏîÄ¿µÄʱºòͻȻ¿´µ½<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> Ñ¡Ôñ±àÒëʱҪÉú³ÉµÄÎļþ¡£ ......
<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 ......
¿òÏßÖÆ×÷³£ÓôúÂë
´úÂë
º¬Òå
<table>...</table>
½¨Á¢±í¸ñ£¬ËùÓеÄÆäËû±ê¼Ç¶¼ÐèÒªÔڴ˱ê¼ÇÖÐ
<table width=* heigth=*></table>
É趨±í¸ñ¿í¶ÈwidthºÍ¸ß¶Èheight£¬ÊôÐÔÖµ¿ÉÒÔʹÓõãÊý£¬È磺width=50£¬Ò²¿ÉÒÔʹÓðٷֱȣ¬È磺width=50%¡£
<table bgcolor=*></ta ......