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);        }}

欢迎大家指正。