記得下載 并 導入jxl.jar 包，免積分下載地址：http://download.csdn.net/detail/u010011052/7561041

?

package Test;import java.io.*;import jxl.*; import jxl.format.Colour; import jxl.write.*;public class JXLTest {private static WritableWorkbook book;private static WritableSheet sheet ;private static WritableFont normalFont;private static WritableFont diffFont;private static WritableCellFormat normalFormat;private static WritableCellFormat diffFormat;/*** java創建excel簡單演示樣例*/public static void main(String args[]) {createExcel();}public static void createExcel(){try {String fileNameAndPath = "E:\\DifferentData\\java創建excel文件演示樣例.xls";book = Workbook.createWorkbook(new File(fileNameAndPath));// 生成名為"第一頁"的工作表，參數0表示這是第一頁sheet = book.createSheet("第一頁", 0);// 設置字體為宋體,11號字,不加粗,顏色為紅色normalFont = new WritableFont(WritableFont.createFont("宋體"), 11, WritableFont.NO_BOLD);// 設置字體為宋體,11號字,不加粗,顏色為紅色diffFont = new WritableFont(WritableFont.createFont("宋體"), 11, WritableFont.NO_BOLD);diffFont.setColour(Colour.RED);normalFormat = new WritableCellFormat(normalFont);normalFormat.setAlignment(jxl.format.Alignment.CENTRE);normalFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);diffFormat = new WritableCellFormat(diffFont);diffFormat.setAlignment(jxl.format.Alignment.CENTRE);diffFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);Label labelA = new Label(0, 0, "第一列標題", normalFormat);Label labelB = new Label(1, 0, "第二列標題", normalFormat);Label labelC = new Label(2, 0, "第三列標題", normalFormat);Label labelD = new Label(3, 0, "第四列標題", normalFormat);for(int i=1; i<=10; i++){Label lab1 = new Label(0,i,"第"+i+"行第1列");Label lab2 = new Label(2,i,"第"+i+"行第2列");Label lab3 = new Label(3,i,"第"+i+"行第3列",diffFormat);Label lab4 = new Label(4,i,"第"+i+"行第4列");sheet.addCell(lab1);sheet.addCell(lab2);sheet.addCell(lab3);sheet.addCell(lab4);}// 將定義好的單元格加入到工作表中sheet.addCell(labelA);sheet.addCell(labelB);sheet.addCell(labelC);sheet.addCell(labelD);book.write();book.close();System.out.println("創建文件成功!");} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{}}}

?讀取csv文件

File csv = new File("E:\\江蘇省四維POI.csv"); // CSV文件BufferedReader br = new BufferedReader(new FileReader(csv));//for(int num = 1; num<=rowMaxNum; num++){String lineText = "";// 讀取直到最后一行int i=0;while ((lineText = br.readLine()) != null && i<=200) {if(i>0){String arr[] = lineText.split(",");String PNNAME = arr[0];String POINT_X = arr[1];String POINT_Y = arr[2];String POIID = arr[3];findDifferent(PNNAME,POINT_X,POINT_Y,POIID);}i++;}br.close();

?

版權聲明：本文博主原創文章，博客，未經同意不得轉載。

總結

以上是生活随笔為你收集整理的jxl创Excel档java示例代码说明的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。