Failed opening required '/Classes/PHPExcel.php'

You should make sure the path you enter in the Sheetnode PHPExcel settings does exist and does point to the extracted PHPExcel package.

I am getting the same error after a new installation of Sheetnode:

Fatal error: require_once() [function.require]: Failed opening required '/Classes/PHPExcel.php' (include_path='.:/usr/local/php5/lib/php') in /home/content/k/e/l/kellychip/html/dev/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.import.inc on line 57

I am running on a godaddy instance, so I rely on their PHP installation for php modules.

@cwkelly3: What is the value you entered for the PHP Excel path?

I see now in your installation instructions how to install PHPExcel. I am installing it now, and will modify sheetnode_phpexcel.import.inc to point to the location of phpexcel.php. User error.

Still having trouble with "Configure Sheetnode PHPExcel settings by entering the full path of the PHPExcel folder root."

Where do I enter the full path?

I tried modifying line 57 in sheetnode_phpexcel.import.inc to point to 'html/dev/sites/all/modules/PHPExcel/Classes/PHPExcel.php' but the status report indicates that "PHPExcel is NOT found at ."

Thanks for your help.

You should not modify the code. Instead, go to Admin > Site Configuration > Sheetnode > Sheetnode PHPExcel (admin/settings/sheetnode/phpexcel). Enter the path in PHPExcel path.

Thank you. I am still having trouble creating a spreadsheet, whether from Import from XLSX, "Create Content" or from a spreadsheet view. When I go to http://demos.thereisamoduleforthat.com/sheets/ and select Create Content>Sheets, I see a nice sample spreadsheet during the creation stage. I do not see that sample rendered when I do the same steps on my site. I have followed the installation doc for socialcalc. What am I missing?

If you have Firebug, please open the console tab and look for a Javascript error. If you don't have Firebug, please install it.

I have two errors:

SocialCalc is not defined
this.spreadsheet is undefined

Is the socialcalc directory supposed to be a subdirectory of the sheetnode directory? I placed it in sites/all/modules.

socialcalc is supposed to go under sheetnode.

Thanks, I thought I could install it anywhere. With it under sheetnode the spreadsheet displays. I am still having display problems with the spreadsheet admin panel. It is not rendering properly regardless of the theme I choose for it.

When I select Theme: Information the following error condition shows:

Style output: views-view-sheet.tpl.php (File not found, in folder sites/all/modules/sheetnode/),

regardless of the theme I try. I don't know if that is related, but I am not finding any other error conditions in Firebug.

One more question - how do I present the spreadsheet for user input and allow them to save their changes? By default it is displayed in view mode, which does not allow saving.

Thanks for your help.

What do you mean by "spreadsheet admin panel"? Are you referring to using sheetnode in a view? Please open a new issue (as this is unrelated to the current post) and attach a screenshot of what goes wrong.

Gotcha. Sorry for scope creep.

I'm also having trouble with the path setting to PHPExcel. Could you provide an example?

I've tried everything I can think of, but it still throws up the same error:

"The path you entered does not point to a valid location. Please enter the location of the extracted PHPExcel package."

Thanks.

The PHPExcel path should be absolute, not relative, e.g. /var/www/d6/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/PHPExcel.

Thanks infojunkie, my Drupal install lives on a shared hosting environment. So I've got this for a path:

/usr/home/deb****/domains/client.com/public_html/test/PHPExcel_1.7.6/

Inside of the PHPExcel_1.7.6 directory is the Classes directory. Within that directory is the PHPExcel.php file.

When I try to configure this path through /admin/settings/sheetnode/phpexcel form within Drupal it keeps throwing up the error message however. Could this be a issue with privileges? Any idea how I can check if the file / directory are in fact reachable? (Other than by configuring the path from within Drupal / Sheetnode, that is.)

Help is greatly appreciated!

Never mind, solved it myself (#15 & #17). Here's how: via the /admin/reports/event page of the Drupal site I could get more information about what went wrong. There was an entry with the following message that provided a clue. Error message:

is_dir() [function.is-dir]: open_basedir restriction in effect. File(/usr/home/deb****/domains/client.com/public_html/PHPExcel_1.7.6) is not within the allowed path(s): (/home/deb****/:/tmp:/var/tmp:/usr/local/lib/php/) in /home/deb****/domains/client.coml/public_html/test/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.module on line 139.

Apparently the /usr/ directory was off limits. After I chopped that part of the full path everything worked as expected.

This might have been a provider specific issue, but maybe the solution above helps someone else facing similar trouble.

Thanks for posting your solution.

I looked at the code where it picks up the directory path (line 139 in sheetnode_phpexcel/sheetnode_phpexcel.module) and it is concantenating /Classes/PHPExcel with the path that is input. So it looks like it wants the path up to the Classes directory. For example, in my case, my drupal 6 site is at "/var/www/htdocs/develop2" and I have the Classes/PHPExcel located at "/var/www/htdocs/develop2/Classes/PHPExcel". So the path that I entered successfully for the PHPExcel path (at /admin/settings/sheetnode/phpexcel) is: "/var/www/htdocs/develop2". Makes sense once it works, as is usually the case :-) .

@bkudrle: Thanks for the feedback, I've updated the installation instructions on the module page to better reflect this.