今天研究了一下如何使用jxl操作excel文件,写了个简单的示例程序如下,以后要是用Java做报表可以拿来用用。 import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.InputStream; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; public class EXCEL { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub try{ String resourcePath=System.getProperty("user.dir"); System.out.println(resourcePath); InputStream is=new FileInputStream(resourcePath.concat("//src//data.xls")); Workbook book=Workbook.getWorkbook(is); Sheet sheet=book.getSheet(0); Cell cell[]=sheet.getColumn(0); for(int i=0;i<cell.length;i++)//读出文件内容 System.out.println(cell[i].getContents()); System.out.println("导入的数据行数:"+sheet.getRows()); System.out.println("导入的数据列数:"+sheet.getColumns()); WritableWorkbook wrk = Workbook.createWorkbook(new FileOutputStream("b.xls")); //WritableWorkbook wrk = Workbook.createWorkbook(new FileOutputStream("b.xls"),book);//以book的格式创建一个excel文件, //其初始内容与in文件相同(更新文件可以用到此方法) WritableSheet wst = wrk.createSheet("demo", 0); Label l=new Label(0,0,"cike");//有多种格式的单元格 wst.addCell(l); book.close(); wrk.write();//必须有 wrk.close(); book=Workbook.getWorkbook(new FileInputStream("b.xls")); sheet=book.getSheet(0); System.out.println("导入的数据行数:"+sheet.getRows()); System.out.println("导入的数据列数:"+sheet.getColumns()); book.close(); }catch(Exception e){ e.printStackTrace(); } } }