Excel Cell Values not setting to null on server

[Sunil Kangralkar]

Hi Team,

After performing some search operation in Excel. I am setting the next cell value to null using below code
cellIerator.next().setCellValue((String) null);
Above code works when I execute service in localhost. But when I try it to execute the same service on server then the cell values is not setting it to null.

Can anyone please help on how to fix the above issue.

Thanks,
Sunil

[Vaibhav Jain]

Hi Sunil,

Below are few points to check:
1. DO you have the write access permission on the file kept at server?
2. Instead of null, if any other value you use - is it getting updated or not?
3. Are you opening and closing the connection for excel editing?

Thanks

------------------------------
Regards,
Vaibhav Jain
Capgemini
------------------------------