Exporting a the names of topics in a ditamap to excel

Mark Hartz
Posts: 1
Joined: Wed Jun 23, 2021 6:55 pm

Exporting a the names of topics in a ditamap to excel

Post by Mark Hartz » Wed Jun 23, 2021 7:10 pm

I've seen a lot of topics on exporting/importing to Excel, but not for this use case.

I am trying to create a spreadsheet of topics within a DITA map to Excel. This is for an online portal, where we need to create a classification map for all topics within a book. This classification map must be in Excel.
Theoretically, the files in this book would be exported:
image.png
image.png (36.65 KiB) Viewed 83 times
And appear in excel as:
c_copyright_notices
r_document_conventions
etc.

Is this possible?

Radu
Posts: 7538
Joined: Fri Jul 09, 2004 5:18 pm

Re: Exporting a the names of topics in a ditamap to excel

Post by Radu » Thu Jun 24, 2021 7:29 am

Hi Mark,

We do not have something like this available out of the box.
At some point I created a DITA OT publishing plugin which merges the entire DITA Map contents in one file, and as a possible application I created an XSLT stylesheet which creates an HTML table with all the topics:
https://github.com/oxygenxml/dita-merged

I presented this idea at the DITA OT Day Meetup in 2019:

https://youtu.be/hUXUwLo4tjc?t=2009

Once you have an HTML table, you can copy and paste it directly in Excel to create the equivalent cells there.

Regards,
Radu
Radu Coravu
<oXygen/> XML Editor
http://www.oxygenxml.com

Post Reply