Refer to below notes on support.oracle.com. This should answer most of the queries you may have.
Master Note For Primavera P6 Software Development Kit (SDK) Installation And Common Technical Or Application Issues [ID 1315425.1]
Which Excel Utilities Are Available For Use With The Primavera Software Development Kit (SDK) [ID 895537.1]
Unfortunately the SDK utilities are no longer being developed in later releases. To clarify, the SDK itself is still available but the sample utilities (dictionary.xls, activity.xls, etc) published to the knowledgebase are no longer being updated.