PHP Excel path

You should set the PHPExcel path at admin/settings/sheetnode/phpexcel.

Which package did you download? The official PHPExcel stable package contains the Classes folder.

Not to sound dumb but where is admin/settings/sheetnode/phpexcel linked from? I can access the URL directly but didn't see the path anywhere. (It's not on the project page either). I'm not the root user, but I do have all admin privileges set. I tried logging in as UserID 1 but no change. admin/settings/sheetnode, linked from the admin page, only lists options for view mode.

Shouldn't a link to admin/settings/sheetnode/phpexcel also be available from the status report error message?

(sorry to hijack the thread and make it active again.. it seemed the right place to ask)

Thanks TrevorBradley for reminding me. Fixed in the latest dev (you'll need to flush your menu cache).

Yup, that did the trick. Thanks!

After 2 days of nothing then troubles and searching the internet,
i want to ask my question here:

I cant find the correct path
i've tried everything and every thing else:
my PHPExcel.php is extracted under this folder d:\xampp\htdocs\drupal\Classes

do i need to install PEAR or not

Witch Path Do i need to enter, i'm an absolute beginner for drupal, but i needs this module to work because of my intrnet site

can you help me?

I have the exact same problem. How does the path have to be defined? Do I refer to "http://mysite/Classes/PHPExcel.php", or to the OS-path as in "/Library/intranet/Classes/PHPExcel"?

Please help me out, I think I've tried all the options, but I'm sure I'm overlooking something really noob...

Thx!

I've found it!

You only need to enter the path before /Classes/PHPExcel.php, or in my case: "/Library/WebServer/intranet/"

HTH - enjoy!

Don't need to edit the title - the issue status is enough.

Don't need to edit the title - the issue status is enough.

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

PHPExcel module is enabled.
PHPExcel excel folder freshly created and download moved into it.
Paths tried: sites/all/libraries/PHPExcel and all combinations of leading and trailing /(and trailing period).
PHPExcel excel folder permissions: all combinations
Drupal cache cleared
???
I'm on a mac using MAMP.

What have I missed?

Did you try a full path to the PHPExcel path?

Yes, I tried everything, it made no difference. Importing a single column is easy with text table import, with more than one column the cells get muddled up if an entry is more than two character longer than the corresponding entry in the row above. Any chance of csv or tab separated instead of 2-space separated values?

After all that I realize now that this isn't so critical for me. I would like to use Sheetnode to set prices for three different product types. Am I correct in thinking that all I can import SKUs (and page numbers in my case) and then do the rest in Sheetnode?

If this is so are there any tutorials or instructions on how to do this? I did find something on this but have no idea what it means! It seems this is possible with the Poducts Function (${PRODUCT($field_nov_star$, -1)), but don't understand any of it and could find no reference to a Product Function anywhere else. I created a sheet field to a product type but could not access anything, neither '=ORG.DRUPAL.FIELD('field_text', 416, 'node') nor '=ORG.DRUPAL.FIELD('field_text', 416, 'product') worked.

Thank you so much for Sheetnode! Any and all help appreciated.

jw

#10 above, How would your other paths look?

This still seems to be a problem.
Using Sheetnode 7.x-1.0-beta4 I get the following error message:

Fatal error: Class 'PHPExcel_Settings' not found in sites\all\modules\sheetnode\modules\sheetnode_phpexcel\sheetnode_phpexcel.module on line 267

At admin/config/content/sheetnode/phpexcel

I have included the following settings:
- sites/all/libraries/PHPExcel
- sites/all/libraries/tcpdf

Giving up on this as after wasting several more hours.

I ran into some similar issues to those described here. Turned out to be a combination of issues. First problem was that there was a permissions problem on the PHPExcel libraries and folders I installed. To test for this, be sure you can access files in your PHPExcel library folder (ex. http://example.com/sites/all/libraries/PHPExcel/Examples/01simple.php does not return forbidden).

As for setting the variables, I wasn't able to set them from the admin interface. Workaround was to do the following in drush:

drush vset sheetnode_phpexcel_library_path sites/all/libraries/PHPExcel
drush vset sheetnode_phpexcel_pdf_renderer_path sites/all/libraries/tcpdf

The instructions to use the full path seem to be incorrect, but I wasn't able to get the module to do much of anything until I manually set these variables. My guess is that it may have something to do with Libraries 2.x.

Many thanks for a great module. Looking forward to working with it more and seeing it come out of beta!

I have the same problem.

Trying to set the variables in the Admin GUI generates a 500 Server Error, but I haven't been able to get drush to work on my (multisite) server, so I'm a bit stuck.

The paths are correct and I can access the sites/all/libraries/PHPExcel/Examples/01simple.php without error, so the permissions are ok, too.

[Edit]Managed to get drush to work and altered the variables as detailed by above. It now appears to work[/Edit]

I have installed the Sheetnode module for Drupal 7. I have downloaded and installed PHPexcel and TCPDF and they reside in site/all/libraries/. When I try to configure the Sheetnode PHPexcel module, I am unable to insert the correct paths for PHPexcel and TCPDF. I am using Windows Vista and my site folder is located on my desktop. When I right click on my site folder it gives my path as C:\Users\Sxxxxx Sxxxxx\Desktop. So under the path to configure I am entering C:\Users\Sxxxx Sxxxxx\Desktop\mysitename\sites\all\libraries\PHPexcel. So under the path to configure I am entering C:\Users\Sxxxx Sxxxxx\Desktop\mysitename\sites\all\libraries\tcpdf. I get the following error - Fatal error: Class 'PHPExcel_Settings' not found in C:\Users\Sxxxxx Sxxxxx\Desktop\mysitename\sites\all\modules\sheetnode\modules\sheetnode_phpexcel\sheetnode_phpexcel.module. on line 267. I have read all the comments regarding this, but can't seem to get it working. I don't know Drush. Please help.

Sorry everyone for ignoring this issue. Working on it now.

I solved the path problem, by unistalling the beta version and reinstalling the dev version. Then I figured out I needed to expand my path info to include the PHPexcel and tcpdf name in the path.

I thought I had this licked, but when I try to import my spreadsheet, no spreadsheet appears on the node. It looks like it is importing and the export links show up, but no spreadsheet. I tried to import XLS and XLSX spreadsheets. When I tried to export the invisible spreadsheet from the node, I received an ajax error message.

I even unzipped your "Basic Number Formats" & "Conditional Numbers Formats" spreadsheet that you reference in a different bug report and imported it. It created two nodes with the titles "Basic Number Formats" & "Conditional Numbers Formats", but with the same problem - no visible spreadsheet. I am able to export your Basic Number Formats & "Conditional Number Formats" spreadsheet and view them in Excel.

Please help. I love the module and really, really want to use it. Thanks infojunkie.

Regards,
Sheryl

I can provide some screen shots if you need them. Not sure how to upload them, but will figure it out.

I just tried to create a regular sheetnode page and it only has the title and the export tabs.

Okay, through a process of disabling the PHPexcel, Google Spreadsheets, and CKEditor modules one at a time, I discovered that the CKEditor module was causing the invisible spreadsheet issue. Everything seems to be working, and I'm feeling pretty sassy!

Thanks hatcat for documenting your solution. I will make sure that misconfiguring CKEditor does not mess up the Sheetnode display.

Committed some minor fixes to the PHPExcel path setting, and a robust fix to avoid catastrophic failure when CKEditor is misconfigured.

Closing this unless/until anyone sees the problem again.

Committed further fixes based on #1959600: Sensible default library paths and ability to specify paths relative to Drupal installation. Will make a new beta release to allow users to test these fixes.

Sorry to be a pest, but I'm not sure what to do next. Is there a patch to apply? Will there be an update on the project page?

Also, do I need to do something to configure my CKEditor correctly?
I will be happy to repay your service by working on something for you, if you have anything that is drudgery for you, but would help me to learn as a newbie. Please let me know.

Thanks, Sheryl

I just made a 7.x-1.0-beta5 release, should be out soon (assuming the new Drupal.org release mechanism is fixed...). You will be able to download it then. If you want to test earlier, you can get the latest code from git.

For CKEditor, you need to make sure you follow the instructions on the module page's installation instructions. The CKEditor settings are located at admin/config/content/sheetnode/ckeditor.

Thank you. I was just checking my configuration for CKEditor and found that I had not set a local path in my Global Profile for CKEditor. I saw in Git in what I think shows the deletions and additions to your code the following:
if (typeof CKEDITOR === 'undefined') {
+ console.log('Sheetnode CKEditor: Cannot find global CKEDITOR object, which probably means the CKEditor library is not correctly installed. Aborting.')
+ return;
+ }

and thought maybe this was related. Still trying to figure out how Git works. Every so often another little piece of puzzle drops into place.

I am using the default Admin toolbar in Drupal 7, but I see this kind of reference in the issue cues often

admin/config/content/sheetnode/ckeditor.

Is this menu from the Adminstration Menu module or just a different way to configure the toolbar?

You can copy the relative path admin/config/content/sheetnode/ckeditor and paste it in your browser URL bar, following your Drupal root (e.g. http://d7.local/admin/config/content/sheetnode/ckeditor).

Yes, the git diff you saw shows the change I made to Sheetnode CKEditor.

BTW, the dev release for sheetnode 7.x-1.x-dev has been updated (even though its date shows wrong on the module page). You can download that one and check.

Thank you InfoJunkie. This latest Sheetnode Update to 7.x-1.0-beta5 solves the PHPExcel and TCPDF library path errors. XLS Import Export for Drupal is now a snap!

Thanks for the feedback rCharles!