	Login		Register

elePHPant

Changing default text-appearance

Recommend this page to a friend!

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

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

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

Ben Keen	2005-01-28 21:46:11 - In reply to message 2 from Ignatius Teo
	Thanks! :-)

	4. Re: Changing default text-appearance		Reply

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

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

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.