I was trying filter option in Microsoft Excel via powerShell.
According to the requirement, I need to filter out all the values which are non-blank from 2 of the columns.
The code developed so far, only gives me the exact filter value i.e blanks, but I need the all the non blanks from 2 columns.
$oldfile = "xyz.xlsx" # source's fullpath
Why are you using Excel COM object? This might be unstable since it's basically spawning an Excel instance in the background. I would use OleDB instead and you can filter what you want using standard SQL syntax.
You must be logged in to reply to this topic.