New, fresh install of Drupal, to test this module for possible use.

Installed Sheetnode and PHPExcel.

Imported an xlsx file - which went beautifully. Edited the file to add some formatting to cells. Attempted to export as excel document, but received "Access denied. You are not authorized to access this page." Always amusing when logged in as uid 1. ; )

Tried again with new document, no editing. Same thing.

Created a new sheetnode, without importing. That exported with no trouble. Added some data and formatting, still exported just fine.

Comments

infojunkie’s picture

infojunkie
Location Vancouver
commented

Are you receiving this error at the beginning or at the end of the batch process?

One reason this error would return is that the $_SESSION['sheetnode_phpexcel_download'] variable is found to be empty. Looking at the code, this could happen if the spreadsheet temp file creation would have failed and generated an exception.

Can you look in your temp directory to see if there are files named sheetnode_phpexcel_*? Delete those that you find then try the export again to see if there's a new one being created.

Thanks for your help!

mmomin’s picture

mmomin commented
Issue summary: View changes

Same issue...
There is no file being created in temp folder.

mmomin’s picture

mmomin commented

it behaves really strange. When I create a new sheetnode, that gets exported without a trouble. but if I edit the same sheetnode and then try to export it. It gives "access denied" error.

mmomin’s picture

mmomin commented

Could this be a 'max_allowed_packet' limit issue? As my sheet is 1400 rows with formats. As I am able to export the file if the same file is 1100 rows.
Please reply.

mmomin’s picture

mmomin commented

Finally got it working
Changing upload_max_filesize to 10M and post_max_size to 12M in php.ini didn't help...Whenever I try to export a file with 1100 rows it worked fine but as soon as I changed it to 1101 rows it says "Access denied you need to login" while exporting.
But changing 'max_allowed_packet' to 16777216(required for Drupal 7) from 1048576 (by default) did the trick.

infojunkie’s picture

infojunkie
Location Vancouver
commented
Status: Active » Fixed

Thanks so much for tracking this. Marking as resolved.

Status: Fixed » Closed (fixed)

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