Exporting task to excel
Post here questions and problems related to editing and publishing DITA content.
-
- Posts: 167
- Joined: Tue Mar 06, 2018 1:34 am
Exporting task to excel
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?
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?
-
- Posts: 9434
- Joined: Fri Jul 09, 2004 5:18 pm
Re: Exporting task to excel
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
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
<oXygen/> XML Editor
http://www.oxygenxml.com
Return to “DITA (Editing and Publishing DITA Content)”
Jump to
- Oxygen XML Editor/Author/Developer
- ↳ Feature Request
- ↳ Common Problems
- ↳ DITA (Editing and Publishing DITA Content)
- ↳ SDK-API, Frameworks - Document Types
- ↳ DocBook
- ↳ TEI
- ↳ XHTML
- ↳ Other Issues
- Oxygen XML Web Author
- ↳ Feature Request
- ↳ Common Problems
- Oxygen Content Fusion
- ↳ Feature Request
- ↳ Common Problems
- Oxygen JSON Editor
- ↳ Feature Request
- ↳ Common Problems
- Oxygen PDF Chemistry
- ↳ Feature Request
- ↳ Common Problems
- Oxygen Feedback
- ↳ Feature Request
- ↳ Common Problems
- Oxygen XML WebHelp
- ↳ Feature Request
- ↳ Common Problems
- XML
- ↳ General XML Questions
- ↳ XSLT and FOP
- ↳ XML Schemas
- ↳ XQuery
- NVDL
- ↳ General NVDL Issues
- ↳ oNVDL Related Issues
- XML Services Market
- ↳ Offer a Service