Import Tables from Excel

Revision as of 13:53, 13 November 2014

1. Copy the desired table from excel.

2. Paste the table into your article

The table looks like the following

3. Right click on the table and set the table properties as follows: border=1, cell padding=1 and cell spacing =1.

Alternatively

If you want to transfer an Excel table into energypedia, you can use the excel2wiki webpage.

Copy the table
Paste it into the box on the above mentioned webpage
Copy the "result"
Paste it to the energypedia page (the editor must be in the "wikitext modus", therefore you have to "Disable rich editor")

@@ Line 1: / Line 1: @@
-If you want to transfer an Excel table into energypedia, you can use the [http://excel2wiki.net/index.php excel2wiki webpage].&nbsp;
-<u>Just copy a table to this site and paste&nbsp;thereafter the&nbsp;[http://en.wikipedia.org/wiki/Wikitext wikitext] into energypedia:</u>
+. Copy the desired table from excel.
+. Paste the table into your article
+{| border="1" cellspacing="1" cellpadding="1"
+|-
+| [[File:Table 2.JPG|none|600px|alt=Table2.JPG]]
+|}
+<br clear=all><br/>
+The table looks like the following
+{| border="1" cellspacing="1" cellpadding="1"
+|-
+| [[File:Table3.JPG|none|600px|alt=Table2.JPG]]
+|}
+. Right click on the table and set the table properties as follows: border=1, cell padding=1 and cell spacing =1.
+{| border="1" cellspacing="1" cellpadding="1"
+|-
+| [[File:Table5.JPG|none|600px|alt=Table2.JPG]]
+|}
+'''Alternatively'''
+If you want to transfer an Excel table into energypedia, you can use the [http://excel2wiki.net/index.php excel2wiki webpage].
 #Copy the table
 #Paste it into the box on the above mentioned webpage
-#Copy the text under "result"
+#Copy the "result"
 #Paste it to the energypedia page (the editor must be in the "wikitext modus", therefore you have to "Disable rich editor")