Page 1 of 1
Excel to DITA join cells?
Posted: Thu Jun 22, 2023 1:41 pm
by Gimber78
Hi! is it possible to save the union of cells when converting from xlsx to dita?
2023-06-22_13-34-47.jpg
2023-06-22_13-36-09.jpg
Re: Excel to DITA join cells?
Posted: Thu Jun 22, 2023 2:24 pm
by Radu
Hi,
I created a small Excel sheet which has a cell spanning multiple rows and columns.
I tried using Oxygen 25.1 to copy the cells from Excel and then paste them in a DITA topic and it seems to work for me.
Screenshot 2023-06-22 at 14.23.09.png
How do you convert the Excel to DITA on your side? What version of Oxygen are you using?
Regards,
Radu
Re: Excel to DITA join cells?
Posted: Thu Jun 22, 2023 2:41 pm
by Gimber78
Hi Radu!
Oxygen 25.0
Yes, copying and pasting works.
But there are a lot of tables in the excel file and it's not convenient.
After running the conversion script, the join of the cells gets lost
2023-06-22_14-37-48.jpg
Re: Excel to DITA join cells?
Posted: Thu Jun 22, 2023 3:10 pm
by Radu
Hi,
I see, you are using our batch documents converter add-on.
We have an internal issue to improve the batch converter to also take into account cell spans, I added your feedback on the opened issue.
If we manage to fix it in a future version I will update this forum thread.
Regards,
Radu
Re: Excel to DITA join cells?
Posted: Thu Jul 13, 2023 12:56 pm
by Gimber78
HI!
Wrote a python converter
xlsx to xml(data)
there should be no empty "None" values in the original excel.
Accepts a file as input sample2.xlsx
On the way out output.xml
Maybe it will be useful to someone.
Tabl in excel
excel.jpg
tabl in xml
oxy_xml.jpg
out pdf
pdf.jpg
convert.zip
Re: Excel to DITA join cells?
Posted: Thu Jul 13, 2023 2:16 pm
by Radu
Hi,
Thanks for taking the time to post an update with your solution!
Regards,
Radu
Re: Excel to DITA join cells?
Posted: Fri Jul 14, 2023 4:57 pm
by Gimber78
update, bugs fixed.
tables with more than 19 rows did not work (etc.)
converter_xlsx_xml_v4_.py.zip