使用java jxl在excel中创建和访问工作表(Creating and accessing sheets in excel using java jxl)

 我正在使用jxl创建一个excel文件。 我想用日期命名 - 22-03-2012（第1张），23-03-2012（第2张），等等。 这里我正在创建文件和第一张表（这只运行一次）： 
 
    File file = new File(inputFile);
    WorkbookSettings wbSettings = new WorkbookSettings();
    wbSettings.setLocale(new Locale("en", "EN"));

    Date now = Calendar.getInstance().getTime();
    DateFormat df = new SimpleDateFormat("MM-dd-yyyy");
    String theDate = df.format(now);
    System.out.println(theDate);

    WritableWorkbook workbook = Workbook.createWorkbook(file, wbSettings);
    workbook.createSheet(theDate, 0);
    // now access it and do some operations
    WritableSheet excelSheet = workbook.getSheet(theDate);
    prepareSheet(excelSheet);
    workbook.write();
    workbook.close();
 
 现在，当我访问该文件并稍后修改它时（另一个类 - 每次想要添加更多数据时运行），我需要检查“它仍然是今天”。 换句话说，如果最后一张表的名称是22-03-2012而今天是22-03-2012 - >访问并修改此表，并且如果最后一张表的名称与当前日期不同 - >创建一个新表。 我想这是一个简单的“如果”声明的问题，但由于某种原因我不能使它工作。 需要新鲜的眼睛:)谢谢 

I'm creating an excel file using jxl. I'd like to name the sheets with dates - 22-03-2012(1st sheet), 23-03-2012(2nd sheet), and so on. Here I'm creating the file and the first sheet (this runs only once): 
 
    File file = new File(inputFile);
    WorkbookSettings wbSettings = new WorkbookSettings();
    wbSettings.setLocale(new Locale("en", "EN"));

    Date now = Calendar.getInstance().getTime();
    DateFormat df = new SimpleDateFormat("MM-dd-yyyy");
    String theDate = df.format(now);
    System.out.println(theDate);

    WritableWorkbook workbook = Workbook.createWorkbook(file, wbSettings);
    workbook.createSheet(theDate, 0);
    // now access it and do some operations
    WritableSheet excelSheet = workbook.getSheet(theDate);
    prepareSheet(excelSheet);
    workbook.write();
    workbook.close();
 
Now, when I access the file and modify it later on (another class - runs everytime you want to add more data), I need to check whether "it's still today". In other words, if the name of the last sheet is 22-03-2012 and today is 22-03-2012 -> access and modify this sheet, and if the name of the last sheet is different from current date -> create a new sheet. I guess this is a matter of simple "if" statement, but for some reason I can't make it work. Need fresh eyes :) Thanks

原文：https://stackoverflow.com/questions/9823587