Excel
Overview #
Excel package helps you to work with Excel. It can help to pull data from Excel file as well as push data to Excel file. Underline of ExcelDataSource is the open-source library called phpoffice/PHPExcel which helps us to read various Excel version.
Installation #
By downloading .zip file #
- Download zip file from My Licenses
- Unzip
- Copy the folder
excelintokoolreportfolder, it will look like below:
koolreport
├── core
├── excel
By composer #
If you have purchased the package then you can follow these steps to install
- Login to koolreport.com
- Go to My Licenses
- Click Get Token For Composer button
- Copy the text and save to file
auth.jsonnext tocomposer.json - Add the repositories to
composer.jsonlike below - Run
composer updateto install package
composer.json
{
"repositories":[
{"type":"composer","url":"https://repo.koolreport.com"}
],
"require":{
"koolreport/excel":"*",
...
}
}
Your auth.json will look like this:
{
"http-basic": {
"repo.koolreport.com": {
"username": "your@email.com",
"password": "your-secret-token"
}
}
}
Note: Please add your auth.json to .gitignore as it contains your secret login information.
Get started with KoolReport
KoolReport will help you to construct good php data report by gathering your data from multiple sources, transforming them into valuable insights, and finally visualizing them in stunning charts and graphs.