[RESOLVED] Excel Print Areas via PHP

[middleman666]

Hey All,

At the moment I'm taking the simple aproach to creating an excel file by just doing the following:

<?
$data = 'Blah blah blah';
header("Content-type: application/x-msdownload"); 
header("Content-Disposition: attachment; filename=extraction.xls"); 
header("Pragma: no-cache"); 
header("Expires: 0"); 
print "$header$data"; 
?>

...this works well for what I need and deals with all the html formating I use, but now I want to be able to setup the print areas (or the page breaks) on the excel sheet.

Really trying to keep this an simple as possible and I was hoping to avoid using other classes.

Does anyone have any experience with doing this or have any suggestions?

Cheers!

[middleman666]

After more research, I see this is possibly more of an html issue as I'm trying to create page breaks in the html which when read out in excel do the same thing.

To create a page break in excel using VB code, you use:
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell

I've tried using this to replicate that in excel:
<div style="page-break-after:always;">&nbsp;</div>

...but not having much luck.

Any suggestions?

[middleman666]

Nevermind, don't know why I didn't try this first, but you can save an excel file as a html file and then use the code from that to create the exact file again.

Simples.