Hello!

i need some help to configure Sheetnode PHPExcel settings. I am sure that i am entering right path to a folder phpexcel and tcpdf folder...but it always says:

Fatal error: Class 'PHPExcel_Settings' not found in /home/login/site.ru/docs/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.module on line 267

please help ))

Comments

10thstreetlabel’s picture

Getting same error, did you figure it out?

PHPExcel is in sites/all/libraries/PHPExcel

I have tried the following with every variation but can't get the error to stop

/home/mysite/public_html/sites/all/libraries/PHPExcel/

mysite is some shorten version of the actual site which I don't know if it right. mysite appears to be right when the error message come back is has mysite in it.

I had the beta version and just installed the dev version but same problem

ula888’s picture

hello)) no...

10thstreetlabel’s picture

Did you figure out the path to your editor?

I was able to set the path to sites/all/modules/ckeditor/ckeditor/ckeditor

so it was able to find ckeditor.js

I tried this with PHPexcel but couldn't get it to work.

Line 267 is pointing to the PDF not the PHPExcell and when I don't any path put in the PDF path these is no error message that come up.

10thstreetlabel’s picture

Category: support » bug

I changed the above to a bug report because I am able to set the ckeditor and the PHPExcel also I am not getting an error message for the TCPDF setting.

ula888’s picture

hell0 )) ckeditor is okey ...with path that you wrote, but phpexcel no...and it doesn matter put path to phpexcel only or both (tcpdf)...this mistake still show.

thank you!

infojunkie’s picture

Assigned: ula888 » Unassigned

What is the version of PHPExcel you are using?

rdahiya’s picture

I'm having problems integrating phpexcel 1.7.8 with sheetnode 7.x-1.0-beta4. I have also downloaded tcpdf Version: 5.9.197. From the admin/config/content/sheetnode/phpexcel page, I enter the full path /var/www/knocking_dev/sites/all/libraries/phpexcel and /var/www/knocking_dev/sites/all/libraries/tcpdf to the corresponding libraries and the status report page states "PHPExcel is NOT found at ."

Work around: ran php code
variable_set('sheetnode_phpexcel_library_path', '') and
variable_set('sheetnode_phpexcel_pdf_renderer_path', '').

infojunkie’s picture

Status: Active » Fixed

Fixed in the latest dev. Please try it and let me know.

10thstreetlabel’s picture

Great Job It worked for me!

Thanks!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

lovelykaushik86’s picture

Thnku so much for solution infojunkie

Screenack’s picture

Thanks to #7, I was able to update the phpexcel library path using

drush vset sheetnode_phpexcel_library_path sites/all/libraries/PHPExcel

The UI returned a fatal error. We are not using CKEditor on this site. We can not use dev code in our environment, fwiw.