Page 1 of 1

Transform xlsx to dita?

Posted: Wed Apr 08, 2020 12:39 pm
by msambasiva
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.

Re: Transform xlsx to dita?

Posted: Wed Apr 08, 2020 2:12 pm
by Radu
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

Re: Transform xlsx to dita?

Posted: Wed Apr 08, 2020 3:35 pm
by msambasiva
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.

Re: Transform xlsx to dita?

Posted: Wed Apr 08, 2020 3:49 pm
by Radu
Hi Samba,

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

Regards,
Radu