<rt id="bn8ez"></rt>
<label id="bn8ez"></label>
  • 

    • <span id="bn8ez"></span>
    

    <label id="bn8ez"><meter id="bn8ez"></meter></label>
    

    
    

    




    







												


        

    
	

    
	
    
		
    
			
				
    Oo ' Smiling on Java ' oO
    
				
    從夢里回來,依然記得夢里有你...
    
			    		
		
    
	
    

    

    
	
    
		
    
			
 
BlogJava ::
首頁 ::
新隨筆 ::
聯系 ::
聚合
 ::
管理 ::


			
			
				

    
	
    
		
    
			
			
			
				 
				8 
				隨筆 ::
				0 文章
				::
				10 評論
				::
				0 Trackbacks
			
		
    
	
    

    

			    		
		
    
	
    

    


    


    
	
					

    
	
	
	
    
		試試用POI操作excel囖.
    純粹為了自己好找.
    要有人看了這些的話,隨意就好啦...歡迎指出不當之處.
    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\\";?//為方便,就這樣寫了.
    ????public?static?void?main(String?argv[])
    ????    {
    ????????List?list?    =?readExcel();
    ????????String?xmldata?    =?buildXML(list);
    ????????createXMLFile(xmldata);
    ????}

    ????    /**
    ?????*?讀取磁盤上的EXCEL文件的內容
    ?????*?    @return?List
    ?????    */
    ????    public?static?List?readExcel()
    ????    {
    ????????List?list?    =?null;
    ????????UserBean?ub?    =?null;
    ????????    try
    ????????    {
    ????????????HSSFWorkbook?workbook?    =?new?HSSFWorkbook(new?FileInputStream(
    ????????????????????fileName));?    //得到excel對象
    ????????????HSSFSheet?sheet?=?workbook.getSheetAt(0);?//得到第一個sheet
    ????????????int?rows?=?sheet.getPhysicalNumberOfRows();?//得到行數
    ????????????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(下標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)
    ????????????    {
    ????????????}
    ????????}
    ????}

    ????    /**
    ?????*?用時間作為文件名
    ?????*?    @return?String
    ?????    */
    ????    public?static?String?createTime()
    ????    {
    ????????Date?date?    =?new?Date();
    ????????SimpleDateFormat?dateFormat?    =?new?SimpleDateFormat("yyyyMMddmmss");
    ????????String?createTime?    =?dateFormat.format(date);
    ????????    return?createTime;
    ????}

    }

    再就一個UserBean,就幾個屬性.
	
    
	
	
    
		posted on 2007-12-11 23:28 Jwin 閱讀(2230) 評論(1)  編輯  收藏  所屬分類: ioOpr 
	
    

    







    
	    
    


    

    
	
    評論
    
		
		
				
    			
					
    
						# 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.  回復  更多評論
						
    
						  
					
    
				
    
				
    
			

    




    





    


    

	
    
		
    
				
		
	
		
    
		
		
    只有注冊用戶登錄后才能發表評論。
    
		
    
			
		
    
			
		
    
		
		
    
		


    

		    		
		
    
		
    			
		
		
		
		
    
		
    
		
		
    
		
    
			網站導航:
		
		
    
		
    
			


		
    	
		
    
			 
		
    
		
    
			
		
    
		
    
			
				
		
    		
	
    	

    



    

				

    




    







    
        
	



主站蜘蛛池模板：
国产99久久久国产精免费
|
日本高清色本免费现在观看|
免费专区丝袜脚调教视频|
日本阿v免费费视频完整版|
成年女人视频网站免费m|
伊人久久综在合线亚洲91|
亚洲欧洲日韩国产综合在线二区|
亚洲成a人片在线观看中文app|
亚洲私人无码综合久久网|
视频一区在线免费观看|
香港a毛片免费观看
|
免费a在线观看播放|
麻豆亚洲AV永久无码精品久久|
亚洲日韩国产二区无码|
18禁超污无遮挡无码免费网站|
久久不见久久见中文字幕免费|
亚洲日韩精品一区二区三区无码
|
国产一区二区视频免费|
亚洲电影免费观看|
国产又黄又爽胸又大免费视频|
亚洲精品动漫免费二区|
亚洲av永久无码精品古装片|
亚洲成av人无码亚洲成av人|
天天影视色香欲综合免费|
亚洲一级毛片免费观看|
国产午夜无码精品免费看|
国产jizzjizz视频免费看|
caoporn国产精品免费|
亚洲A∨无码无在线观看|
中国毛片免费观看|
久久综合亚洲鲁鲁五月天|
永久免费av无码网站yy|
亚洲精品视频免费看|
国产高清视频在线免费观看|
亚洲二区在线视频|
免费人成在线观看69式小视频|
久久亚洲AV成人无码国产最大|
免费做爰猛烈吃奶摸视频在线观看|
男男黄GAY片免费网站WWW|
青青草国产免费久久久91|
亚洲日本在线电影|