xls.java

留学生信息管理系统 我的工程实习的项目

package Xl;

import java.awt.print.Book;
import java.io.FileOutputStream;
import java.io.IOException;

import jxl.Workbook;
import jxl.format.UnderlineStyle;
import jxl.write.WritableFont;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

public class XLS {
	/**导出数据为XLS格式
	* @param fos
	* @param bo
	*/
	public void writeExcelBo(FileOutputStream fos, java.util.Vector ve)
	{
	jxl.write.WritableWorkbook wwb;
	try
	{
	wwb= Workbook.createWorkbook(fos);
	jxl.write.WritableSheet ws= wwb.createSheet("booksheet", 10);
	ws.addCell(new jxl.write.Label(0, 1, "id"));
	ws.addCell(new jxl.write.Label(1, 1, "name"));
	ws.addCell(new jxl.write.Label(2, 1, "password"));
	ws.addCell(new jxl.write.Label(3, 1, "roleid"));

	Book book=new Book[ve.size()];
	for (int i= 0; i < ve.size(); i++)
	{
	book[i]= (Book)ve.get(i);
	ws.addCell(new jxl.write.Label(0, i + 2, "" + book[i].getBookId()));
	ws.addCell(new jxl.write.Label(1, i + 2, book[i].getIsbn()));
	ws.addCell(new jxl.write.Label(2, i + 2, "" + book[i].getPrice()));
	ws.addCell(new jxl.write.Label(3, i + 2, book[i].getBookTitle()));
	ws.addCell(new jxl.write.Label(4, i + 2, book[i].getOldFilename()));
	ws.addCell(new jxl.write.Label(5, i + 2, book[i].getSubTitle()));
	ws.addCell(new jxl.write.Label(6, i + 2, book[i].getWriter()));
	ws.addCell(new jxl.write.Label(7, i + 2, book[i].getTranscribe()));
	ws.addCell(new jxl.write.Label(8, i + 2, "" + book[i].getVersion()));
	ws.addCell(new jxl.write.Label(9, i + 2, book[i].getPublishCity()));
	ws.addCell(new jxl.write.Label(10, i + 2, book[i].getPublisher()));
	ws.addCell(new jxl.write.Label(11, i + 2, book[i].getPublishDate().toString()));
	ws.addCell(new jxl.write.Label(12, i + 2, "" + book[i].getPage()));
	ws.addCell(new jxl.write.Label(13, i + 2, "" + book[i].getHight()));
	ws.addCell(new jxl.write.Label(14, i + 2, book[i].getInstall()));
	ws.addCell(new jxl.write.Label(15, i + 2, book[i].getSeries()));
	ws.addCell(new jxl.write.Label(16, i + 2, book[i].getNotes()));
	ws.addCell(new jxl.write.Label(17, i + 2, book[i].getPrecisnotes()));
	ws.addCell(new jxl.write.Label(18, i + 2, book[i].getSubject()));
	ws.addCell(new jxl.write.Label(19, i + 2, book[i].getCls().replaceAll("_", "")));
	ws.addCell(new jxl.write.Label(20, i + 2, book[i].getUpdatedate().toString()));
	ws.addCell(new jxl.write.Label(21, i + 2, "0"));
	}
	jxl.write.WritableFont wfc=
	new jxl.write.WritableFont(
	WritableFont.ARIAL,
	255,
	WritableFont.BOLD,
	false,
	UnderlineStyle.NO_UNDERLINE,
	jxl.format.Colour.BLACK);
	jxl.write.WritableCellFormat wcfFC= new jxl.write.WritableCellFormat(wfc);
	ws.addCell(new jxl.write.Label(0, 0, "为保证您提交定单的稳定和正确，导入定单时候请勿更改此表格式（请勿更改书目ID,订购本数自行添加！）"));
	wwb.write();
//	关闭Excel工作薄对象
	wwb.close();
	} catch (IOException e)
	{} catch (RowsExceededException e)
	{} catch (WriteException e)
	{}
	}


}