read style from excel and apply to other excel file

Topics: Developer Forum, User Forum
May 22, 2008 at 11:03 AM
phpexcel is really great.i use it in my recent project to generate some excel report.
the problem is:is is possible for phpexcel to read page setting/formating style from a teamplate/common excel and apply those info to other newly generated excel.
May 23, 2008 at 6:42 AM
It should be possible to do that, the style collection is available from the PHPExcel_worksheet. You can then apply these styles on another PHPExcel_Worksheet (make sure to update al parent/child relations though)
May 24, 2008 at 2:10 AM
fi so,that sounds great.
just have such situation,given a sample excel report,and i have all the data ready.and i don't want to use code to do the format setting,like font,color....

is that support for excel5(which version)?
is that work for more than one sheet in one workbook?
can you give me a code snippet?
May 26, 2008 at 7:21 AM
The Excel5 reader does not support this, Excel2007 does.
Aug 18, 2008 at 4:12 AM
Please note that a good deal of style support has been added for the Excel5 reader in the latest source code.