d20 creature conversion

[peterb]

Originally Posted by DirkD

I was thinking that it would be nice to make something like the "The Big Book of d20 Monsters for BRP" out of the data you produced. I could rip the description of the monsters from the d20 document and use the stats from your program...

Is there an easy way to create a file (txt/html/doc/rtf...) out of the program with a (chapter-11-like-) stat-block for each creature? The actual format isn't really important, since I want to convert it to LaTeX anyhow, but it should be in a system where every entry can automatically be identified (and therefore automatically converted to the format of my choice).

What about XML? It shouldn't be that difficult to export data from Excel to XML (even if I never have done so myself...). All it takes, I imagine, is defining a XML schema and map that to the data in the workbook.

[peterb]

And btw the descriptions are found not only in the d20 SRD but also in the MRQ Monster SRD and the d20 descriptions needs to edited, so the best would be to produce an editable intermediate file. Could you produce a RTF file with the help of LaTex?

[DirkD]

Originally Posted by peterb

What about XML? It shouldn't be that difficult to export data from Excel to XML (even if I never have done so myself...). All it takes, I imagine, is defining a XML schema and map that to the data in the workbook.

The question is more like this: how do I export the relevant data for stat-blocks out of the excel-tables into (for example) a txt-file? After that, I'm good.

For example, if I wanted to export the data-table (A3-BG603) into a text-file in a format of my choice, how would I do that?

[peterb]

Originally Posted by DirkD

The question is more like this: how do I export the relevant data for stat-blocks out of the excel-tables into (for example) a txt-file? After that, I'm good.

For example, if I wanted to export the data-table (A3-BG603) into a text-file in a format of my choice, how would I do that?

Try saving the worksheet, using File -> Save As, as either a:

• Tab delimited text, or
• Semicolon delimited (*.skv), or
• Whitespace formated text (*.prn)

Use Excel's help search function and search for "Save As", you should find a help page with more info on the various file formats one can transform a Excel file to.