- Passing empty string in a cell
Sometimes we feel the need of passing null/blank value in excel to avoid the null pointer exception and we can handle this from excel sheet without having to handle from code.
– If you want to pass empty string just type opening single quote ( ‘ ) and it will be treated as empty string for apache poi - Passing number as string
If you want to pass number or decimal as string , prefix with opening single quote ( ‘ ) and it will take it as string value.
Ex: ‘20.00 , ’29 - Treating a null cell as blank
We can make use of Row policy to treat a cell as blank.
TechieWolf 