詳細検索

Plugins to Incorporate PHPE Excel Library in WordPress

Avatar
by maeno
2 min read

Plugins to Incorporate PHPE Excel Library in WordPress
Translated from 日本語 • View original

I created a plugin to incorporate "PHPExcel", which is famous as a free library that allows you to manipulate Microsoft Office Excel sheets from PHP, into WordPress.

I just introduced "PHPExcel" on my own intrasite built with WordPress, thinking that I couldn't search for the uploaded Excel sheet directly from the web, and it was surprisingly easy to use, and if I could make it a general-purpose plugin for WordPress, it would be useful to use it in various situations... That's what I thought.

This is my first time making a WordPress plugin, so there are many rough parts inside... Well, I'll just say that it's still version 0.1. The plugin is simple and just includes the included PHPExcel (version 1.7.7) to WordPress. As expected, that alone is not enough, so I tried to convert the uploaded Excel file or CSV file to CSV, HTML, PDF, etc. and use a shortcode to display the link. In the future, if we can extend this shortcode part to add a function that allows you to modify and output Excel sheets in WordPress... I'm thinking.

In addition, in the plugin settings, you can set the PHPExcel library to always be automatically included so that PHPExcel can be used on any page, or to read the library only when using shortcodes. In fact, PHPExcel is heavy, so it may be safer to turn off automatic include and only include it when you use it. It would have been nice to have registered a shortcode that only includes it, but it is not included at the moment (I will include it in the next version). For now, it is a plugin for people who write PHP code in posts and fixed pages, so it will be difficult to use unless it is generalized a little more (we will expand the functions in due course).

WordPress Bridge PHPExcel Plugin

Version: 0.2
Confirmation of action: WordPress 3.4.1 / PHPExcel 1.7.7
License: GPLv2

Related Articles