I am using org.apache.poi for excel interaction through Java and I am using SXSSF (not any other format like HSSF etc.). Here is how I want to set type.

private void setTechSheet(SXSSFWorkbook workbook, String entityJson) {
        SXSSFSheet tech = workbook.createSheet("tech");
        SXSSFRow jwtRow = tech.createRow(0);
        SXSSFRow SecondRow = tech.createRow(1);
        jwtRow.createCell(1).setCellValue(entityJson);
    }

If to put this in the 4th line of method:

jwtRow.createCell(1).setCellType(CellType.STRING).setCellValue(entityJson),

it won’t let me set value. As I read from tutorial, the cell will be the type of datas I write (string in my example). But when I open excel and click on my cell it still shows general type. How can I solve this problem? I want the cell to be any type, but not general.