how to export resource using with gantt chart to excel?

[popovgp]

how to export resource using with gantt chart to excel?

[PopovGP]

This module exports column "Resouce names". If it is filled in your MS Project file, it will be exported.

[wuzhenda]

yes. but we want to seperate each human resource to see their task load. I'm trying to modify your script.

[PopovGP]

Could you describe how it should look like? You may draw some sample by hand.

[wuzhenda]

sth like this.
I generated the image use your script,and manually modified some items.

[PopovGP]

PersonB is working on several projects, which are in separate files?
ProjectDetail is a task name?

[wuzhenda]

No. ProjectA and ProjectB are the top level projects. ProjectDetails are the second level projects.
They are all in the same file. I use the sub level projects to show project milestone.

[wuzhenda]

which I want to implement is sth like the "Resource Using View",but use gantt chart instead of the the right part of the view,
and export to excel.

[PopovGP]

I understand now how it should look like. Sorry, at present it's not implemented and you should try do it yourself.
I can do it, but later.

[wuzhenda]

OK.I'm trying now.

[mhykol2k]

@wuzhenda Did you get this sorted, we are having the same issue

[wuzhenda]

@wuzhenda Did you get this sorted, we are having the same issue

yes,I modified and fit my needs.
https://github.com/wuzhenda/Export-MS-Project-to-MS-Excel

but since two years passed and this repo has added some commits, sth maybe tested again.