emerinohdz / php-excel Goto Github PK

What steps will reproduce the problem?

When using $xml->generateXML($filename) the filename is used without proper
validation of allowed characters. This may cause errors when delivering out
the file.

What is the expected output? What do you see instead?

Use a whitelist filter to correct the filename before sending out the files.

How can i generate excel file with freeze rows?

When i am trying to export arabic character it's getting like "?????????"

hello,
First, i want to thanks for author for very usefull code :).
I sow problem and can't fix it.

when i use loop like this
for ($i=1; $i<5; $i++){
echo"<Row><Cell ss:StyleID=\"s52\"><Data ss:Type=\"String\"> 
</Data><NamedCell ss:Name=\"Print_Area\"/>$i</Cell></Row>";
}
everthing generate ok, but if i use

for ($i=1; $i<11; $i++){
echo"<Row><Cell ss:StyleID=\"s52\"><Data ss:Type=\"String\"> 
</Data><NamedCell ss:Name=\"Print_Area\"/>$i</Cell></Row>";
} 
everthing is stoping and broke excel report generation. How need to fix it?

please help..

thanks in advance

I can't see a way to pass formulas to excel. Without this, it is of very
limited use.

What steps will reproduce the problem?
1. Send a value with character "ñ" to AddRow method


What is the expected output? What do you see instead?
I expect the correct word "compañia"
I see a blank value 


What version of the product are you using? On what operating system?
excel-class 1.1
php 5.2.x
osx leopard 10.5.8


Thanks!

I came across a major compatibility issue with Internet Explorer 7 and
Microsoft Office 2007/3.

Headers sent cause IE to try to open the file inline but for the 90% of
tests the content was corrupted or IE was unable to handle the file.
I fixed the problem changing content disposition header to attachment

header("Content-Disposition: attachment; filename=\"" . $filename . ".xls\"");

and with 2 additional headers that force the browser to not cache the request.
Here's the final piece of code


        // deliver header (as recommended in php manual)
        header("Content-Type: application/vnd.ms-excel; charset=UTF-8");
        header("Expires: 0");
        header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
        header("Content-Disposition: attachment; filename=\"" . $filename .
".xls\"");

What steps will reproduce the problem?
1. input cyrillic characters in the array
2. save the file as UTF-8
3. run it

What is the expected output? What do you see instead?
xls file - the text is corrupt

What version of the product are you using? On what operating system?
php-excel Version 1.0

Please provide any additional information below.
Try without utf8_encode(); I guess the strings in the array "should" be
UTF-8 and utf8_encode() is not necessary.

What steps will reproduce the problem?
1. call
2. text
3. drive

What is the expected output? What do you see instead?
duplicate

What version of the product are you using? On what operating system?

xp
Please provide any additional information below.
yes

What steps will reproduce the problem?
1. Generate a very large Excel file (>7000 lines) 

What is the expected output? What do you see instead?

You'll most likely get:

Allowed memory size of 16777216 bytes exhausted (tried to allocate 189
bytes) class-excel-xml.inc.php on line 188

I fixed this by changing the implode() line on 188 to the following for-loop:

        $length = count($this->lines);
        for($i=0; $i<$length; $i++) {
            echo $this->lines[$i] ."\n";
        }

Change private $header to

"<?xml version=\"1.0\" encoding=\"%s\"?\>\n
<?mso-application progid=\"Excel.Sheet\"?>\n
<Workbook xmlns:o=\"urn:schemas-microsoft-com:office:office\"
 xmlns:x=\"urn:schemas-microsoft-com:office:excel\"
 xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\"
 xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\">";

Change header to
header("Content-Type: application/force-download; charset=" . $this->sEncoding);

header("Content-Disposition: inline; filename=\"" . $filename . ".xml\"");

Now a download dialog will appear, click open, Excel will display the XML 
without any messages.

Can you post any way to save to file not stream?

What steps will reproduce the problem?
1. put text containing an: ampersand, apostrophe, double-quote, less-than
and/or greater-than in the data for a cell.
2. Excel will fail to read the resulting file, complaining that illegal XML
characters are found.

Please provide any additional information below.

Text in cells must be XML encoded using:
str_replace(''', ''', htmlspecialchars($text, ENT_QUOTES));

A similar module exists elsewhere:

http://phpexcel.codeplex.com/

Consider merging the projects or at least sharing relevant code. HTH.

What steps will reproduce the problem?
I have a script that's sole purpose is to remove a few columns from a
spreadsheet that is passed to it.  The total work w/ PHPExcel is:

$xl = PHPExcel_IOFactory::load($filename);
$ws = $xl->getSheet();
$ws->removeColumn('C', 7);
$writer = PHPExcel_IOFactory::createWriter($xl, 'Excel5');
$writer->save($outputfile);

After running the xls through the script, the final row still has the
columns that should be removed and I have to remove the data from those
cells manually.

What is the expected output? What do you see instead?
I would expect that the columns removed would be removed throughout the
entire worksheet.

What version of the product are you using? On what operating system?
PHP 5.2.9
Initially used PHPExcel 1.1
Most recent test using PHPExcel svn pull on 1/21/2010


Please provide any additional information below.

What steps will reproduce the problem?
1. XML format 
<proejctName>XYZ</projectName>
<details>Add any 254 characters length string here</details>
2. sendFile() function sends data to xls file, but when you open a file it show 
File Error: Data ma have been loss 

for 253 character long string it works perfectly well..

What is the expected output? What do you see instead?
Expected o/p show print 254 charastre string in xls


What version of the product are you using? On what operating system?
v1.1

Please provide any additional information below.

What steps will reproduce the problem?
1. Open xls file
2.
3.

What is the expected output? What do you see instead?

When i downloaded xls file. I open it with MS Office but still loading...

What version of the product are you using? On what operating system?
Im using MS office 2007 2010 and 2013 to open but still loading and can't open 
file. I try to open with notepad++ and see XML struct as i need. But can't open 
by MS Excel T_T.

Please provide any additional information below.

Please help me.
Thank alot!

Added initial support to save to filepath.

I added this code on the next line of 132(after htmlentities function)

$v = str_replace("\n", '
',$v );

so that you can make newline in the cell data.

if we want to store data "</Data>", this will conflict width excel format

so i add <![CDATA[ ]]> to avoid this,

the changes was in the file attached.

What steps will reproduce the problem?
1. Copy test.php's code into the page I created below
2. Launch the page 
3. Nothing appears

What is the expected output? What do you see instead?
The arrays contain data but nothing happens. I am able to print_r($excelSheet) 
and confirm it 
contains data. I have also used the test.php code to confirm it is not my array 
that is the issue. It 
is really puzzling - even if I copy paste the test.php code, and made sure that 
the class file is in 
the same folder, nothing appears. The rest of my page functions as expected.  

What version of the product are you using? On what operating system?
Latest version (the 2009 build)

Please provide any additional information below.
Please see attached file

Please write a readme file and include it in the first downloadable version.

What steps will reproduce the problem?
1. add some rows that have numbers in them
2. download
3. Excel gives Number Stored as text error.

What is the expected output? What do you see instead?
Excel gives Number Stored as text error.

What version of the product are you using? On what operating system?
1.0 on Mac OSX.

Please provide any additional information below.
Here is my fix:

        foreach ($array as $k => $v):
            $ssType = "String";
            if(is_numeric($v)) {
                $ssType = "Number";
            }
            $cells .= "<Cell><Data ss:Type=\"".$ssType."\">" .
utf8_encode($v) . "</Data></Cell>\n"; 

        endforeach;

When opening the generated file with Excel 2010, it pops up a window saying 
"The file you are tring to open is in a different format than specified by the 
file extension ... Do you want to open the file now?"

When clicking yes, it works fine, however, this should really be avoided. Also, 
with LibreOffice the opening of the file without any renaming is not possible.

Thank you

Open the dowloaded File into Open Office

Instead of a Excel Spread Sheet, It looks like a word Doc

v1.0, PHP 5, WinXP (Apache/PHP server as well)

I need to use a debugger (or something) to measure the performance of the
class methods. I am too unsure to decide whether I use array_slice or a for
loop to resize an array which is possibly too large to handle.

What steps will reproduce the problem?
1. Output a xls file with this library.
2. Open it in Excel2007.
3. You may meet a format error tip.