久久久久亚洲AV成人网人人网站,香蕉视频亚洲一级,亚洲av无码日韩av无码网站冲

poi讀excel

試試用POI操作excel囖.
純粹為了自己好找.
要有人看了這些的話,隨意就好啦...歡迎指出不當(dāng)之處.

package?xls;

import?java.io.FileInputStream;

import?java.io.FileNotFoundException;

import?java.io.FileOutputStream;

import?java.io.IOException;

import?java.io.OutputStreamWriter;

import?java.io.UnsupportedEncodingException;

import?java.text.SimpleDateFormat;

import?java.util.ArrayList;

import?java.util.Date;

import?java.util.List;

import?org.apache.poi.hssf.usermodel.HSSFCell;

import?org.apache.poi.hssf.usermodel.HSSFRow;

import?org.apache.poi.hssf.usermodel.HSSFSheet;

import?org.apache.poi.hssf.usermodel.HSSFWorkbook;

public?class?ReadXL

{

????public?static?String?fileName?=?"C:\\xls\\EXCEL.xls";

????public?static?String?path?=?"C:\\xls\\";?//為方便,就這樣寫(xiě)了.

????public?static?void?main(String?argv[])

????{

????????List?list?=?readExcel();

????????String?xmldata?=?buildXML(list);

????????createXMLFile(xmldata);

????}

????/**

?????*?讀取磁盤(pán)上的EXCEL文件的內(nèi)容

?????*?@return?List

?????*/

????public?static?List?readExcel()

????{

????????List?list?=?null;

????????UserBean?ub?=?null;

????????try

????????{

????????????HSSFWorkbook?workbook?=?new?HSSFWorkbook(new?FileInputStream(

????????????????????fileName));?//得到excel對(duì)象

????????????HSSFSheet?sheet?=?workbook.getSheetAt(0);?//得到第一個(gè)sheet

????????????int?rows?=?sheet.getPhysicalNumberOfRows();?//得到行數(shù)

????????????list?=?new?ArrayList();

????????????for?(int?i?=?1;?i?<?rows;?i++)

????????????{

????????????????HSSFRow?row?=?sheet.getRow(i);

????????????????ub?=?new?UserBean();

????????????????HSSFCell?cell?=?row.getCell((short)?0);?//得到列0(下標(biāo)0,為第一列)

????????????????ub.setName(cell.getStringCellValue());

????????????????cell?=?row.getCell((short)?1);?//得到列?1

????????????????ub.setEmail(cell.getStringCellValue());

????????????????cell?=?row.getCell((short)?2);?//得到列2

????????????????ub.setPhone(cell.getStringCellValue());

????????????????cell?=?row.getCell((short)?3);?//得到列3

????????????????ub.setPasswd(cell.getStringCellValue());

????????????????list.add(ub);

????????????}

????????????return?list;

????????}

????????catch?(Exception?e)

????????{

????????????return?null;

????????}

????}

????/**

?????*?組裝xml格式字符串

?????*?@param?list?List

?????*?@return?String

?????*/

????public?static?String?buildXML(List?list)

????{

????????StringBuffer?sb?=?new?StringBuffer();

????????sb.append("<contents-list>\n\t");

????????sb.append("<content>\n\t\t");

????????for?(int?i?=?0;?i?<?list.size();?i++)

????????{

????????????UserBean?bean?=?(UserBean)?list.get(i);

????????????sb.append("<userinfo>\n\t\t\t");

????????????sb.append("<name>"?+?bean.getName()?+?"</name>\n\t\t\t");

????????????sb.append("<email>"?+?bean.getEmail()?+?"</email>\n\t\t\t");

????????????sb.append("<phone>"?+?bean.getPhone()?+?"</phone>\n\t\t\t");

????????????sb.append("<passwd>"?+?bean.getPasswd()?+?"</passwd>\n\t\t");

????????????if?(i?+?1?<?list.size())

????????????{

????????????????sb.append("</userinfo>\n\t\t");

????????????}

????????????else

????????????{

????????????????sb.append("</userinfo>\n\t");

????????????}

????????}

????????sb.append("</content>\n");

????????sb.append("</contents-list>");

????????return?sb.toString();

????}

????/**

?????*?輸出到文件

?????*?@param?xmldata?String

?????*/

????public?static?void?createXMLFile(String?xmldata)

????{

????????String?createTime?=?createTime();

????????String?filename?=?path?+?createTime?+?".xml";

????????OutputStreamWriter?osw?=?null;

????????FileOutputStream?output?=?null;

????????try

????????{

????????????output?=?new?FileOutputStream(filename);

????????????osw?=?new?OutputStreamWriter(output,?"utf-8");

????????????osw.write(xmldata);

????????????osw.flush();

????????}

????????catch?(Exception?ex)

????????{

????????}

????????

????????finally

????????{

????????????try

????????????{

????????????????if?(null?!=?output)

????????????????{

????????????????????output.close();

????????????????}

????????????}

????????????catch?(IOException?ex2)

????????????{

????????????}

????????????try

????????????{

????????????????if?(null?!=?osw)

????????????????{

????????????????????osw.close();

????????????????}

????????????}

????????????catch?(IOException?ex3)

????????????{

????????????}

????????}

????}

????/**

?????*?用時(shí)間作為文件名

?????*?@return?String

?????*/

????public?static?String?createTime()

????{

????????Date?date?=?new?Date();

????????SimpleDateFormat?dateFormat?=?new?SimpleDateFormat("yyyyMMddmmss");

????????String?createTime?=?dateFormat.format(date);

????????return?createTime;

????}

}

再就一個(gè)UserBean,就幾個(gè)屬性.

posted on 2007-12-11 23:28 Jwin 閱讀(2230) 評(píng)論(1) 編輯收藏所屬分類: ioOpr

評(píng)論

# re: poi讀excel 2016-06-14 23:00 Mary james

thank you for the great tutorial.
I recommend this website:
http://how-to-program-in-java.com/
It was really helpful for me. 回復(fù) 更多評(píng)論

新用戶注冊(cè) 刷新評(píng)論列表


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問(wèn) 管理
相關(guān)文章: 下載FTP服務(wù)器文件到本地 poi讀excel

Oo ' Smiling on Java ' oO

常用鏈接

留言簿(1)

隨筆分類

隨筆檔案

收藏夾

Bloggers'

Learning...

Search Engine

搜索

積分與排名

最新隨筆

最新評(píng)論

閱讀排行榜

評(píng)論排行榜

評(píng)論