Hi all, I am using advanced excel in order to create a excel sheet and I have 2 columns("J" & "K") in which I am facing this issue-
1) I want the "J" column to be formatted as Number and also the values stored should be as number in the excel i.e. Right aligned in the cell.
2) I want the "K" column to be formatted as Percentage with the right aligned property.
The worksheet is saving these columns as general and when enabled editing I am getting suggestions as the values are stored in text instead of Number.
As I am writing the excel using cell_write server action it is storing the data as text.
Hi Moin
You need to specify the correct options for CellType and CellFormat-> NumberFormat. NumberFormat is what you would have in Excel, and CellType can be:
Hanno
Are you using any of the formatting options when writing the data to the cells?
Can you perhaps share your flow as an image or even your .oml file for us to have a look at?
Here's an image of the logic implemented
Thanks Moin
Can you click on each of Workforce and Automation and then send screenshots of the properties pane please? That is so that we can see what you are setting as parameters for those actions
Here's the output excel downloaded. the format is general and the data is stored as text. I want the "B" Column as Number and "C" column as Percentage
Yes but for percentage what should be added in the Cell Type and Cell Format?
You should be able to determine this with a trial-and-error approach.
I would guess decimal for CellType, and the NumberFormat you should be able to see that in Excel when you view the formatting of a cell.
Thanks Hanno for the help
I was able find out for the percentage its "0.0%" in Number Format.
Here's the oml