GitHub - pihish/excel_database_lookup: Allows you to upload an Excel file and run it against a database based on your search criteria. A new Excel file is returned and downloaded to the user's computer. This is an extension of the phpExcel library.

pihish / excel_database_lookup Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Allows you to upload an Excel file and run it against a database based on your search criteria. A new Excel file is returned and downloaded to the user's computer. This is an extension of the phpExcel library.

0 stars 0 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 5 Commits
README		README
classes.php		classes.php
excelexample.xlsx		excelexample.xlsx
search.php		search.php

Repository files navigation

This is an extension of PHPExcel that will allow you to do a lookup of 
values in your Excel file against a database and return results based on 
those values.  Once search completes, a new Excel file is downloaded onto 
the client's computer with the added info.

Directions:
1. Upload the classes.php and search.php files into your PHPExcel root directory
2. Edit the search.php to fit customize it for the Excel file that you will be
working with.  The default configuration is designed to work with the 
'excelexample.xlsx' file found on the GitHub project
3. Make sure the 'upload_max_filesize' parameter in the 'php.ini' file is set 
to a size large enough to handle your Excel workbook
4. Run the script!