Knowledge fuels change - Support energypedia!
For over 10 years, energypedia has been connecting energy experts around the world — helping them share knowledge, learn from each other, and accelerate the global energy transition.
Today, we ask for your support to keep this platform free and accessible to all.
Even a small contribution makes a big difference! If just 10–20% of our 60,000+ monthly visitors donated the equivalent of a cup of coffee — €5 — Energypedia would be fully funded for a whole year.
Is the knowledge you’ve gained through Energypedia this year worth €5 or more?
Your donation keeps the platform running, helps us create new knowledge products, and contributes directly to achieving SDG 7.
Thank you for your support, your donation, big or small, truly matters!
Difference between revisions of "Import Tables from Excel"
***** (***** | *****) m |
***** (***** | *****) m |
||
| (8 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{ | + | {{Back to Help Portal}} |
| − | + | ||
| − | + | = Importing Tables from Excel= | |
| − | |||
{{#widget:YouTube|id=EodPrJYTEdc|height=300|width=400}} | {{#widget:YouTube|id=EodPrJYTEdc|height=300|width=400}} | ||
| − | <br/> | + | <br /> |
| − | = Instructions = | + | =Instructions = |
| − | #Copy the desired table from excel.<br/> | + | #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. | #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> | ||
| Line 21: | Line 20: | ||
[[File:Table5.JPG|border|left|600px|table|alt=Table2.JPG]] | [[File:Table5.JPG|border|left|600px|table|alt=Table2.JPG]] | ||
<div style="clear: both"></div> | <div style="clear: both"></div> | ||
| − | <br/> | + | <br /> |
'''Alternatively''' | '''Alternatively''' | ||
| − | If you want to transfer an Excel table into energypedia, you can use the [http://excel2wiki.net/index.php excel2wiki webpage]. | + | If you want to transfer an Excel table into energypedia, you can use the [http://excel2wiki.net/index.php excel2wiki webpage]. (alternatively, http://wang.wustl.edu/mediawiki/extensions/index.php) |
#Copy the table | #Copy the table | ||
| Line 32: | Line 31: | ||
#Paste it to the energypedia page (the editor must be in the "wikitext mode") | #Paste it to the energypedia page (the editor must be in the "wikitext mode") | ||
| − | + | Other option: | |
| − | |||
| − | |||
| − | |||
| − | *[ | + | *Table generator: [http://www.tablesgenerator.com/mediawiki_tables Generate tables in MediaWiki format] |
| − | + | <br />{{Help Magic Words}} | |
| − | |||
| − | |||
Latest revision as of 10:50, 25 January 2022
Importing Tables from Excel
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. (alternatively, http://wang.wustl.edu/mediawiki/extensions/index.php)
- 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 mode")
Other option:
- Table generator: Generate tables in MediaWiki format
