Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Section
Column
width15%
Excerpt Include
pluglib:Advanced Macros Pluginpluglib:
Advanced Macros Plugin
nopaneltrue
Column
width60%
Deck of Cards
width907px
idOffice
Card
labelOverview

Office Connector plugin

The Office Connector allows you to use Microsoft Office or OpenOffice to create and edit rich content for your Confluence wiki.

The features of the Office Connector plugin:
  • Import Word documents
  • Seamlessly edit Confluence content in Microsoft Word
  • View and edit Office documents from within Confluence
  • Choose between OpenOffice and Microsoft Office, if you are using Firefox as your browser.
This plugin includes the following macros:
  • view - Display an Office file in a Wiki page.
    Note
    titleThe Office Connector only supports .doc and .xls file types. You can convert the format of a file by clicking "Save As.." and selecting 'Word 97 - 2004 Document' in the "Format" dropdown

Card
labelDocumentation
Deck of Cards
idofficem

Card
labelImporting an Office Document

You can import a Word document into the Wikis and convert it into a Wiki page.

Importing an Office Document as a Wiki Page

1. Navigate to the page where you wish to import to.

Toggle Cloak
id3
2. Click on the 'Tools' menu and select 'Doc Import'.

Cloak
id3

Toggle Cloak
id4
3. Select the document you want to import and click 'Import'.

Cloak
id4

Browse

Search your local directories for a file to import.

Import

Import selected document.

5Advanced

Opens the "Advanced' options menu.

5


Use these options to choose how to import the document, either as a new page or as content on a page, etc. If the document has defined headings, you can split the file into multiple pages or as multiple pages based on the headings.

Card
labelExporting as an Office Document

You can also export a Wiki page as an editable Office document.

Exporting a Wiki page as an Office Document

1. Navigate to the page you wish to export.

Toggle Cloak
id1
2. Click on the 'Tools' menu.

Cloak
id1

Toggle Cloak
id2
3. Select 'Export to PDF' or 'Export to Word' and click the 'Ok' button in the pop-up window to export the Wiki page as a PDF or Word document. If the Wiki page is exported as a Word document - it can be opened and edited using Office Software.

Cloak
id2

Card

Card
labelview

Displays an Excel (xls) or Word document (doc) file in a Wiki page.

Note
titleViewing Powerpoint and PDF files with the *view* macro is not supported

The Code

Displays an Excel file:

Code Block

{viewxls:name=workbook.xls}

Displays a Word document file:

Code Block

{viewdoc:name=Testdoc.doc}

Toggle Cloak
id6
Result

Cloak
id6

Displays an Excel file:

workbook.xls

Displays a Word document file:

Testdoc.doc

Toggle Cloak
id7
Parameters

Cloak
id7
View Excel Parameters

Name

Required?

Default

Description

name

none

This is the file name of the document to be displayed. The document must be attached to a wiki page on your Confluence site.

col

Last column with content

Enter the number of the last column you want displayed, starting from '0' as the first column. For example, the following code will show the first 3 rows and the first 3 columns:

grid

true

Select the check box in the macro browser (true in Wiki Markup) to show grid lines around each cell of the Excel spreadsheet. Clear the check box in the macro browser (false in Wiki Markup) to hide these grid lines.

page

The page which contains the viewxls macro

Enter a page name, if you wish to display a document which is attached to another Confluence page. For example:

row

Last row with content

Enter the number of the last row you want displayed, starting from '0' as the first row. For example, the following code will show the first 3 rows and the first 3 columns:

sheet

First worksheet in the spreadsheet

Enter the name of the worksheet that you want displayed.

space

The space of the page which contains the viewxls macro

Enter a space key, if you wish to display a document which is attached to a page in another Confluence space. For example:

date

none

If the Page Name refers to a blog post instead of a conventional page, enter the date of the post in the form mm/dd/yyyy.

View Word Document Parameters

Name

Required?

Default

Description

name

none

The file name of the Office Word document to be displayed. The document must be attached to a wiki page.

page

The page which contains the viewdoc macro

Enter a page name, if you wish to display a document which is attached to another Confluence page. For example:

space

The space of the page which contains the viewdoc macro

Enter a space key, if you wish to display a document which is attached to a page in another Confluence space. For example:

date

none

If the Page Name refers to a blog post instead of a conventional page, enter the date of the post in the form mm/dd/yyyy.

Card

Deck of Cards

{deck:id=Office|width=907px} {card:label=Overview} h4. Office Connector plugin The Office Connector allows you to use Microsoft Office or OpenOffice to create and edit rich content for your Confluence wiki. h5. The features of the Office Connector plugin: * Import Word documents * Seamlessly edit Confluence content in Microsoft Word * View and edit Office documents from within Confluence * Choose between OpenOffice and Microsoft Office, if you are using Firefox as your browser. {card} {card:label=Documentation} {deck:id=officem} {card:label=Importing an Office Document} You can import a Word document into the Wikis and convert it into a Wiki page. h3. Importing an Office Document as a Wiki Page *1.* Navigate to the page where you wish to import to. {toggle-cloak:id=3}*2.* Click on the 'Tools' menu and select 'Doc Import'. {cloak:id=3} !export_import.png|border=2,bordercolor=grey! {cloak} {toggle-cloak:id=4}*3.* Select the document you want to import and click 'Import'. {cloak:id=4} !doc_import.png|border=2,bordercolor=grey! ||Browse | Search your local directories for a file to import.| ||Import | Import selected document.| ||{toggle-cloak:id=5}Advanced| Opens the "Advanced' options menu.| {cloak:id=5} !advanced.png|border=2,bordercolor=grey! Use these options to choose how to import the document, either as a new page or as content on a page, etc. If the document has defined headings, you can split the file into multiple pages or as multiple pages based on the headings. {cloak} {card} {card:label=Exporting as an Office Document} You can also export a Wiki page as an editable Office document. h3. Exporting a Wiki page as an Office Document *1.* Navigate to the page you wish to export. {toggle-cloak:id=1}*2.* Click on the 'Tools' menu. {cloak:id=1} !export_import.png|border=2,bordercolor=grey! {cloak} {toggle-cloak:id=2}*3.* Select 'Export to PDF' or 'Export to Word' and click the 'Ok' button in the pop-up window to export the Wiki page as a PDF or Word document. If the Wiki page is exported as a Word document - it can be opened and edited using Office Software. {cloak:id=2} !pop-up.png|border=2,bordercolor=grey! {cloak} {Card} {deck} {card} {deck} {roundrect:bgcolor=#828282|width=909px|height=50px|corners=false,false,true,true} {roundrect}
Round Rectangle
cornersfalse,false,true,true
bgcolor#828282
width909px
height50px
Wiki Markup

Column
width20%