OLE-Objects/Charts in other sheets

Topics: Developer Forum
May 5, 2011 at 11:36 PM

Hi,

 

Is there a chance with .xlsx to let phpexcel write into sheet 1 without "hurting" sheet2? So sheet2 can contain OLE objects, charts and load the (input) data from sheet 1.

If not: Can 2 .xlsx documents be merged together to finally have the expecteded solution of sheet 1+2 where #2 is not filtered or cleared for unknown objects?

 

Regards

aham

Coordinator
May 6, 2011 at 9:14 PM
aham wrote:

Is there a chance with .xlsx to let phpexcel write into sheet 1 without "hurting" sheet2? So sheet2 can contain OLE objects, charts and load the (input) data from sheet 1.

At present PHPExcel does not support either OLE objects or charts, although I'm working to implement charts for the next release. So currently, the answer is "No"

aham wrote:

If not: Can 2 .xlsx documents be merged together to finally have the expecteded solution of sheet 1+2 where #2 is not filtered or cleared for unknown objects?

 The answer to this is "No"... you'd need to find an alternative utility to do this.