It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Office Excel Macro Formatting

Salman Shoaib Aug 02, 2017

Hi,

 

I'm using Confluence at work, version 5.10.3

I'm trying to publish an excel file using the Office Excel Macro but when the page renders the columns are very large and the expand horizontally so a user has to scroll right. I'd like to specify the column width and have the text within the cells wrap. My question is:

- is formatting flexibility available within the Office Excel Macro? If yes, please teach me.

- is Office Excel Macro the best way to display an excel file within Confluence 5.10.3?

 

Thanks in advance

 

1 answer

0 votes
Jaclyn DePinho Aug 02, 2017

Hi Salman, 

I don't work too much in the Office Excel Macro, however, Addteq provides a great add-on that allows you to work in an Excel like spreadsheet right in Confluence.

Try Excellentable here: https://marketplace.atlassian.com/plugins/Addteq.Excellentable/server/overview

I know there is a free 30 day trial available so that you can begin working now!  

Feel free to comment back if you have any questions.

Salman Shoaib Aug 07, 2017

Thanks Jaclyn,

I did try the Excellentable macro and it's pretty good but I'm trying to find how to perhaps code certain column widths in HTML. My table has close to 2,000 rows and 11 columns (so its big) and the built in features of adjusting column widths is not working due to the sheer size. The Office Excel macro is pretty good too but again the presentation is no good.

I'm looking for a nice neat table laid out in full on the page so users can CTRL+F on the page and search for anything OR simply scroll up/down.

IF anyone knows any way to code column widths in HTML please let me know.

Sukhbir Dhillon Nov 02, 2017 • edited

@Salman Shoaib I'm the product owner of Excellentable. We are working on a functionality to render spreadsheet as html as an option in the view mode. We recently released collaborative editing in beta mode and our team is busy ironing out some of the issues to take it out of beta. Providing different view and print options is in road map. 

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

860 views 0 19
Read article

Community Events

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

Events near you