Powershell : manipulate Excel files

Hi mates,
I needed to manipulate some Excel files and merge some data with my customer's Active Directory.
The main goals were to :
1. be sure that the files were consistent
2. correct eventual anomalies
3. merge part of its contents with some specific fields of the Active Directory
Theoretically this is something that is usually made in accordance with the HR dept. In particular when they use a system the is totally different or separated from our main directory.
The fact is that for several purposes some fields needs to be populated : for example to assign budget or to split some costs between different sub-companies.


Anyway I found some interesting articles that explained me how to do that , I've merged them, adapted them and now I've what fits my necessities. Here you have it :


No complications, no tricks, only the essential.
Hope this helps.
See you soon