in reply to sorting on subkey of hash of hashes

I dont know exactly the return of XLMin, but Im guessing you want soemthing like this:
my @sorted = sort { $a->{empid} <=> $b->{empid} } @{$parsed->{employees}};
gc