How can I export Gantt charts to excel sheets?

Hello friends.
I have designed Gantt charts to illustrate a project schedule, which has several sub projects.
I want to export that Gantt charts to excel.
I have to use MS Excel 2007 for that task.
Is it possible to export Gantt charts to excel and how can I do that?
Is there anyone, who can help me?
