[Advanced Excel] Cell_WriteRange Date Formatting
Forge component by Carlos Freitas
Application Type
Traditional Web
Service Studio Version
11.6.30 (Build 11705)
Platform Version
11.9.0.21103

Can I apply the Date format to a number of columns? 

I have the issue that date is rendered as general and looks like this:

While in the original it is formatted correctly: 

I assumed I could use the NumberFormat attribute of CellFormat_ApplyToRage, however I cant find any documentation on which values I can give this attribute, nor any examples in the Demo app. 

I have tried some values such as "Date" or "ShortDate" but they generate something like this, not the desired result as seen in picture 2:

Also note the "ss" prefixed to the headers, in our environment we are limited to Stable releases only, is there another workaround for this?


Hi Fred.

Related to the date formatting I faced the same issue and the solution was to apply a custom date format to the cells and works for me.


Related to the prefix, already exists another topic: https://www.outsystems.com/forums/discussion/59112/advanced-excel-all-headers-are-prefixed-with-ss/

Regards,

´Gonçalo Almeida


Care to share what custom date format you used?

I am familiar with the thread about the ss prefix, that's why I specifically pointed out we are restricted to Stable releases and can not install an "Under Development" version.

Cheers, Fred

Champion

Hi Fred,

In my case, i use the following celltype "Text" and my cellvalue is formatted using FormatDateTime buit in function

https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Built-in_Functions/Format#FormatDateTime

I am using the Cell_WriteRange action because I'm basically converting 5 JSON files to an excel sheet each and adding those together in one workbook. The flow is slow enough as it is, I don't think it would be beneficial to use Cell_WriteByIndex in my case

If you can share the Json where this issue is it would be more helpful to see the use case.

Regards

Gonçalo Almeida

It starts with a multi-sheet Excel that gets converted into a record for every sheet:

The full JSON files for TestSet 7 are attached in a single file:


JSONSheetsOS.txt

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.