| Last Updated | | Ratings | | Unique User Downloads | | Download Rankings |
2023-03-28 (3 months ago)  | | Not yet rated by the users | | Total: 103 | | All time: 9,671 This week: 121 |
|
| Description | | Authors Maarten Balliauw
Mark Baker
Franck Lefevre
Erik Tilt
Adrien Crivelli
Contributor
|
This package can store financial data in an SQL server from an Excel file.
It provides a form script to upload an Excel spreadsheet in XLSX format.
The package also provides a class to process the uploaded Excel spreadsheet files, parse the file to extract financial value, and store the values in SQL server details. Innovation Award
April 2023
Number 3 |
Companies develop many PHP applications to serve the needs of the financial department.
Often companies create spreadsheets with financial numbers and calculations with the Excel application.
This package provides a simple application that demonstrates how to upload an Excel spreadsheet file to Web site running PHP and then extract details from the spreadsheet to store in a SQL server database table, so the stored data may be used by other parts of the PHP Web site.
Manuel Lemos |
| |
 |
|
Innovation award
Nominee: 1x |
|
Details
simple-coop-uploads-api
Simple PHP and Sql Server API to serve uploads for web applications
PhpSpreadsheet
Uploads with Php Spreadsheet plugin
Format includes: spreadsheet sheets, xls, xlsx, csv
[
'application/vnd.ms-excel',
'text/xls',
'text/xlsx',
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
'text/csv'
]
Modify the init file to your own database connection
| |
Applications that use this package |
|
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.
Download .zip
Example
composer.json
