Solved

How can set page break using PHP + COM  Excel.

Posted on 2009-07-16
3
536 Views
Last Modified: 2013-12-13
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
0
Comment
Question by:Tim
  • 2
3 Comments
 
LVL 34

Expert Comment

by:gr8gonzo
ID: 24875316
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.
0
 

Author Comment

by:Tim
ID: 24938990
Thanks. Later I will try these.
But now I need find the way to deal with " row height" using PHP + COM  .
0
 

Accepted Solution

by:
Tim earned 0 total points
ID: 25062548
I already found the page break .
$sheet->HPageBreaks->Add($cell);
Thanks
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
.htaccess 5 39
google map tracking website 5 24
How would I do a website like this? 5 60
PHP error function not working on AWS 10 11
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question