3 Replies Latest reply on Feb 13, 2009 2:14 PM by yanmania

    Excel export and cell type

    yanmania

      Is it possible to extract a rich:datatable so that Excel cells are typed.


      For exemple, I have a richdatatable with a column of dates, a column of numbers and a column of string like that :


      Date          Price       Product
      13/02/2009    100.50      computer X
      22/02/2009    150.00      computer Y


      When I export my dataTable, I would like to have a Excel sheet with these type :
      A1 : string    B1 : String      C1 : string
      A2 : date      B2 : float       C3 : string


      Does it make sens ?