I have a Python program that reads in an Excel sheet and turns it into Word based documentation. I copy this and paste it into a Confluence page and all the nice table formatting is lost. Specifically, all of the columns are the same width in Confluence; the width of the source is lost. This worked perfectly in Mindtouch, our previous Wiki. There are over 100 tables in the output and I had to spend nearly half an hour manually re-adjusting the tables so they looked the same.
I also tried to save the word file as HTML. The HTML looked great. The copy-pasted Confluence page not so much. Can anyone shed some light on how this might be done. As far as I can tell I cannot paste raw HTML into the page. Again Mindtouch, which is 10 years older than Confluence allowed me to edit the HTML with a single push button then copy-paste raw HTML in there.
I have now rewritten my Python to write pages directly via the RES API using the Atlassian confluence.py library:
Even then I had to write the page as an Editor V1 page. When I write it as an editor V2 file the column widths are lost in exactly the same way as the copy-paste from word. This is a severe limitation of the latest incarnation of Confluence and this user is unhappy with Confluence at this point.
The markup used is not HTML. Confluence clearly felt the need to reinvent the wheel here and ended up with a square one. For other users benefit, the markup language is shown here::
Many of the normal features of HTML are simply not there, giving very little control over the look-and-feel of the page. I had to fudge the table column widths using extensive preprocessing of the data including adding non-breakable spaces to the table titles using trial and error.
Thanks for the answer. To be clear, I don't want to have to use html, I would rather that the word importer preserves all of the formatting in the source. Since I can do it manually it is clearly possible to create a Confluence page that looks the way I want, its just that I have not found a way yet of doing it automatically.
Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events