reading xlsx example issue

[sai rama krishna]

import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook; 

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFRow;

import java.util.Iterator;

import java.io.*;

public class sssssssss {

 

  

    public void ReadSheet() throws Exception

    {

        String filename = "C:\\cccc.xlsx";

        FileInputStream fis = null;

        try {

            fis = new FileInputStream(filename);

            

            XSSFWorkbook workbook = new XSSFWorkbook(fis);

            XSSFSheet sheet = workbook.getSheetAt(0);

            Iterator rows = sheet.rowIterator();

            int number=sheet.getLastRowNum();

            System.out.println(" number of rows---->"+ number);

            while (rows.hasNext())

            {

 

                XSSFRow row = ((XSSFRow) rows.next());

                Iterator cells = row.cellIterator();

                while(cells.hasNext())

                {

                    XSSFCell cell = (XSSFCell) cells.next();

                    String Value=cell.getStringCellValue();

                    System.out.println(Value);

                }

             }

        } catch (IOException e) {

            e.printStackTrace();

        } finally {

            if (fis != null) {

                fis.close();

            }

        }

        

    }

 

 

    public static void main(String[] args) {

 

        sssssssss object=new sssssssss();

        try{

        object.ReadSheet();

 

        }catch(Exception e)

        {

            e.printStackTrace();

        }

}

 

}

I was trying above example from link


http://techtadka.net/articles/programming/208-code-for-reading-a-xlsx-file-in-java.html


using attached cccc.xlsx.

I am getting following error. Please advise
number of rows---->1
java.lang.IllegalStateException: Cannot get a text value from a numeric cell
at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:845)
at org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:294)
at org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:246)
at sssssssss.ReadSheet(sssssssss.java:60)
at sssssssss.main(sssssssss.java:98)





Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance

[Steve Luke]

java.lang.IllegalStateException: Cannot get a text value from a numeric cell

You have a value which is a Number. You try to get text from it. You should instead try to get a Number from it.

[sai rama krishna]

import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook; 

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFRow;

import java.util.Iterator;

import java.io.*;

public class sssssssss {

 

  

    public void ReadSheet() throws Exception

    {

        String filename = "C:\\cccc.xlsx";

        FileInputStream fis = null;

        try {

            fis = new FileInputStream(filename);

            

            XSSFWorkbook workbook = new XSSFWorkbook(fis);

            XSSFSheet sheet1 = workbook.getSheetAt(0);

            Iterator rows = sheet1.rowIterator();

            int number=sheet1.getLastRowNum();

            System.out.println(" number of rows---->"+ number);

            while (rows.hasNext())

            {

 

                XSSFRow row = ((XSSFRow) rows.next());

                Iterator cells = row.cellIterator();

                while(cells.hasNext())

                {

                    XSSFCell cell = (XSSFCell) cells.next();
                    String Value=null;
                    if(cell.getCellType() == cell.CELL_TYPE_STRING) {
                     Value=cell.getStringCellValue();

                    System.out.println(Value);
                    }

                }

             }

        } catch (IOException e) {

            e.printStackTrace();

        } finally {

            if (fis != null) {

                fis.close();

            }

        }

        

    }

 

 

    public static void main(String[] args) {

 

        sssssssss object=new sssssssss();

        try{

        object.ReadSheet();

 

        }catch(Exception e)

        {

            e.printStackTrace();

        }

}

 

}

I changed like above now able to read only few values not all as below

number of rows---->1
aa
77-SS_001
DONE
aa
77-SS_002
NoDONE


>>You should instead try to get a Number from it.

How to get Number instead of string. Please advise