May 25 2021 09:19 AM
I am trying to use the FILTER and XMATCH formulas with a PowerShell script but when I open the XLSX files, those formulas are not spilling over to the other rows and columns and have '@' in them.
If I manually remove the '@' and press enter, the formulas work, spilling over and populating the other rows and columns as set.
Is there something extra I have to do within my PowerShell script? I have tried using the .Formula, .FormulaArray, and .Value() lines.
Any advice would be much appreciated.
May 26 2021 08:02 AM
SolutionMay 26 2021 08:04 AM
Awesome. Much thanks.
This is working for me now :
$ExcelWorksheet.Cells.Item(2,3).Formula2 = '=FILTER(...)'
May 26 2021 08:02 AM
Solution