Hi,
I set a formula in the the data labels, but the formula is missing after the excel file is generated .
Here I attach the sample file.
I just set the date in my coding.
Workbook workbook = new Workbook();
workbook.open("C:\\Excels\\book1.xls");
Cells cell = workbook.getWorksheets().getSheet("Sheet1").getCells();
java.util.Date today = new Date();
cell.getCell("G23").setValue(today);
workbook.save("C:\\Excels\\book2.xls");
Any idea?
Thanks.