I’m trying to write a script where PowerShell will pull a list of computers from a txt file, then run through each item of the list to try and ID the system in an Excel file. Ultimately, if the entry already exists, I want to have it automatically update the entry’s counter and replace the date with the current date. If it can’t find it, I want it to add the entry to the Excel file, set the counter at “1” and add the current date.
I know how to export data to a new Excel file, I just don’t know how to make PowerShell locate or update information in an existing Excel file.