Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 644
  • Last Modified:

Simple Export to Excel with PHP

I wrote the following code to export a multi-dimensional array to rows in an excel spreadsheet for the user to download.  But in the fields where the data is "" or Null, it doesn't tab over to a new row so my columns are getting all jumbled.  Attached is a sample file of what I'm getting.  There must be something small that I am missing but I'm not sure what.  Any help would be appreciated, thanks!
<?php
header("Content-type: application/x-msexcel");
header("Content-Disposition: attachment; filename=report.xls");  
header("Pragma: no-cache");
header("Expires: 0"); 
 
for ($x=1; $x<count($resultArray); $x++) {
	for ($y=0; $y<count($resultArray[$x]); $y++) {
		echo $resultArray[$x][$y]."\t";
	}
	echo "\n";
} 
?>

Open in new window

sample.xls
0
lghaman123
Asked:
lghaman123
1 Solution
 
loki23Commented:
try changing:

echo $resultArray[$x][$y]."\t";

to:

echo $resultArray[$x][$y];
echo "\t";

I'm thinking it might have something to do with trying to append the tab to a null value
0
 
Loganathan NatarajanLAMP DeveloperCommented:
You will have to create ROWS + Columns through HTML and export to excel .. just try
0
 
cfpdevCommented:
logudotcom is right.

excel is pretty thick, unless you give it more to work on as a delimiter. so either use |'s or comma's or do the html method.

but not tab's.

not even swearing at excel works.
0
 
Loganathan NatarajanLAMP DeveloperCommented:
Ok try something like
<?php
header("Content-type: application/x-msexcel");
header("Content-Disposition: attachment; filename=report.xls");  
header("Pragma: no-cache");
header("Expires: 0"); 
 
for ($x=1; $x<count($resultArray); $x++) {
       echo "<tr>";
	    for ($y=0; $y<count($resultArray[$x]); $y++) {
                echo "<td>".$resultArray[$x][$y]."</td>";
        }
        echo "</tr>";
} 
?>

Open in new window

0
 
lghaman123Author Commented:
Thanks guys, I appreciate the help.  
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now