Simple Plugin to import Excel files to WordPress and use the Data in your theme.
No Database entries are created.
| Author: | Vincent Schroeder (profile at wordpress.org) |
| WordPress version required: | 3.5.1 |
| WordPress version tested: | 4.4 |
| Plugin version: | 1.0.5 |
| Added to WordPress repository: | 27-11-2013 |
| Last updated: | 22-12-2015
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
|
| Rating, %: | 80 |
| Rated by: | 16 |
| Plugin URI: | http://webteilchen.de |
| Total downloads: | 28 464 |
| Active installs: | 3 000+ |
 Click to start download |
|
Simple plugin to import excel files (.xlsx only) to WordPress and use the data in your theme. No database entries are created. All file & json based. You can use as many excel files on one page as you want.
For example, if you have a guestlist in excel and you want to show it in a special style on your website, you can easily upload the excel file in your admin interface an then use wp_excel_cms_get("guestlist"); to get the structured data in your template.
If you want to use the Table in your post or page, you can use the Shortcode [wp_excel_cms name="guestlist" sheet="1"] .
The string "guestlist" have to be replaced by your given excel file name.
Short Code
[wp_excel_cms name="guestlist"]Example Usage in Theme:
<?php $data = wp_excel_cms_get("guestlist"); ?>
<?php foreach($data as $entry): ?>
column 1: <?php echo $entry[0]; ?><br />
column 2: <?php echo $entry[1]; ?><br />
column 3: <?php echo $entry[2]; ?><br />
<hr />
<?php endforeach; ?>I hope you enjoy this plugin. Give me feedback to improve it.