¶ÁÈ¡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
Ïà¹ØÎĵµ£º
ÖÚËùÖÜÖª£¬¶ÔÓÚÁ´½ÓºÍͼƬ£¬ÎÒÃÇ¿ÉÒÔͨ¹ýÌí¼Ótitle
Êô
ÐÔÒÔÏÔʾһЩ˵Ã÷ÎÄ×Ö£¬Ò»°ãÇé¿öÏ£¬ÕâЩÎÄ×Ö¶¼ÊÇÏÔʾ³ÉÒ»ÐУ¬ÄÇôÓÐûÓа취ÈÃËüÒÔ¶àÐеķ½Ê½ÏÔÊ¾ÄØ£¿½â¾öµÄ·½·¨ÓÐÁ½ÖÖ£º
1.½«title
Êô
ÐԷֳɼ¸ÐÐÀ´Ð´£¬ÀýÈ磺
<a href=#" title
="˵Ã÷Ò»
˵Ã÷¶þ
˵Ã÷
Èý">Ó¡ÏóÅÉ</a> ......
¿ÉÒÔ˵¼¸ºõÿ¸ö×ö¹ýWeb¿ª·¢µÄÈ˶¼Îʹý£¬µ½µ×ÔªËØµÄIDºÍNameÓÐÊ²Ã´Çø±ð°¢£¿ÎªÊ²Ã´ÓÐÁËID»¹ÒªÓÐNameÄØ?!
¶øÍ¬ÑùÎÒÃÇÒ²¿ÉÒԵõ½×îclassicalµÄ´ð°¸£ºID¾ÍÏñÊÇÒ»¸öÈ˵ÄÉí·ÝÖ¤ºÅÂ룬¶øName¾ÍÏñÊÇËûµÄÃû×Ö£¬IDÏÔÈ»ÊÇΨһµÄ£¬¶øNameÊÇ¿ÉÒÔÖØ¸´µÄ¡£
nameÔÀ´ÊÇΪÁ˱êʶ֮Ó㬵«ÊÇÏÖÔÚ¸ù¾Ý¹æ·¶£¬¶¼½¨ÒéÓÃidÀ´±êÊ¶ÔªËØ¡£
ÒÔÏÂÖ»ÄÜÓ ......
<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 ......