Exporting task to excel

mdslup
Posts: 156
Joined: Tue Mar 06, 2018 1:34 am

Exporting task to excel

Post by mdslup » Tue Jan 26, 2021 4:15 am

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: 7405
Joined: Fri Jul 09, 2004 5:18 pm

Re: Exporting task to excel

Post by Radu » Tue Jan 26, 2021 9:23 am

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