Trying to import .xlsx file using Sheetnode import from XLSX (or any other form):

1. As opening the option got the message:
Warning: Illegal offset type in _sheetnode_phpexcel_import_form() (line 6 of /home1/myagelef/public_html/ecologicalintl/drupal/dev/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.import.inc).

2. Importing, got another message:
Fatal error: require_once() [function.require]: Failed opening required '/Classes/PHPExcel.php' (include_path='.:/usr/lib64/php:/usr/lib/php') in /home1/myagelef/public_html/ecologicalintl/drupal/dev/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.import.inc on line 56

CommentFileSizeAuthor
#1 aphraseofday_brazil.xls16.5 KBrajgovindona
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

rajgovindona’s picture

rajgovindona CreditAttribution: rajgovindona commented
FileSize
aphraseofday_brazil.xls16.5 KB
gerbreown’s picture

gerbreown CreditAttribution: gerbreown commented

I am also having this problem and cannot upload any spreadsheets to my web site.

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented
Status: Active » Postponed

D7 port is not functional yet.

shaisamuel’s picture

shaisamuel CreditAttribution: shaisamuel commented

Thanks for clearing Karim (infojunkie). DO you have any projection for the timing of the first functional version? No as a commitment, but an estimation.

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented

I'm not working on the D7 port at the moment. Someone else had started porting it, but I haven't heard from them in a while. In the mean time, the git branch 7.x-1.x-bkudrle-20110713 should have the best functionality.

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented
Version: 7.x-1.x-dev » 7.x-1.0-alpha1
Component: Core » XLS integration

Please try the new 7.x-1.0-alpha1. It's completely new code - I wasn't working on previous D7 code. Make sure to read the release notes.

Note that Sheetnode PHPExcel is still not ported. But it shouldn't be long now that I've ported the core module.

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented
Status: Postponed » Closed (duplicate)

Duplicate of #1500222: Port sheetnode_phpexcel.module. Please subscribe there to follow the progress of Sheetnode PHPExcel.

neeraj kuntal’s picture

neeraj kuntal CreditAttribution: neeraj kuntal commented
Component: XLS integration » Core

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: batch&render=overlay&id=46&op=do StatusText: Service unavailable (with message) ResponseText: Exception: ZipArchive library is not enabled in PHPExcel_Reader_Excel2007->canRead() (line 240 of /sites/all/libraries/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php).

when i am upload excel (xlsx ) file inn server .it show the above error .but same is done in local .xls file is import .plz give the solution

GDT67’s picture

GDT67 CreditAttribution: GDT67 commented

Please help

An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: /drupal/batch?id=44&op=do StatusText: OK ResponseText: Fatal error: Class 'PHPExcel_IOFactory' not found in /home/content/05/10650405/html/league/drupal/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.import.inc on line 109

mgarcia@usu.org.au’s picture

mgarcia@usu.org.au CreditAttribution: mgarcia@usu.org.au commented
Issue summary: View changes

Hi I am getting a import error for all types except Google spreadsheets.
XLS, XLSX, CSV, ODS I get this error
An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: /drupal/batch?id=20&op=do StatusText: OK ResponseText: Fatal error: Class 'PHPExcel_IOFactory' not found in C:\xampp\htdocs\drupal\sites\all\modules\sheetnode\modules\sheetnode_phpexcel\sheetnode_phpexcel.import.inc on line 109

when trying to import from private from Google spreadsheets
It takes my Google user and Pass but does not load any of my private spreadsheets ( its says no spreadsheets found)
any help on this issue would be great. I am running Drupal 7.31, PHP 5.5.9 and sheetnode 7.x-1.0-beta6 all libraries have been pointed correctly