Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Does php-excel-reader support xlsx

Tags:

php

excel

I am using php-excel-reader, but got error on reading .xlsx file. So does this support xlsx format. Or what is other solution available.

My requirement is just to read the file(xls, xlsx and ods) and render on html page.

PHPExcel seems too much as there is no requirement for editing the excel file.

like image 386
Gagan Avatar asked Jul 16 '13 07:07

Gagan

People also ask

How can read Excel file in PHP?

Loading a Spreadsheet File $inputFileName = './sampleData/example1. xls'; /** Load $inputFileName to a Spreadsheet Object **/ $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($inputFileName); See samples/Reader/01_Simple_file_reader_using_IOFactory. php for a working example of this code.

What program will open XLSX files?

The easiest way to open a file with the XLSX extension is to use a relatively recent version of Microsoft Excel. You will have no trouble opening files in the XLSX format if you use version2007 or higher. The latest version of the Excel spreadsheet program is included in Microsoft 365.

Is XLS or XLSX better?

For compatibility, XLS has higher compatibility than XLSX. XLS is readable by all Microsoft Excel versions while XLSX is only readable by Excel 2007 and later versions. besides, XLS is able to hold the spreadsheets either including Macros or not, while XLSX isn't capable to support Macros.

1 Answers

Yes php support to read .xlsx file.

For that you have to use PHPExcel library.

I have created script to read excle file, You can download script from : https://www.dropbox.com/s/oao0eskflu8nyz1/PHPExcleReader.zip?dl=0

like image 149
jaydeep namera Avatar answered Oct 30 '22 19:10

jaydeep namera
Sign in to Comment

Related questions

PHP Unsigned Right Shift - Malfunctioning
Force to include file from same directory and not include_path
Using filter_var with parameters
Using Simple HTML Dom Parser to Get hyphenated Attribute
String Replace - Add Slash Before Single Quote [closed]
Codeigniter - best practice to sanitize input
HTML 5 Camera access & upload file using php
Alternative to eregi() in php [duplicate]
php url explode
PHP : add write permission to file after move_uploaded_file()
What will array_column return if a key name doesn't exist?
How to RAW POST huge XML file with curl - PHP
PHP class not storing reference
How to check if file exist in zip archive
Serve large file with PHP and nginx X-Accel-Redirect
Paypal express checkout error Order total is missing. Error 10400
Laravel 4 Validation
limit string to first 5 words or first 42 characters in PHP
PHPUnit progress dots are in new line and showing "wrong" percentage
PHP: Is it possible to create a SplFileObject object from file contents (string)?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!