Hi All,
When we download the excel file in outsystem do we have any option to format the excel cells as text before downloading
Regards
Hi Ujawala,
Unfortunately no. The OutSystems Excel download is pretty primitive in that respect. However, if your structure contains a Text attribute, that should also be translated to an Excel text column/cell. So if you have, say, a date, but want it to be a text in Excel, then put it in an attribute of type Text.
Thank you
Hi ujwala,
Formatting in excel is achieved by using "advance Excel" component using function cell_write.
Link for the component "https://www.outsystems.com/forge/component-overview/355/advanced-excel"
Thank you,I am using this component but when we download excel the format of the cell becomes general and no text .User has to convert it again to text.
HI ujwala,
I found the way to make it as formatted to test instead to general is used.
here is exported excel with text formatted.
Hello,
As @Kilian Hekhuis says you can create your own structure with Data type you want for each field.