Download the PHP package vishwayon/phpstep without Composer
On this page you can find all versions of the php package vishwayon/phpstep. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download vishwayon/phpstep
More information about vishwayon/phpstep
Files in vishwayon/phpstep
Package phpstep
Short Description PHP Spreadsheet Template Engine
License MIT
Homepage http://www.vishwayon.com/
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package phpstep
PhpStep
PHP Spreadsheet Template Engine
Thanks to PHPOffice/PhpSpreadsheet, we are able to generate various types of spreadsheets directly from php. PhpStep is an attempt to automate data populated spreadsheets using template tags.
In this project, we put together an existing xslx file containing some template attributes and a structured model or json data to output a ready to use spreadsheet with user readable data.
When to use PhpStep?
When you have a requirement to generate a Spreadsheet as output from PHP model objects then PhpStep can be very helpful. Typically you would write code to access data form model objects and use a package like PHPOffice/PhpSpreadsheet to render the output. The output spreadsheet reports might be designed by analysts to meet business needs and this requirement requires developers to codify it and go through a QA process. PhpStep can eliminate the process of having to push the requirement thorugh a SDLC cycle and gives a person with minimal coding skills the ability to generate these reports.
When to use StepService.php?
You can publish the StepService.php in any web server and call the page with json data, templated spreadsheet and the output file name. It would render the output file from within an independent process. For request parameters, refer the documentation of StepService.php
Dependencies
- PHPOffice/PhpSpreadsheet
- PHP 7.2
Installation and Usage
Or, use the git repository.
Supported Template Tags
- $F{field_name} - A field/property in the class/data source
- $Each{Iterator} - Any collection object/array implementing Iterator interface
Sample Code
First, create an sample.xlsx file with following structure:
| A | B |
|---|---|
| $F{message} | |
| Country | Population |
| $Each{stats} | |
| $F{country} | $F{population} |
You can apply various formats to the cells and also create normal formulas.
For complex methods, refer to test/TestRenderWorksheet.php and testData.xlsx
Limitations
- Absolute formulas in the worksheet (e.g: $D$13) will not work. They would reference incorrect cells after rendering
License
PhpStep is licensed under MIT.
