jxl创建Excel文件java代码示例

记得要下载 并 导入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();