Click here to register!
Difference between revisions of "Import Tables from Excel"
From energypedia
***** (***** | *****) m |
***** (***** | *****) m |
||
| Line 1: | Line 1: | ||
| + | |||
{{template:Tabs-1 | {{template:Tabs-1 | ||
|Energypedia_Community:_Help|Back to the Help Portal | |Energypedia_Community:_Help|Back to the Help Portal | ||
| | | | ||
}} | }} | ||
| + | |||
= Import Tables = | = Import Tables = | ||
| Line 26: | Line 28: | ||
'''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 33: | Line 35: | ||
#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}} | <br/>{{Help Magic Words}} | ||
| − | |||
| − | |||
Revision as of 13:04, 20 May 2020
Import Tables
Instructions how to Import Table from Excel
- 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
