Page 1 of 1

Exporting task to excel

Posted: Tue Jan 26, 2021 4:15 am
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?

Re: Exporting task to excel

Posted: Tue Jan 26, 2021 9:23 am
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