HOw Can I get Length of the Cell

Aspose.Cells Product Family
1

Hi,
Is there any property which will give me the length of the cells.or how can i do this using Aspose

Thanks.

2

Hi,


Can you please elaborate your question little more? Do you need the number of Data Cells in a Worksheet or do you need the length of characters in a particular Cell?

Thank you
3

Thanks For replying.

I got the Solution for the same. I was trying to get length of character in the particular Cell.

cells.getCell(5,5).getValue().toString().length()

Can you suggset me how can i check wether the cell is Empty or Not…


Thanks.

4

Hi,

If cell’s string value’s length is 0, then the cell is empty. Please use this code.

Java


if (cl.getStringValue().length() == 0)
{

//cell is empty

}

5

Hi,


Also, you may try the below code as well

JAVA
if (cell.getValue() != null)
{
System.out.println(“true”);
}
else
{
System.out.println(“false”);
}