Hi ,
Workbook workbook = new Workbook(“C:\Response.xlsx”);
workbook.save(“C:\Response.CSV”,SaveFormat.CSV);
Hi ,
Workbook workbook = new Workbook(“C:\Response.xlsx”);
workbook.save(“C:\Response.CSV”,SaveFormat.CSV);
Hi Sandeep,
Workbook book = new Workbook(dir + “book1.xlsx”);
Worksheet sheet = book.getWorksheets().get(0);
Cells cells = sheet.getCells();
Range range = cells.createRange(0, 0, cells.getMaxDataRow() + 1, cells.getMaxColumn() + 1);
Style style = book.createStyle();
style.setCustom("@");
StyleFlag flag = new StyleFlag();
flag.setNumberFormat(true);
range.applyStyle(style, flag);
book.save(dir + “output.csv”, new TxtSaveOptions());
Thanks for the quick turnaround. But this is more of workaround. I think there should be a property to set whether I want to read the cells with formatting or not .
Hi Sandeep,
Hi again,