Excel and Yii....?

Question

Yii

Can anyone advise a uniquely working extension that reads Excel, so that later it can be quietly put into the database? Something like PhpExcelreader, only fresher and without any "file is not readable". It's just that PHPExcel, as I understand it, has not been updated for Yii for a long time either.

Answer 1

www.yiiframework.com/extension/yexcel/ - works, checked recently.

Answer 2

This is of course not quite an answer, but I would seriously think about "whether excel is needed." There are too many nuances, it is constantly changing. Why, if there is csv and any software that works with excel saves perfectly in csv.
After all, you still expect a certain table structure to save to the database, which means that the stage of opening it in the software is still there, so why not save it in a more correct format for this purpose.

Answer 3

What's stopping you from writing your own Yii wrapper for PHP Excel?

Answer 4

PHPExcel 1.7.9, last release date June 2, 2013 - quite fresh.
Supported reading formats:

• Excel 2007 (spreadsheetML)
• BIFF5 (Excel 5.0 / Excel 95), BIFF8 (Excel 97 and higher)
• PHPExcel Serialized Spreadsheet
• Excel 2003 XML format
• Open Office Calc (.ods)
• Gnumeric
• Symbolic Link (SYLK)
• CSV (Comma Separated Values)

And you have to write a wrapper for Yii, as XAKEPEHOK said