java 操作Excel简单示例

在使用Java 操作Excel时，首先要引进jxl.jar。

下面这个简单的示例是将Map里的数据写到Excel中。

<pre name="code" class="java">	/**
	 * 
	 * @param datas is that need to fill Excel file
	 * @param file is the excel
	 */
public void writeExcel(Map<String, String> datas,File file ){
		try {
                if(!file.exists()){
                    // Open the xls file if the file is not exist
    	            WritableWorkbook book = Workbook.createWorkbook

(new File("D:\\test.xls"));
    	            // Create  a writeable work sheet.
    	            WritableSheet sheet = book.createSheet("Sheet1", 

0);
    	            // Create lable to add to sheet
    	            // test:Label(column, row, "contents")
    	            Label label1 = new Label(0, 0, "平台");
    	            Label label2 = new Label(1, 0, "品牌");
    	            Label label3 = new Label(2, 0, "销售标题");
    	            Label label4 = new Label(3, 0, "价格");
    	            Label label5 = new Label(4, 0, "月销售数量");
    	            Label label6 = new Label(5, 0, "提货方式");
    	            Label label7 = new Label(6, 0, "有效期");
    	            Label label8 = new Label(7, 0, "积分");
    	            Label label9 = new Label(8, 0, "连接");
    	            sheet.addCell(label1);
    	            sheet.addCell(label2);
    	            sheet.addCell(label3);
    	            sheet.addCell(label4);
    	            sheet.addCell(label5);
    	            sheet.addCell(label6);
    	            sheet.addCell(label7);
    	            sheet.addCell(label8);
    	            sheet.addCell(label9);
    	            int rows = sheet.getRows();
    	            Label labelData1 = new Label(0, rows, datas.get

("platform"));
    	            Label labelData2 = new Label(1, rows, datas.get

("brand"));
    	            Label labelData3 = new Label(2, rows, datas.get

("sales_title"));
    	            Label labelData4 = new Label(3, rows, datas.get

("price"));
    	            Label labelData5 = new Label(4, rows, datas.get

("sales_count"));
    	            Label labelData6 = new Label(5, rows, datas.get

("pickup_way"));
    	            Label labelData7 = new Label(6, rows, datas.get

("period"));
    	            Label labelData8 = new Label(7, rows, datas.get

("tianmao_points"));
    	            Label labelData9 = new Label(8, rows, datas.get

("url"));
    	            sheet.addCell(labelData1);
    	            sheet.addCell(labelData2);
    	            sheet.addCell(labelData3);
    	            sheet.addCell(labelData4);
    	            sheet.addCell(labelData5);
    	            sheet.addCell(labelData6);
    	            sheet.addCell(labelData7);
    	            sheet.addCell(labelData8);
    	            sheet.addCell(labelData9);
    	            //Write data
    	            book.write();
    	            book.close();
                }else{
                      //Get the Workbook if the file is already 

exist
                      Workbook wb = Workbook.getWorkbook(file);
                      //open a copy file, then write content with 

same content with test.xls.    
                     WritableWorkbook book = 

Workbook.createWorkbook(file,wb);
     	            // Get the writeable worksheet
     	            WritableSheet sheet = book.getSheet(0);
     	            int rows = sheet.getRows();
     	            if( rows > 1){
     	            	    Label labelData1 = new Label(0, rows, 

datas.get("platform"));
        	            Label labelData2 = new Label(1, rows, 

datas.get("brand"));
        	            Label labelData3 = new Label(2, rows, 

datas.get("sales_title"));
        	            Label labelData4 = new Label(3, rows, 

datas.get("price"));
        	            Label labelData5 = new Label(4, rows, 

datas.get("sales_count"));
        	            Label labelData6 = new Label(5, rows, 

datas.get("pickup_way"));
        	            Label labelData7 = new Label(6, rows, 

datas.get("period"));
        	            Label labelData8 = new Label(7, rows, 

datas.get("points"));
        	            Label labelData9 = new Label(8, rows, 

datas.get("url"));
        	            sheet.addCell(labelData1);
        	            sheet.addCell(labelData2);
        	            sheet.addCell(labelData3);
        	            sheet.addCell(labelData4);
        	            sheet.addCell(labelData5);
        	            sheet.addCell(labelData6);
        	            sheet.addCell(labelData7);
        	            sheet.addCell(labelData8);
        	            sheet.addCell(labelData9);
        	            // Write data and close the book
        	            book.write();
        	            book.close();
     	            }               	
    	            //System.out.println(sheet.getRows());
                }

	        } catch (Exception e) {
	            System.out.println(e);
	        }
	}

欢迎大家指正。