Date Filter in excel file requirement approach
Hi All,
I have a pagelist property which is having few date type of properties. I'm able to generate the excel file using MSOgenerateexcelfile. Here my issue is after excel is dowloaded when we kept filter to the columns the date columns are showing as text format unable to filter date columns as in the pic.
can you suggest how can i achieve this. please note we can do format cells in excel file but users wanted below shown requirement whenever excel is generated.