BasicExcel | Lightweight Basic Excel Read / Writer for PHP | CSV Processing library
kandi X-RAY | BasicExcel Summary
kandi X-RAY | BasicExcel Summary
Lightweight Basic Excel Read / Writer for PHP 5.3+. This Class can both read and write to CSV, XLS and XLSX. Added in the abiliity to guess which file type it is and parse accordingly to array.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- Parse cell value
- Parse sheet data
- Generate workbook
- Get column index
- Set a sheet from an array
- Write workbook to file
- Parse rich text
- generate a cell
- Output the file
- Parse dimensions array
BasicExcel Key Features
BasicExcel Examples and Code Snippets
Community Discussions
Trending Discussions on BasicExcel
QUESTION
I have a requirements to read XLS files (not xlsx) using PhpSpreadsheet and I having trouble. I tried this (as the documentation say but...)
...ANSWER
Answered 2018-Sep-13 at 19:14I would check with your Client to see if they are using real Excel or some other spreadsheet.
If they are using some other spreadsheet and exporting using a "Export as Excel" functionality that may explain why its not being recognised by PHPSpreadsheet as any of the possible valid excel formats.
In which case, and depending what is in the spreadsheet, it may be worth asking them to export their spreadsheet as a csv
(comma delimited values) file, as that is such a simple format it should be a valid output. You could then read it using fgetcsv()
function calls instead of having to use PHPSpreadsheet.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install BasicExcel
PHP requires the Visual C runtime (CRT). The Microsoft Visual C++ Redistributable for Visual Studio 2019 is suitable for all these PHP versions, see visualstudio.microsoft.com. You MUST download the x86 CRT for PHP x86 builds and the x64 CRT for PHP x64 builds. The CRT installer supports the /quiet and /norestart command-line switches, so you can also script it.
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page