java读写excel文件_用Java读取excel文件并改写内容

packagecom.iflytek.excel;importjava.io.File;importjava.io.FileInputStream;importjava.io.IOException;importjava.io.InputStream;importorg.junit.Test;importnet.sourceforge.pinyin4j.PinyinHelper;importjxl.Workbook;importjxl.read.biff.BiffException;importjxl.write.WritableCell;importjxl.write.WritableSheet;importjxl.write.WriteException;public classReadExcel {

@Testpublic void operate() throwsBiffException, IOException {

ReadExcel obj= newReadExcel();//创建Excel路径

File file = new File("C:"+ File.separator +"Users"+ File.separator +"Administrator"+File.separator+"Desktop"+ File.separator +"学生报告样本数据@0421.xls");

obj.readExcel(file);

}//读Excel的方法readExcel，该方法的参数为一个File对象

public void readExcel(File file) throwsBiffException, IOException {try{

jxl.Workbook wb=null; //创建一个workbook对象