Encountering Issues when using Office Excel Macro to imbed and view worksheets

Question

I am encountering issues with the Office Excel macro displaying the CORRECT worksheet.  I have a workbook with 4 worksheets,  I am trying to display each worksheet.  Sometimes it works and sometimes not.

I have been able to manipulate the contents of the worksheets, removing some of the special characters, like the apostrophe ('), so EVENTUALLY the correct worksheet appears in the DEV Confluence environment.

Are there any specific guidelines for entering the data in the macro or pointers on how to format the spreadsheet so that the macro will display correctly?

Thank you!

Dominic Lagger · Answer

I'm not aware, that there are restrictions or limitations...

Also the official documentation didn't say anything. You could try to paste the macro via "wiki markup":

{viewxls:col=5|page=Docs|name=My document.xls|grid=false|sheet=mysheet|row=5}

Perhaps, with this it works. Perhaps with the macro itself there are some hidden letters or blanks.

Regards, Dominic

Linda Shady · Answer

Hello Dominic,

I have had success with the macro in displaying 4 worksheets on one page in a page I created a while ago.  In this case, I  went to the QA environment and have been successful with the macro in displaying 4 different worksheets from the workbook I am currently working with.  I did have to go through the worksheets and remove some apostophes (') from the content.  I then went to work in the Production environment.  However, I cannot get two of the worksheets to display in the Production environment.  Do you know if there are any specific parameters outlined for this macro that I need to follow, or any hints on formatting of the original workbook that  could help resolve this issue?

Thank you so much!

Linda

Dominic Lagger · Answer

Hi @Linda Shady

Do you try to display each worksheet on the same page?

In the office excel macro, you can set the worksheet.

Keep in mind, the office Excel macro isn't excel. So really special and fancy designs perhaps can't display correctly. I tried with some really easy one and it worked:

* On this page there are 4 office excel macros, each one displays another worksheet

Hope this helped

Regards, Dominic