News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Maarten Balliauw's Blog:
Reuse Excel business logic with PHPExcel
May 06, 2008 @ 07:51:38

Maarten Balliauw has made a new blog post today about a method he's using to help reuse some of the business logic that Excel spreadsheets can have in a PHP script with help from PHPExcel.

In many companies, business logic resides in Excel. This business logic is sometimes created by business analysts and sometimes by business users who want to automate parts of their everyday job using Excel. [...] Did you know you can use PHPExcel to take advantage of the Excel-based business logic without having to worry about duplicate business logic?

He creates a quick example of a script that can take in an Excal file and pull it into a PHPExcel object, ready for manipulation. He fills in values for the already defined fields (like "carColor" or "leatherSeats") and uses the getCalculatedValue method to perform the action on the cell. The output is dropped into a variable that can be echoed out or used later on in the PHP script.

0 comments voice your opinion now!
phpexcel excel business logic reuse tutorial example


blog comments powered by Disqus

Similar Posts

PHPBuiilder.com: Using Get and Post Methodology in AJAX Applications

Evan Coury: Getting started with the ZF2 skeleton and ZfcUser

PHPMaster.com: Data Structures for PHP Devs: Stacks and Queues

Ade Slade's Blog: Integrating Zend Framework 1 and Pimple

DeveloperTutorials.com: Effective Geotargeting with PHP


Community Events





Don't see your event here?
Let us know!


series community framework podcast version tool update introduction interview package composer security voicesoftheelephpant language library symfony install opinion laravel release

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework