[Advanced Excel] Cell_FormatRange with CellType

Forge Component
Published on 2018-10-08 by Hanno
43 votes
Published on 2018-10-08 by Hanno

Dear Team,

I have a question for the Cell_FormatRange action, would it be possible to also include the number format there as a CellType parameter? Now all cells seem to be formatted as General.

In this case I have, I need to write text values to the excel (because i have dynamic queries and no dynamic structures exist for advanced queries, so all data gets to be text using recordlist to excel, etc) that later on get formatted according to the data type from the dynamic query in the excel. Now I need to go cell by cell as only Cell_WriteBy... has the CellType parameter.

Thanks for your consideration.