Cannot get a text value from a numeric cell while reading numeric data from an xlsx file in apache poi excel read, the following is the code snippet to read data from excel I've mix of columns containing string & numeric data
public String getData(int sheetIndex, int rowNum, int colNum)
{
String data;
data = sheet1.getRow(rowNum).getCell(colNum).getStringCellValue().toString();
return data;
}