java中操作excel_在Java中对Excel操作

创建一个文件temp，同时在temp 目录下创建一个outpath.xls

写操作

package com;

import java.io.File;

import java.io.IOException;

import java.text.DateFormat;

import jxl.Workbook;

import jxl.format.UnderlineStyle;

import jxl.write.DateTime;

import jxl.write.Label;

import jxl.write.NumberFormat;

import jxl.write.WritableCell;

import jxl.write.WritableCellFormat;

import jxl.write.WritableFont;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;

import jxl.write.biff.RowsExceededException;

public class Demo {

//定义一个静态变量

private static String path="d:/temp/";

//查找目标文件是否存在

static void   checkExist(String   path){

java.io.File   file   =   new   java.io.File(path);

if(file.isDirectory()){

System.out.println("the   dir   is   exits");

file.delete();

}else{

file.mkdirs();

System.out.println("made   a   dir   ！"   );

}

}

public static void main(String args[]) throws IOException, RowsExceededException, WriteException{

Demo.checkExist(path);

File tempFile=new File(path+"outpath.xls");

&nbsp