java-excel 操作

import jxl.write.Label; import jxl.write.WritableCell; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; public class readexcel { public static void main(String[] args) { Workbook readwb = null; try { //构建Workbook对象, 只读Workbook对象 //直接从本地文件创建Workbook InputStream inStream = new FileInputStream("E:/book1.xls"); readwb = Workbook.getWorkbook(inStream); //Sheet的下标是从0开始 //获取第一张Sheet表 Sheet readSheet = readwb.getSheet(0); //获取Sheet表中所包含的总列数 int rsColums = readSheet.getColumns(); //获取Sheet表中所包含的总行数 int rsRows = readSheet.getRows(); //获取指定单元格的对象引用 for(int i=0;i<rsRows;i++){ for(int j=0;j<rsColums;j++){ Cell cell = readSheet.getCell(j,i); System.out.print(cell.getContents()+"\t"); } System.out.println(); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } try { //利用已经创建的Excel工作薄,创建新的可写入的Excel工作薄 WritableWorkbook wwb = Workbook.createWorkbook(new File("E:/book12.xls")); WritableSheet ws = wwb.getSheet(0); WritableCell wc = ws.getWritableCell(0,0); if(wc.getType() == CellType.LABEL){ Label l = (Label) wc; l.setString("新名字"); } wwb.write(); wwb.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }