展開全部

java查詢出的內容導入到excel表格

/**導出數據為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, "ISBN"));

ws.addCell(new jxl.write.Label(2, 1, "定價"));

ws.addCell(new jxl.write.Label(3, 1, "書名62616964757a686964616fe78988e69d8331333363376464"));

ws.addCell(new jxl.write.Label(4, 1, "原書名"));

ws.addCell(new jxl.write.Label(5, 1, "副題名"));

ws.addCell(new jxl.write.Label(6, 1, "著者"));

ws.addCell(new jxl.write.Label(7, 1, "譯者"));

ws.addCell(new jxl.write.Label(8, 1, "版次"));

ws.addCell(new jxl.write.Label(9, 1, "出版地"));

ws.addCell(new jxl.write.Label(10, 1, "出版社"));

ws.addCell(new jxl.write.Label(11, 1, "出版日期"));

ws.addCell(new jxl.write.Label(12, 1, "頁數"));

ws.addCell(new jxl.write.Label(13, 1, "書高"));

ws.addCell(new jxl.write.Label(14, 1, "裝幀"));

ws.addCell(new jxl.write.Label(15, 1, "叢書名"));

ws.addCell(new jxl.write.Label(16, 1, "一般性附注項"));

ws.addCell(new jxl.write.Label(17, 1, "簡介"));

ws.addCell(new jxl.write.Label(18, 1, "主題詞"));

ws.addCell(new jxl.write.Label(19, 1, "中圖法分類"));

ws.addCell(new jxl.write.Label(20, 1, "更新日期"));

ws.addCell(new jxl.write.Label(21, 1, "本數"));

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)

{}

}

//導入EXCEL

if (f.getName().indexOf(".xls") > 0)

{

try

{

fis= new FileInputStream(f);

BookBean bob= new BookBean();

UserBean usb= new UserBean();

jxl.Workbook rwb= Workbook.getWorkbook(fis);

jxl.Sheet sh= rwb.getSheet(0);

int rowCount= sh.getRows();

SimpleDateFormat sdf= new SimpleDateFormat("dd/MM/yyyy");

book= new Book[rowCount - 1];

for (int i= 1; i < rowCount; i++)

{

book[i - 1]= new Book();

jxl.Cell[] ce= sh.getRow(i);

book[i - 1].setIsbn(ce[0].getContents().toString());

book[i - 1].setSeries(ce[1].getContents().toString());

book[i - 1].setBookTitle(ce[2].getContents().toString());

book[i - 1].setWriter(ce[3].getContents().toString());

book[i - 1].setTranscribe(ce[4].getContents().toString());

book[i - 1].setPublisher(ce[5].getContents().toString());

book[i - 1].setPublishDate(sdf.parse(ce[6].getContents().toString(), new ParsePosition(0)));

book[i-1].setVersion(Integer.parseInt(ce[7].getContents().toString()));

book[i-1].setPage(Integer.parseInt(ce[8].getContents().toString()));

book[i-1].setCls(ce[9].getContents().toString());

book[i-1].setPrecisnotes(ce[10].getContents().toString());

book[i-1].setInstall(ce[11].getContents().toString());

book[i-1].setPrice(Float.parseFloat(ce[12].getContents().toString()));

book[i-1].setUserid(usb.getUser().getUserid());

getVector().addElement(book[i - 1]);

}

rwb.close();

fis.close();

} catch (FileNotFoundException e)

{} catch (BiffException e)

{} catch (IOException e)

{} catch (NumberFormatException e)

{

ShowMessage("數據導入失敗，請按照本軟件要求的EXCEL格式導入定單");

}

}

本回答由提問者推薦

已贊過

已踩過<

你對這個回答的評價是？

評論

收起

總結

以上是生活随笔為你收集整理的用java查询excel表格_如何把java查询出的内容导入到excel表格的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。