java里excl读取label类型_通过java来对Excel表格进行操作（包括格式，颜色，内容）...

package com.edu.test; import java.io.File; import java.io.IOException; import jxl.Cell; import jxl.CellType; import jxl.Sheet; import jxl.Workbook; import jxl.format.UnderlineStyle; import jxl.read.biff.BiffException; import jxl.write.Label; import jxl.write.WritableFont; import jxl.write.WriteException; import jxl.write.biff.RowsExceededException; public class ExcelTest {     public static void main(String[] args) throws Exception, Exception { //        writerexcel();         updateexcel();          }          //读取Excel中的文件啊     public static void read() throws Exception, Exception{         jxl.Workbook rwb = jxl.Workbook.getWorkbook(new File("F:\\students.xls"));         int sheets = rwb.getNumberOfSheets();                  Sheet[] sheets1 = rwb.getSheets();         System.out.println(sheets);         for(Sheet sh:sheets1){             System.out.println(sh.getName()+sh.getColumns());         }                  jxl.Workbook rwb1 = jxl.Workbook.getWorkbook(new File("F:\\students.xls"));         String apiVersion = rwb1.getVersion();         System.out.println(apiVersion);                  jxl.Sheet rs = rwb.getSheet(0);         for(int i=0;i<4;i++){             Cell[] cell = rs.getRow(i);             for(Cell c:cell){                 System.out.print(c.getContents()+"    ");             }             System.out.println();         }     }     //创建Excel文件     public static void writerexcel() throws Exception, Exception{         jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File("F:\\studens.xls"));         //创建Excel工作表         jxl.write.WritableSheet ws = wwb.createSheet("Test Sheet 1", 0);         //1.添加Label对象         jxl.write.Label labelC = new jxl.write.Label(0, 0, "This is a Label cell");         ws.addCell(labelC);         //添加带有字型Formatting的对象         //添加带有字体颜色Formatting的对象         jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES, 18, WritableFont.BOLD, true,                 UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.YELLOW);         jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);         jxl.write.Label labelCF = new jxl.write.Label(1, 0, "This is a Label Cell", wcfF);         ws.addCell(labelCF);         //添加带有字体颜色Formatting的对象 //        jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, //                UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED); //        jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc); //        jxl.write.Label labelCFC = new jxl.write.Label(1, 0, "This is a Label Cell", wcfFC); //        ws.addCell(labelCF);         //2.添加Number对象         jxl.write.Number labelN = new jxl.write.Number(0, 1, 3.1415926);         ws.addCell(labelN);         //添加带有formatting的Number对象         jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##");         jxl.write.WritableCellFormat wcfN = new jxl.write.WritableCellFormat(nf);         jxl.write.Number labelNF = new jxl.write.Number(1, 1, 3.1415926, wcfN);         ws.addCell(labelNF);         //3.添加Boolean对象         jxl.write.Boolean labelB = new jxl.write.Boolean(0, 2, false);         ws.addCell(labelB);         jxl.write.Label labelSF = new jxl.write.Label(1, 2, "AA");         ws.addCell(labelSF);         //4.添加DateTime对象         jxl.write.DateTime labelDT = new jxl.write.DateTime(0, 3, new java.util.Date());         ws.addCell(labelDT);         //添加带有formatting的DateFormat对象         jxl.write.DateFormat df = new jxl.write.DateFormat("dd MM yyyy hh:mm:ss");         jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(df);         jxl.write.DateTime labelDTF = new jxl.write.DateTime(1, 3, new java.util.Date(), wcfDF);         ws.addCell(labelDTF);                  //写入Exel工作表         wwb.write();         //关闭Excel工作薄对象         wwb.close();     }          //更新     public static void updateexcel() throws IOException, Exception{         //创建只读的Excel工作薄的对象         jxl.Workbook rw = jxl.Workbook.getWorkbook(new File("F:\\studens.xls"));         //创建可写入的Excel工作薄对象         jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File("F:\\studens.xls"), rw);         //读取第一张工作表         jxl.write.WritableSheet ws = wwb.getSheet(0);         //获得第一个单元格对象         jxl.write.WritableCell wc = ws.getWritableCell(1, 1);         //判断单元格的类型, 做出相应的转化         if(wc.getType() == CellType.LABEL){             Label l = (Label)wc; //            jxl.write.DateTime labelDTF = new jxl.write.DateTime(1, 3, new java.util.Date(), wcfF);             l.setString("aaaaaaaaaaaaaa");         }else {             jxl.write.DateFormat nf = new jxl.write.DateFormat("yyyy-MM-dd HH:mm:ss");             jxl.write.WritableCellFormat wf=new jxl.write.WritableCellFormat(nf);             jxl.write.DateTime wd=new jxl.write.DateTime(1,1,new java.util.Date(),wf);             ws.addCell(wd);         }         //写入Excel对象         wwb.write();         //关闭可写入的Excel对象         wwb.close();         //关闭只读的Excel对象         rw.close();     } }