Hi There,
I am new to Outsystems and I would like to designate the excel number format of the data I am writing to an excel file.
For example, if I write the following date: "2018-02-08" to an excel file from a database, it is designated as a "custom" datatype in excel (as shown in the image below):
However, I would like to be able to designate it to short date format:
"2018/02/08". I would like to be able to change the formats of more than just the date, but I figure solving this question would help me in general. For example, I would also like to stipulate (automatically in excel) that some values are currency values.
Any assistance would be greatly appreciated.
Regards,
Cole
Hi Cole,
The out-of-the-box RecordListToExcel server action does not support cell formatting.
There is a forge component name Excel Package with additional capabilities but I think it is only possible to do style formatting (like colors, bold, etc.). Nevertheless, this component is based on a open source library that seems to support formatting (for example, check this StackOverflow post) - it should be possible to extend it to achieve what you need with some additional C# coding.
Cheers,
Renato
Cole Noble wrote:
Thanks so much for your response Renato.
Indeed, I did see that package but, like you say, it seems to only support specific formatting.
I just wanted to be sure that I wasn't missing anything obvious.
I will look into said modifications if I deem the change absolutely necessary.