How to find empty string from a cell.

[deshmukh.niraj04]

Hi All,

I am using Excel file as input and i am trying to find if there is any space " " in the cell if it is blank cell.

My requirement is if there is any cell which contains " " or null it should be highlighted.

[Tolls]

What do you mean by "highlighted"?
Are these specific cells?
If not, how do you determine which cells to check?
What excel package are you using?
JExcel, POI, something else?

[deshmukh.niraj04]

Thanks for reply,

I am using Aspose.java.cells API.

Workbook workbook = new Workbook();
 workbook.open(filename);
Worksheet worksheet = workbook.getWorksheets().getSheet(sheetno);
Cells cells=worksheet.getCells();
int num=cells.getMaxDataRow();
for (int n1=0;n1<=num;n1++)
  {  Cell cell1=cells.getCell(n1,Colno);
     if(cell1.getValue()==null ||cell1.getValue().toString().length()==0)
      {Cell cell=cells.getCell(n1,Colno);
        Style style = cells.getCell( n1,Colno).getStyle();
        style.setColor(Color.TEAL);
        cell.setStyle(style);
	  }
  }

[Tolls]

Unless Aspose works differently to other excel tools then it's possible this:

Cell cell1=cells.getCell(n1,Colno);

could return null, as Excel does not necessarily store a cell for empty cells. So worth bearing in mind.

After handling that, you could try trim()ing your toString() and then doing isEmpty() (rather than length() == 0)? It's a bit neater. That should cover space-only cells as well as empty ones.