XLS to Data: 1.3 Player Related Powers

For all player related powers xlstopowdef.bat is most commonly used.

This script is used when editing any xls related to player powers does not require file to be enumerated. Note before use if you do not enumerate this will overwrite every single def related to any player power in the game based on changes it detects between the xls sheet and the Def files.

Currently if you use any of the releases Faptastic,Voldemort and all other releases that have missing data or mixed up data it will clean and update everything. This will in fact fix most pstring errors unless the fx or texture is missing.

The XLS are seem to be untampered with so if you run xlstopowdef.bat it will build clean def files, It seems to work this way with all currently working .bat files.

Recommendation - run xlstopowdef.bat to clean up every single power file in the game and then add in power changes to XLS sheets.

>!Warning Do not run xlstopowdef.bat by itself unless you have a backup and are prepared to replace powers!<

Correct usage

xlstopowdef.bat "C:\game\data\Defs\powers\src\player_Blaster_ranged.xls".

In this example this will only output from the player_blaster_ranged.xls".

Replacing each power changed in the XLS. When changing a players power set it will always change the .powersets and .categories. In this example we told it to export the changes to the ranged blaster sets.

-Blaster_ranged.powersets

-Player_blaster_ranged.categories

The script is smart if you only make a change to a power it will only update that power, If you change something in dark blast it will only update:

-Blaster_Ranged_Dark_Blast.powers

A note to server operators and developers - If you have made changes to a power only using def files this will overwrite those changes they would need to be added to the XLS. The original Developers did not work in the def files as they made extensive use of the Excel sheets. So there is no way currently to automatically bring the changes from a def file into the XLS sheets. The scripts were specifically built to replace those files you could technically delete nearly all of them, run the scripts and it would build fresh files from the XLS sheets.

NPC Powers

For all NPC related powers xlstopowdef.bat is used.

*Update* NPC's powers are changed with the same script as above but you need to point directly to the NPC XLS ex xlstopowdef.bat "C:\game\data\Defs\powers\src\Villain_Powers_Family.xls"