`

java 读取文本、导出excel

阅读更多
    /**
	     * 以行为单位读取文件,常用于读面向行的格式化文件
	     */
	    public static void readFileByLines(String fileName) {
	        File file = new File(fileName);
	        BufferedReader reader = null;
	        try {
	            System.out.println("以行为单位读取文件内容,一次读一整行:");
	            reader = new BufferedReader(new FileReader(file));
	            String tempString = null;
	            int line = 1;
	            // 一次读入一行,直到读入null为文件结束
	            while ((tempString = reader.readLine()) != null) {
	                // 显示行号
	                System.out.println("line " + line + ": " + tempString);
	                line++;
	            }
	            reader.close();
	        } catch (IOException e) {
	            e.printStackTrace();
	        } finally {
	            if (reader != null) {
	                try {
	                    reader.close();
	                } catch (IOException e1) {
	                }
	            }
	        }
	    }

 以上是按行读取文本信息的代码。

 public void toExcel (){
	    	WritableWorkbook book = Workbook.createWorkbook(new File("d:/Test.xls"));  
          
          //create Sheet named "Sheet_1". 0 means this is 1st page.  
	    	WritableSheet sheet = book.createSheet("Sheet_1", 0);  
	    	Label label = new Label(0,line, l1);  
	                //add defined cell above to sheet instance.  
	                sheet.addCell(label);  
                       book.write();  
	              //close file case.  
	              book.close();  
	    }

 以上为 导出 excel代码  (需要 jxl.jar)

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics