Difference between revisions of "Import Tables from Excel"
From energypedia
***** (***** | *****) m (Ranisha moved page Import Tables from Excel to Help:Import Tables from Excel without leaving a redirect) |
***** (***** | *****) m |
||
| Line 1: | Line 1: | ||
| + | |||
{{#widget:YouTube|id=EodPrJYTEdc|height=300|width=400}} | {{#widget:YouTube|id=EodPrJYTEdc|height=300|width=400}} | ||
| Line 5: | Line 6: | ||
= Instructions = | = Instructions = | ||
| − | + | #Copy the desired table from excel.<br/> | |
| − | + | #Right click on the edit area and then click on paste to insert the table into your article. Please note that the "paste option" is different than the "paste as the plain text" option in the edit toolbar. | |
| − | |||
[[File:Table 2.JPG|border|left|600px|Copying table from excel|alt=Table2.JPG]]<div style="clear: both"></div> | [[File:Table 2.JPG|border|left|600px|Copying table from excel|alt=Table2.JPG]]<div style="clear: both"></div> | ||
The table looks like the following: | The table looks like the following: | ||
| Line 27: | Line 27: | ||
#Copy the "result" | #Copy the "result" | ||
#Paste it to the energypedia page (the editor must be in the "wikitext modus", therefore you have to switch to "Wiki TextEditor") | #Paste it to the energypedia page (the editor must be in the "wikitext modus", therefore you have to switch to "Wiki TextEditor") | ||
| + | |||
| + | <br/> | ||
| + | |||
| + | = Further Information = | ||
| + | <ul style="list-style-image: url("images/bullet-icon.png"); font-size: 13.6px;"> | ||
| + | <li>[[Energypedia_Community:_Help|Help portal on energypedia]]</li> | ||
| + | <li></li> | ||
| + | </ul> | ||
<br/>__NOAUTHORLIST__ | <br/>__NOAUTHORLIST__ | ||
| − | [[Category:Help]] | + | |
| + | [[Category:Help|{{PAGENAME}}]] | ||
Revision as of 09:06, 14 July 2016
Instructions
- Copy the desired table from excel.
- Right click on the edit area and then click on paste to insert the table into your article. Please note that the "paste option" is different than the "paste as the plain text" option in the edit toolbar.
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 switch to "Wiki TextEditor")
Further Information
