PHP Classes

Changing default text-appearance

Recommend this page to a friend!

      MS-Excel Stream Handler  >  All threads  >  Changing default text-appearance  >  (Un) Subscribe thread alerts  
Subject:Changing default text-appearance
Summary:Is there a way to have control over the default font size?
Messages:6
Author:Ben Keen
Date:2005-01-28 01:07:36
Update:2006-11-08 17:24:23
 

  1. Changing default text-appearance   Reply   Report abuse  
Picture of Ben Keen Ben Keen - 2005-01-28 01:07:36
This may be asking a bit much, but is there any way to gain control over the appearance of the generated content? In my instance, I'd like to be able to change the default font-size. And having bold / italics would be handy for column headers.

Any ideas...?

  2. Re: Changing default text-appearance   Reply   Report abuse  
Picture of Ignatius Teo Ignatius Teo - 2005-01-28 04:00:57 - In reply to message 1 from Ben Keen
This has been the most common question since this class was released.
Information on the Binary Interchange File Format (BIFF8) will provide additional information on worksheets, font and cell formating.

Hopefully you will find the following links useful:

chicago.sourceforge.net/devel/docs/ ...
sc.openoffice.org/excelfileformat.p ...


  3. Re: Changing default text-appearance   Reply   Report abuse  
Picture of Ben Keen Ben Keen - 2005-01-28 21:46:11 - In reply to message 2 from Ignatius Teo
Thanks! :-)

  4. Re: Changing default text-appearance   Reply   Report abuse  
Picture of Emmanuel Pays Emmanuel Pays - 2005-03-09 15:08:27 - In reply to message 1 from Ben Keen
Sorry but the links below didn't help me... Is still having no formatting and I don't understand why I can't do "/n" (return to a another line).

  5. Re: Changing default text-appearance   Reply   Report abuse  
Picture of Daniel Skovli Daniel Skovli - 2005-10-10 14:17:59 - In reply to message 4 from Emmanuel Pays
I'm also having some trouble styling the outputted excel document. If anyone could be kind enough to cook up a small example on this subject, I would be very thankful :-)

  6. Re: Changing default text-appearance   Reply   Report abuse  
Picture of Nick Peters Nick Peters - 2006-11-08 17:24:23 - In reply to message 5 from Daniel Skovli
is there a way to write the biff8 information through your stream handler? Or do i have to write the data to file, close it then open the xls file another way?

Thanks in advance.