java poi对excel处理用jsp显示处理(一)

package cn.hnedu.util;

import java.io.File;
import java.io.FileInputStream;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Collections;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

import oracle.net.aso.r;

import org.apache.openjpa.lib.conf.StringValue;
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.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
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;

import bsh.org.objectweb.asm.Label;

/**
* poi-3.7
*
* @author Administrator
*
*/
public class ExcelUtils {

public ExcelUtils() {

}

private int sumWidth;

public static void main(String args[]) {
ExcelUtils eu = new ExcelUtils();
// String filepath="E:\myproject\eipplugin\test.xls";
String filepath = "D:\1.xls";
HSSFWorkbook workbook = eu.readExcelFile(filepath);
String exceltitle = eu.getFirstRowContent(workbook, 0);
// System.out.println(exceltitle);
// StringBuffer htmlsource=eu.excelToHtmlSource(workbook, 0);
StringBuffer htmlsource = eu.excelToHtmlJs(workbook, 0);
StringBuffer htmlbuf = new StringBuffer("");
htmlbuf.append(eu.headerHtmlStart(exceltitle));

htmlbuf.append(htmlsource);

htmlbuf.append(eu.headerHtmlEnd());

// htmlbuf.append(eu.excelToHtmlSource(workbook, 0));

htmlbuf.append(eu.bodyHtml());
htmlbuf.append(eu.bodyHtmlEnd());

try {
FileUtils.writeFile("E:\excel\小学\excel3.html", htmlbuf);
} catch (Exception e) {
e.printStackTrace();
}
// System.out.println(htmlsource);
}

public StringBuffer headerHtmlStart(String title) {
StringBuffer sb = new StringBuffer("");
sb.append(" ");
sb.append(" ");
sb
.append(" ");
sb.append(" ");
sb
.append(" ");
sb.append(" ");

sb.append(" ");
// sb.append(" ");
sb.append("<SCRIPT type="text/java script" src="js/jquery-1.3.2.min.js"> ");
sb.append("<script type="text/java script" src="js/scripts-pack.js"> ");
sb.append("<script type="text/java script" src="js/jquery-ui-1.7.2.custom.min.js"> ");
sb.append("<script type="text/java script" src="js/jquery.chromatable.js"> ");
return sb;
}

public StringBuffer headerHtmlEnd() {
StringBuffer sb = new StringBuffer("");
sb.append(" ");
sb.append(" ");// 进入页面就刷新下

return sb;
}

public StringBuffer bodyHtml() {
StringBuffer sb = new StringBuffer("");
sb.append("查看全部结果 ");
sb.append("
");
sb.append("

sb.append("

public StringBuffer bodyHtml(HSSFWorkbook workbook, int sheetindex) {
int trwidth = this.getTrWidth(workbook, sheetindex);
StringBuffer sb = new StringBuffer(""