excelreader.java

《j2ee开发全程实录》随书源码

package com.cownew.PIS.tools.web;

import jxl.Cell;
import jxl.Sheet;

public class ExcelReader
{
	/**
	 * 得到sheet的html表示形式
	 */
	public static String getHTMLSheet(Sheet sheet)
	{
		StringBuffer sb = new StringBuffer();
		sb.append("<table border=1>\n");
		for (int i = 0, n = sheet.getRows(); i < n; i++)
		{
			sb.append("<tr>\n");
			Cell[] cell = sheet.getRow(i);
			for (int j = 0, m = cell.length; j < m; j++)
			{
				String content = cell[j].getContents();
				String text = content.length() <= 0 ? "&nbsp" : content;
				sb.append("<td>").append(text).append("</td>\n");
			}
			sb.append("</tr>\n");
		}
		sb.append("</table>\n");
		return sb.toString();
	}
}