• Cell date format

    By Miroslav Navratil 4 years ago

    I might miss something but I can't figure out how to set the cell data format to Date when creating Excel sheet. Obviously there is property for that in Column Definition/Cell Style but I do not know what to put there .. no options offered.
    Could somebody kindly advise me? Thanks.

    • By Lena Troxler 4 years ago

      Hi Miroslav,

      You can set property 'dataFormat' in the cellStyle to the dataFormat you like:

        <wgpoi:cellStyle
              dataFormat="dd/mm/yyyy">
        </wgpoi:cellStyle>
      

      Hope this helps.