Link to home
Start Free TrialLog in
Avatar of Tim
TimFlag for Canada

asked on

How can set page break using PHP + COM Excel.

I am working on PHP + COM  Excel.
I can create a excel , but I can not find how to deal with some  issue;
Like how to set page brake, how to set row height...
Thanks
Avatar of gr8gonzo
gr8gonzo
Flag of United States of America image

Not sure about this, but I do know that using Office COM objects has never been very stable (even using different programming languages). Sometimes the processes don't close properly, which can lead to memory problems on your server if you don't have a way to kill the processes automatically (and then sometimes you might accidentally kill the process while its running).

I would recommend switching to something like:
http://phpclasses.ranchoweb.com/browse/package/767.html
or
http://www.codeplex.com/PHPExcel

I have used the first one very successfully. It reads/writes Excel 97-2003 files natively without COM objects at all. I have not tried the second one yet.
Avatar of Tim

ASKER

Thanks. Later I will try these.
But now I need find the way to deal with " row height" using PHP + COM  .
ASKER CERTIFIED SOLUTION
Avatar of Tim
Tim
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial