Transform xlsx to dita?

Here should go questions about transforming XML with XSLT and FOP.
msambasiva
Posts: 45
Joined: Tue Jul 17, 2018 6:57 am

Transform xlsx to dita?

Post by msambasiva » Wed Apr 08, 2020 12:39 pm

Hi,

We have a requirement to convert xlsx file to dita content. We already fulfilled the similar requirement to convert xml to dita using XSLT.

I've some thing in mind, Step 1) Convert xlsx to xml using java. Step 2) Convert xml to DITA using XSLT.

I am looking for best option to automate the transformation of xlsx file(s) to DITA in one step process. Can we use XSLT alone to achieve this task from xlsx to dita?

Please correct me if I am at wrong place to post this query.

Oxygen Editor 21.0
DITA-OT version 2.4.6

Thanks,
Samba.

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

Re: Transform xlsx to dita?

Post by Radu » Wed Apr 08, 2020 2:12 pm

Hi Samba,

If you want dynamic Excel to DITA conversions when you publish, maybe you can use this DITA Open Toolkit plugin:

https://github.com/oxygenxml/dita-excel

If you want to batch convert Excel to DITA prior to publishing maybe you can install this free Oxygen add-on:

https://github.com/oxygenxml/oxygen-resources-converter

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

msambasiva
Posts: 45
Joined: Tue Jul 17, 2018 6:57 am

Re: Transform xlsx to dita?

Post by msambasiva » Wed Apr 08, 2020 3:35 pm

Thanks Radu for quick response.
We need to convert the content of Excel file into multiple dita topics in batches. Could you suggest any clue on my requirement?
btw, I am not sure if it is intended, the two references from your previous reply pointing to the same plugin.

Regards,
Samba.

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

Re: Transform xlsx to dita?

Post by Radu » Wed Apr 08, 2020 3:49 pm

Hi Samba,

I updated my second link.
Maybe you can try our batch converter addon.

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

Post Reply