How to read an excel file that contains array of json

Question

I am trying to read an excel file , which contains only one column , and its an array of json , I am not able to read it by apache-poi in the form of string .

XSSFWorkbook workbook = new XSSFWorkbook(file); 
XSSFSheet worksheet = workbook.getSheetAt(0);
int index = 0;

for (index = 0; index < worksheet.getPhysicalNumberOfRows(); index++) {
    if (index > 0) {
        XSSFRow row = worksheet.getRow(index);
        String b = row.getCell(0).getStringCellValue();
        System.out.println(b);
    }
}

This code is not returning the value of the columns in string form. Please tell me - how can I read the col values in string as it is?

Sample of Excel file

What output does it give?

M. Deinum
– M. Deinum

2022-10-10 10:39:26 +00:00
Commented Oct 10, 2022 at 10:39 — M. Deinum
– M. Deinum, Commented Oct 10, 2022 at 10:39

Abhishek Kumar Jena · Accepted Answer · 2022-10-11 07:30:13Z

I solved your problem once try this

HSSFWorkbook wb=new HSSFWorkbook(file);
        HSSFSheet sheet=wb.getSheetAt(0);
        FormulaEvaluator formulaEvaluator=wb.getCreationHelper().createFormulaEvaluator();
        for(Row row: sheet)
        {
            for(Cell cell: row)
            {
                switch(formulaEvaluator.evaluateInCell(cell).getCellType())
                {
                    case Cell.CELL_TYPE_NUMERIC:
                        System.out.print(cell.getNumericCellValue()+ "\t\t");
                        break;
                    case Cell.CELL_TYPE_STRING:
                        System.out.print(cell.getStringCellValue()+ "\t\t");
                        break;
                }
            }
            System.out.println();
        }

I took the input in .xls file like this

enter image description here

and this is the output

enter image description here

Collectives™ on Stack Overflow

How to read an excel file that contains array of json

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related