Confluence Upload Excel Spreadsheet Into Task List

Screenshot: a folio with an Part Excel macro displaying an Excel spreadsheet.

In that location are other ways to add a spreadsheet to your page:

• Insert the file directly into the page. We'll display a PDF thumbnail of the canvass. This is okay for unproblematic spreadsheets simply may not be suitable for complex or multi-canvas files.
• Employ the Widget Connector Macro to embed a Google Canvas.

Add this macro to your page

To add the Part Excel macro to a page:

1. Upload the Excel file to your page, so publish the page. Run across Upload Files to larn how to practice this.

2. From the editor toolbar, choose Insert > Other Macros.

3. ChooseOffice Excel from theConfluence content category.
4. Select the attached file you want to brandish.
5. CullInsert.

You can then publish your page to see the macro in action.

Screenshot: configuring the Office Excel macro in the macro browser.

Edit the attached file

If you have Excel installed, you can edit the attached file, and automatically re-upload the file back to Confluence.

See Edit Files for more data on the ways to practise this.

Change the macro parameters

Macro parameters are used to modify the behaviour of a macro.

To alter the macro parameters:

1. In the editor, click the macro placeholder and chooseEdit.
   
2. Update the parameters as required then cullInsert.

Here's a list of the parameters available in this macro.

Parameter	Default	Clarification
Page Name	The page which contains the macro	Enter a page name, if you wish to display a document which is attached to another Confluence page.
File Proper noun	none	The file name of the Office or PDF document to be displayed. The document must exist fastened to a page on your Confluence site. If the file does not announced, publish the page, then caput back into the editor and try once again.
Testify Grid?	true	Select to evidence grid lines around each jail cell of the Excel spreadsheet. Clear to hide these filigree lines.
Worksheet Name	Last worksheet viewed in the spreadsheet	The name of the worksheet that you want displayed.
Last Row	Last row with content	The number of the last row you want displayed, starting from '0' as the first row.
Last Column	Last column with content	The number of the last cavalcade you want displayed, starting from '0' as the first cavalcade. Hint for reducing the size of the spreadsheet: Use the Final Cavalcade and Final Row parameters to reduce the size of the spreadsheet displayed on the wiki folio. This is especially useful to prevent the display from showing empty cells. This will besides assistance to prevent 'out of memory' errors.

Where the parameter name used in Confluence storage format or wikimarkup is different to the label used in the macro browser, information technology will be listed beneath in brackets (example).

Limitations

The Office file must be attached to the electric current page, or some other Confluence page. The macro can't display alive Office 365 files. If y'all utilize Role 365, you'll need to download the file, and then upload information technology to Confluence to display information technology with this macro. Alternatively, y'all could just link to the Office 365 file.

If your uploaded file does not appear in the File Name bill of fare in the macro browser, yous'll need to publish the page, and so hitEdit to render to the editor.

Rendering very large or complex files tin can put a lot of load on Confluence. For this reason, in Confluence Data Center we'll prompt you to download the file if nosotros tin can't brandish with a set time limit. This limit varies depending on system backdrop set by your administrator, but is generally nigh thirty seconds. You can continue to view other content on the page while we attempt to display the file contents.

Other ways to add this macro

Add together this macro as you type

Type { followed by the first of the macro proper noun, to see a listing of macros.

Add together this macro using wiki markup

This is useful when you want to add together a macro outside the editor, for example as custom content in the sidebar, header or footer of a space.

Macro name:viewxls

Macro trunk: None.

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

logandisper1982.blogspot.com

Source: https://confluence.atlassian.com/doc/office-excel-macro-375849173.html

Share this post