Skip to main content
R
rainiera0002
April 5, 2022
Question

Modify export to data store entity to excel

  • April 5, 2022
  • 7 replies
  • 0 views

Hello, do anyone know how can you modify specific query column value to excel file? I want to change the return value ex. amount to 1,000.00 instead 1000 but there's no documentation on how to do that.. I return the database data to "Starting Cell" but I want to modify the format.

7 replies

harshitb6843
harshitb6843
April 5, 2022

I don't think changing the data is possible. However, you can try changing the type of the column in the DB. Having a text column instead of a number column might solve the problem. 

gopalk2865
gopalk2865
April 5, 2022

Hi  rainiera0002, You can format the data into excel also. go to option "format cell" and then select Number from the category.

R
rainiera0002Author
April 5, 2022

but I need the result to automatically turn it to 1,000.00 because it will be send through email

gopalk2865
gopalk2865
April 5, 2022

Hi, you can create a view in the db and format the values ,  you can use format() function to convert the value and then create the entity of this view and then export.I know it would take  time to implement. Otherwise let's wait if someone has any other solution

Terms & ConditionsAccessibility statement