nkostadinov / eexcelview Goto Github PK

Thanks for working on this extension. I still use it on one of my legacy application and it works great.

Do you have any plans on having the extension available on the Packagist, so that it can be installed using composer?

Thank you for your help!

I was able to get it working with this example: http://www.yiiframework.com/forum/index.php/topic/18119-extensioneexcelview/page__view__findpost__p__216273

But your usage example wasn't very helpful.

Can you add Johnny Gan's code examples to your documentation?

Can you add documentation on where to put the eexcelview.php file? I know it just goes into the extensions folder, but it wasn't very clear when the usage example shows 'EExcelView'.

Also, doesn't the usage example need to use the following?: 'ext.EExcelView'

I'm not able to export in pdf. Also adding libraries to PHPExcel i'm not able to get this working. Could you provide an example to how configure it in the right way with PdfRendererName and PdfRendererPath parameters? I usually get error when eexcel create the document writer because it try to autoload phpexcel_writer_pdf_dompdf (example) but it cause autoload error.

Because CDataProvider caches the results, the extension turn off pagination too late, when the data already had read.
Here is a possible fix: http://pastebin.com/9Lki7JNM

problem when calculating Column IDs for sheet with more than 26 columns, e.g. "AA", "AB"....

2023/08/26 19:47:25[244.185.41.121] [error] [php] Implicit conversion
from float 65.03846153846153 to int loses precision
(C:\web\prod\app\extensions\EExcelView.php:458)

fix:

@@ -460 +460,2 @@ class EExcelView extends CGridView
-            return ($this->columnName($index / 26)).($this->columnName($index%26 + 1));
+            // JJD 8/27/23 must pass int to columnName()
+            return ($this->columnName((int)($index / 26))).($this->columnName($index%26 + 1));