Skip to main content
Known Participant
Jun 23, 2023 1:52 PM UTC
Question

Data Export into Excel

Hi All

I am exporting data into excel template from database table. In table there is one column having decimal value. But when exported to excel template the decimal values are truncated.

Can anyone please help me out?

    3 replies

    harshitb6843
    Brainy
    Jun 23, 2023 1:56 PM UTC

    You can refer this documentation and format the column to a number or fraction type column - docs.appian.com/.../Export_To_Excel_Smart_Service.html

    Known Participant
    Jun 23, 2023 2:45 PM UTC

    Hi [mention:ef600ff8f5d2497eb2def2126dc89484:e9ed411860ed4f2ba0265705b8793d05]

    I have formatted the document to update column to number but when data is exported into it through smart service the formatting is removed.

    Known Participant
    Jun 25, 2023 12:01 PM UTC

    Hi Everyone,

    Can anyone please suggest a solution to this problem?

    Many Thanks!