Hi Team,
We've run into a unique problem with the Excel Tools plugin.
Scenario is as follows:
We have a set of records with various data types and a pre-formatted Excel template where cell types are already configured. For most values the export is unproblematic as the standard Appian 4-byte integer is enough to handle the integer values. However, there's a new requirement that allows us to handle values beyond that limit (i.e. LongInt), which can be used on database side, but cannot be mapped to Appian Records where we have to rely on Text values instead. While there are plugins like Big Numbers Functions that support big decimal and integer numbers, this doesn't change the fact that we are still providing the Excel Tools plugin with a text values.
Although the text is all natural numbers, the cell format in the exported Excel is of type Text and must be manually changed after download before it can be used downstream.
My question to you all is whether you have run into a similar problem before, and what your solution has been. I could not find a plugin that allows us to format the cell type after the Excel has been created sadly, so any input is welcome.
Thanks a lot in advance!
Matt
Discussion posts and replies are publicly visible