| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.9.4 |
| Bug #6584 | File cannot be accessed. File may be read-only. | ||
|---|---|---|---|
| Submitted: | 2006-01-25 20:32 UTC | ||
| From: | kansberr at ctlaerospace dot com | Assigned: | dufuz |
| Status: | Closed | Package: | Spreadsheet_Excel_Writer |
| PHP Version: | 5.0.4 | OS: | Windows NT 4.0 |
| Roadmaps: | (Not assigned) | ||
[2006-01-25 20:32 UTC] kansberr at ctlaerospace dot com
Description:
------------
I use Spreadsheet_Excel_Writer to pull information from our Oracle Applications Database. This works 90% of the time. However, certain php programs will only work if the dataset being retrieved is small. Past a certain point, the file receives an "[file].xls cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding". It is almost like the entire Excel file is not being generated. Could this be due to something timeing out?? I am rather new to php, so it may be something small I am missing.
Kevin.
Expected result:
----------------
Excel file opens with data from sql.
Comments
[2006-01-26 20:28 UTC] tuupola at php dot net
You are most likely hitting either memory_limit or max_execution_time limits.
http://fi.php.net/manual/en/ini.php#ini.list
Try to change these to a bigger value and see if that helps.
[2006-01-27 13:22 UTC] kansberr at ctlaerospace dot com
I changed max_execution_time to 600 and memory_limit to 32M and the problem persist. Do you think these values are still too low?
[2006-03-22 14:40 UTC] kuba dot pluciennik at wp dot pl
(OkropNick)
I have the same problem, but with small excel files.
Not working example:
<?php
include "Spreadsheet/Excel/Writer.php";
$xls =& new Spreadsheet_Excel_Writer();
$sheet =& $xls->addWorksheet('test');
for ( $i=0;$i<100;$i++ ) // only 100 iterations
{
$sheet->write($i,0,$i);
}
$xls->send('test.xls');
$xls->close();
?>
Working example:
<?php
include "Spreadsheet/Excel/Writer.php";
$xls =& new Spreadsheet_Excel_Writer();
$sheet =& $xls->addWorksheet('test');
for ( $i=0;$i<500;$i++ ) // 500 iterations
{
$sheet->write($i,0,$i);
}
$xls->send('test.xls');
$xls->close();
?>
Maybe my PC is too fast? LOL (Intel Pentium D 2x 3GHz Core)
[2006-04-25 06:30 UTC] ken1 at new-beetle dot net
(kenichi nakanishi)
I found same problems.
My environment is
Windows XP, PHP5.1.2J,
Pear 1.4.9,
OLE 0.5,
Spreadsheet_Excel_Writer-0.9.0.
I could make a excel file, but I coundn't open it because of 'read only alert'.
I'd like to know how to soluve this problem.
[2006-05-15 03:02 UTC] ken1 at new-beetle dot net
(cheltenham)
I solved a problem - excel file is unopenable...
In my config in php.ini, when function-overload = 7, that problem occurred, but without that cofig, I could open an excel file.
[2006-07-12 05:35 UTC] aditseng at gmail dot com
(Aditya)
Tried removing the function overload, and it didn't help. The funny thing is that the normal $xl->send('test.xls') also doesn't work properly; it sends a garbled file.
Win2k Pro; Apache 2; PHP 5.1.4
[2006-07-12 06:01 UTC] aditseng at gmail dot com
(Aditya)
Regarding the above comment, the garbled file was due to a space before the <?php; now even when I do a $xl->send, Excel responds with a cannot be accessed.
[2006-08-22 00:50 UTC] drwarmth at gmail dot com
(DrWarmth)
Has a resolution to this problem been found yet? I'm having the same issue with tiny test code. My environment is:
Mac OS X 10.4.7
Apache 1.3.33
PHP 5.1.4
OLE 0.5
Spreadsheet_Excel_Writer 0.9.0
I noticed that, when run from a Terminal session, and OLE output/temp file is create that isn't when run through Apache (OLE_PPS_Filexxxxxx); could the OLE component be causing this?
Thanks.
[2006-09-28 03:34 UTC] iedscho at hotmail dot com
(Joe)
I have the same problem. The problem occurs when the file size is over 1.6 MB in my case.
I had to stop using this package and use the simple codes, which cannot format the cells.
I hope someone fix the problem ASAP.
[2007-01-28 11:25 UTC] henning at mailbox dot ag
(Jan)
This isn't solved yet, using Spreadsheet_Excel_Writer-0.9.1. This bug is old enough so that someone finally could give an answer to this :)
[2007-05-17 22:59 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2007-07-23 09:18 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2007-07-26 22:48 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2007-07-26 22:52 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2007-07-27 00:16 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2007-07-27 01:03 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2007-07-27 01:14 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2007-07-27 01:44 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2007-10-21 05:36 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2007-12-11 20:00 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2008-01-09 06:37 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2008-01-15 15:12 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2008-08-05 01:30 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2008-08-05 02:31 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2008-08-06 01:30 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2009-11-29 07:50 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2009-12-21 23:53 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2010-01-04 22:39 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2010-01-05 01:19 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2010-01-28 13:18 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!