|
|
| (12 intermediate revisions by 4 users not shown) |
| Line 1: |
Line 1: |
| − | To import Tables from Excel see [http://www.energypedia.info/index.php/Help:Wiki_Manual#Copy_Ms_Word_Documents_with_OpenOffice_to_Wiki '''Copy Ms Word Documents with OpenOffice to Wiki'''.]
| + | {{#widget:YouTube|id=EodPrJYTEdc|height=300|width=400}} |
| | | | |
| − | Note, however, that the Excel table is saved in a word document. This word document is needed then from step 5.
| |
| | | | |
| − |
| + | = Instructions = |
| | | | |
| − | Or use the webpage [http://excel2wiki.net/index.php http://excel2wiki.net/index.php] to copy a table to this webpage and then as [http://en.wikipedia.org/wiki/Wikitext wikitext] into energypedia.
| + | 1. Copy the desired table from excel. |
| | | | |
| − | #Copy the table | + | 2. 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. |
| − | #paste it into thr box on the above mentioned webpage | + | [[File:Table 2.JPG|border|left|600pxpx|Copying table from excel|alt=Table2.JPG]]<div style="clear: both"></div> |
| − | #Copy the text under "result" | + | The table looks like the following: |
| − | #Paste it to the energypedia page (Editor mus be in "Wikitext modus" [[Help:Wiki Manual#Copy_Ms_Word_Documents_with_OpenOffice_to_Wiki|see step 9]] "OpenOffice") | + | |
| | + | [[File:Table3.JPG|border|left|600pxpx|table|alt=Table2.JPG]] |
| | + | <div style="clear: both"></div> |
| | + | 3. Right click on the table and set the table properties as follows: border=1, cell padding=1 and cell spacing =1. |
| | + | |
| | + | [[File:Table5.JPG|border|left|600pxpx|table|alt=Table2.JPG]] |
| | + | <div style="clear: both"></div> |
| | + | <br/> |
| | + | |
| | + | '''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 "result" |
| | + | #Paste it to the energypedia page (the editor must be in the "wikitext modus", therefore you have to switch to "Wiki TextEditor") |
| | + | |
| | + | <br/>__NOAUTHORLIST__ |
| | + | |
| | + | [[Category:Articles]] |
Latest revision as of 10:19, 9 February 2016
[edit] Instructions
1. Copy the desired table from excel.
2. 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")
