How to output worksheets with colored tabs and worksheets itself through PHPExcel_Writer_HTML

Topics: User Forum
Mar 23, 2010 at 12:03 PM

Hello PHPExcel friends.

Can anybody help me. I am trying to do the following task:

I have excel file (xlsx). File consists of several worksheets with time-tables. Each worksheet has its name and color (as tab). I need to publish this file on site. Time-tables must be formated like this (example):

-------------------------------------------------------

Andrew (name of 1st worksheet color in red)

Andrew's time-table

Mat (name of 2nd worksheet color in blue)

Mat's time table

and so on.

-------------------------------------------------------

Is there possibility to output also tabs name and color of worksheet using PHPExcel_Writer_HTML (generateHTMLHeader(), generateStyles(), generateSheetData(), generateHTMLFooter() ).

Or what's other better possibility to do my task?

Thanks in advance.

Developer
Mar 26, 2010 at 7:39 AM

Creating work item:

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=12289