• Please note: In an effort to ensure that all of our users feel welcome on our forums, we’ve updated our forum rules. You can review the updated rules here: http://forums.wolflair.com/showthread.php?t=5528.

    If a fellow Community member is not following the forum rules, please report the post by clicking the Report button (the red yield sign on the left) located on every post. This will notify the moderators directly. If you have any questions about these new rules, please contact support@wolflair.com.

    - The Lone Wolf Development Team

Tekkamge's Excel Character Sheets

Tekkmage

Well-known member
Since the native character sheet wasn't working for me as it cuts things off in certain situations I created one in excel that will pull in the xml file from the custom output.

I don't know if this works with the free viewer. I am using Excel 2016 but I know this method works with 2007 and up.

Advantages:
  • Put fields where you want them.
  • Hide or add data elements.
  • Easily change fonts, color scheme and look of tables.
  • Add your own graphics or pictures.
  • Add your own static content.
  • Change paper sizes.

Disadvantages:
  • Columns are sized so that once a column needs to be larger it has to be larger for the entire sheet. This is why I put each page on a separate tab.
  • Need to make sure you fit within the right left page borders. Sometimes manipulation is needed or fit on page during printing.
  • Extra steps to print character from native.
  • If you move the location of the xml file you need to redirect the data link in Excel.


You can download my sheets here. I will try to keep them up to date as I upgrade them for my own games.

To use:
  1. Download the entire folder to your C: drive. You can put it elsewhere but you will have to change the data source location.
  2. Export a single character using custom output from Hero Lab to the HerolabSavageWorlds.xml file..
  3. Open the Character sheet HerolabSavageWorlds.xlsx
  4. Right click on any of the elements and go to the XML menu and choose Refresh XML data.

Your character should now be updated into the sheet. You can do the same with the second Excel file if you want some tables with more data.

You can now format the text or move elements around.

You can delete data elements by using the delete key or in the xml element pane.

To open the data element pane right click on any element in the sheet go to the xml menu and choose xml source. You can also do this from the menu at the top. Note you have to have an xml file that has all the elements in it that you want to map. The default one I provide has all the elements i could populate on the sheet. (no superpowers though)

If you want to add new data elements drag them from the xml pane. If an element is arrayed you can add a field from that same array to the table that was created on the sheet. If you want to rearrange the column order you can insert columns and drag the column you want to put there.

If you want to create a completely new sheet:
  1. open Excel
  2. Drag teh xml file on to the excel window.
  3. Click yes to all the questions.

Remember only the data elements you have in your sheet will appear. If you want to have arrays for data that has multiple entries such as skills you will need more than one entry in your xml file so add multiples to the character before you export your xml file.

If you want to move the folder to a different directory or use a different name for the xml file in the Excel top menu go to the Data tab then click on Queries and Connections. then double click on the connection. Click on the Definition tab and in the connection path paste your file link to the xml file or navigate using the button.

If this works for you please let me know.
 
Back
Top