Login   Register  
PHP Classes
elePHPant
Icontem

Changing default text-appearance

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      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:

http://chicago.sourceforge.net/devel/docs/excel/
http://sc.openoffice.org/excelfileformat.pdf


  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.