export to excel


i am exporting table data to excel , i am encountering two problems.

  1. in date field that is exported from table , in excel sheet ites showing time also like 26/04/2012 9:40 , using this code:


  1. i have set autofit , its working fine for all except 1 column .

pls help!!

hey guys

i found the solution for the first one, i am now converting date to str:


for second … help pls