Extracting data from excel and updating variables

PowerShell Help
3

Hi again,

Sorry - I know it is a bit vague.

Basically, I currently have the below in a PS1 file…

Subscription Category 1 =
If(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub1″),”A”
,IF(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub2″),”B”
,IF(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub3″),”C”

Subscription Category 2 =
If(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub1″),”X”
,IF(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub2″),”Y”
,IF(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub3″),”Z”

So lets assume the Excel file gets updated, so a new line is added and now looks like the following

 

Subscription Name Category 1 Category 2
Sub1 A X
Sub2 B Y
Sub3 C Z
Sub4 D W
I want to be able to run a new PS script to look at the table in excel and add the following new lines

Subscription Category 1 =
If(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub1″),”A”
,IF(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub2″),”B”
,IF(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub3″),”C”

,IF(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub4″),”D”

Subscription Category 2 =
If(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub1″),”X”
,IF(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub2″),”Y”
,IF(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub3″),”Z”

,IF(CONTAINS(‘Azure Subscription’,’Azure Subscription’[Subscription Name],”Sub4″),”W”