• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 9 subscribers
  • Views 10412 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Date format issue in excel report

akshayan
Certified Lead Developer
We are using "Export SQL to Excel" smart service from "Excel Tools" plugin to create an excel report. Even though we have set a column to date format (column data type is date as well, database is Oracle) in the excel template, the generated excel does not retain the date format. Is there a way to force excel recognize the cell values as date for a column?

OriginalPostID-251711

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    The previous Excel plugin used to retain the cell formatting. I am having the same issue with currency data. I've formatted the column as 'Accounting' but Appian changes it to 'General' when writing to those cells and the values are not displaying correctly. The only way I've been able to adjust for this is to format the data in the SQL (or CDT value) used to write to the template which is not as nice (professional looking).
Reply
  • 0
    Certified Senior Developer
    The previous Excel plugin used to retain the cell formatting. I am having the same issue with currency data. I've formatted the column as 'Accounting' but Appian changes it to 'General' when writing to those cells and the values are not displaying correctly. The only way I've been able to adjust for this is to format the data in the SQL (or CDT value) used to write to the template which is not as nice (professional looking).
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.