Skip to main content
S
shubhamy3376
June 25, 2023
Solved

Export data to excel

  • June 25, 2023
  • 11 replies
  • 0 views

Hi All, ,

I am using the export dse to excel smart service. One column in db having decimal values but when exported to template it Removes the decimal part. Although I have formatted the column to number decimal in the template but it is not working. Can anyone please suggest some solution.

Many Thanks!

    Best answer by stefanhelzle0001

    No! This is an issue with data formatting Excel! You cannot solve that "issue" in Appian.

    11 replies

    harshitb6843
    harshitb6843
    June 25, 2023

    We did suggest you something on this thread - https://community.appian.com/discussions/f/new-to-appian/29104/modify-values-in-a-queryselection
    Did you give it a try?

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 25, 2023

    The issue with Excel is, that it tries to be clever on how to display values. When importing or exporting data with Appian to or from Excel it is always a challenge to get things right.

    S
    shubhamy3376Author
    June 25, 2023

    Yes Stefan it is surely a challenge. Any suggestions to display decimal values while exporting to excel?

    S
    shubhamy3376Author
    June 25, 2023

    The issue seems to be with data type in cdt. In database the column data type is decimal and in cdt it is number(decimal as well) but when querying using cdt it truncates the decimal part in result.

    Terms & ConditionsAccessibility statement