With the Excel advanced package, there doesn’t seem to be any option to format cells without Macros.
As my organization is expected to disable all macros across the business due to security policy, this is not a suitable (or sustainable) workaround.
I can see that we can get cell colour… but not set cell colour (or any other formatting options) without running a macro.
Although this isn’t a huge issue, it does leave me with plain header cells when dynamically creating them, it effects the aesthetic of the resulting excel workbook.
As the Set Cell function requires a string to be entered, this causes the value entered on the spreadsheet to always be text, even if that is a number. There is no option to convert the number stored as text to number, without simulating keystrokes (double clicking in each cell).
This seems very strange as a lot of the time most of the data on Excel Workbooks are number values!
The issue this causes is that the end product cannot be analysed with formula, as the values are not recognised as numbers. My current workaround for this is to Set Cell Formula: =value($variable$).
I have seen that most responses to people asking about problem 2 suggest switching off error checking within excel… But this just hides the error… The error still exists and needs to be resolved!
The excel 365 package is not suitable for this project which is why I am not using the options on this package.
Is there any plans to add formatting options to Excel Advanced package? Or anyone aware of other workarounds?