export to excel

hi,

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:

xlsWorkSheet.cells().item(row,17).value((companyInfo.dataAreaId).StartDate);

  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:

xlsWorkSheet.cells().item(row,17).value(date2str(fromDate,123,dateday::Digits2,DateSeparator::Hyphen,datemonth::Digits2,DateSeparator::Hyphen,dateyear::Digits4));

for second … help pls