How to pass date field as empty while writing cell

Hi All,

Is there any way to pass cell empty while writing excel based on condition in "date" type field.

Note: My Database column and structure attribute both are date type. 


Thanks,

Manish Pandey


Hi Manish,

Are you using RecordListToExcel if yes, Then before assign your Record list to excel you need to prepare one more list with your condition. So based on condition you have pre-populated list with you, Now assign that list to RecordListToExcel. Hope it works. 

Other way is use Excel Components to write records cell by cell.

-Hitesh-

Hitesh Maran wrote:

Hi Manish,

Are you using RecordListToExcel if yes, Then before assign your Record list to excel you need to prepare one more list with your condition. So based on condition you have pre-populated list with you, Now assign that list to RecordListToExcel. Hope it works. 

Other way is use Excel Components to write records cell by cell.

-Hitesh-

Hi Hitesh,

Actually I am writing records cell by cell and this issue is resolved as I changed the format cell of excel file, from date to text.


Thanks,

Manish Pandey