TableHelp

From AOP-Wiki
Jump to: navigation, search

Entering tables like this one...

Cell A1 Cell B1 Cell C1 Cell D1
Cell A2 Cell B2 Cell C2 Cell D2
Cell A3 Cell B3 Cell C3 Cell D3

... into a wiki page is not a straightforward task, as Wiki tables are encoded as a series of special characters that are not intuitive.

However, there are workarounds, and two quite simple ones are presented in this article.

Note: These workarounds use third party software. Please see our disclaimer.


Creating Tables in Microsoft Excel ® and importing them into the Wiki

Basic skills in Microsoft Excel ® are necessary.

Create the table in Microsoft Excel ®

Create the table you want to insert into the Wiki in Microsoft Excel ®

Select the table and copy it.

TableHelp Excel01.JPG

Open third party party software Excel2Wiki

Open the third party software Excel2Table from the Internet and paste the copied table into the window provided.

TableHelp Excel02.JPG

Uncheck the "format header" checkbox.

Click "Submit Query".

Copy Wiki table code

The tool shows the table code that is necessary to insert into the Wiki:

TableHelp Excel03.JPG

Select the code and copy it.

Paste the code into the appropriate Wiki page

Open the Wiki page in Edit mode, and paste the code into an appropriate place. If you want to have borders around the table cells, add the border="1" code, as shown below.

TableHelp Excel04.JPG

Save the Wiki page, and the table is shown.

Creating Tables in Microsoft Word ® and importing them into the Wiki

Basic skills in Microsoft Word ® are necessary.

Install the Microsoft Word Add-In for Media Wiki

Using Microsoft Word ® to prepare tables for using them in the Wiki requires the installation of the Word "Media Wiki" add-in, which can be found here: http://www.microsoft.com/en-us/download/details.aspx?id=12298

TableHelp Word01.JPG

You need administrator rights on your workstation to install the add-in, and you might have to ask your local System Administrator for assistance.

Create the table in Microsoft Word ®

TableHelp Word02.JPG

Save the table as "MediaWiki" file

When saving the file, select the MediaWiki (*.txt) option:

TableHelp Word03.JPG

Open the .txt file with the Notepad

Open the file you just saved, using the Notepad:

TableHelp Word04.JPG

Select and copy the code.

Paste the code into the appropriate Wiki page

Open the Wiki page in Edit mode, and paste the code into an appropriate place. If you want to have borders around the table cells, add the border="1" code, as shown below.

TableHelp Word05.JPG

Save the Wiki page, and the table is shown.

Disclaimer

Any links to third-party software available on this website are provided “as is” without warranty of any kind, either expressed or implied and such software is to be used at your own risk. The use of the third-party software links on this website is done at your own discretion and risk and with agreement that you will be solely responsible for any damage to your computer system or loss of data that results from such activities. You are solely responsible for adequate protection and backup of the data and equipment used in connection with any of the software linked to this website, and we will not be liable for any damages that you may suffer connection with downloading, installing, using, modifying or distributing such software. No advice or information, whether oral or written, obtained by you from us or from this website shall create any warranty for the software