Exporting task to excel

Post here questions and problems related to editing and publishing DITA content.
mdslup
Posts: 167
Joined: Tue Mar 06, 2018 1:34 am

Exporting task to excel

Post by mdslup »

I'd like to export a task to excel, with each step being one cell. Is this possible?

The twist is: A lot of my steps are just an image (no text). And I want these to be outputted as well.

I found the documentation about copying to excel from "Grid" mode but again, this doesn't help with images. Is there a workaround?
Radu
Posts: 9051
Joined: Fri Jul 09, 2004 5:18 pm

Re: Exporting task to excel

Post by Radu »

Hi,

If you have an HTML document and you open it in a web browser, if it contains a table you can copy paste that table to Excel.
So one option for what you want would be to convert the DITA task to XHTML, then apply a custom XSLT stylesheet over the XHTML to create a table from the XHTML list, then open the final HTML in a web browser, copy and paste the table to Excel.
To automatize this all the way you would need a custom XSLT stylesheeet which would produce directly the XML format used by an Excel spreadsheet, something like this:

https://www.youtube.com/watch?v=KqeytEy_mvc

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