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.
Discussion posts and replies are publicly visible
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.
Hi rainiera0002, You can format the data into excel also. go to option "format cell" and then select Number from the category.
but I need the result to automatically turn it to 1,000.00 because it will be send through email
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
Doing that in DB is the only option as the plugin just copies the data from DB into Excel. There is no support for any transformation whatsoever.
If that is something you need to have anyhow, then you can try to change the type of the DB column to text.
I'm already using view table. Okay if that's the case the only option is to change the format through database.. I'll get back to you. Thank you