91
Automation Interface, Add-Ins and Tools / Re: Possible to Export to Excel?
« on: November 16, 2007, 10:56:59 am »
Kchoi,
May I suggest that you download the free 20 day evaluation copy of Time Architect v1.1 from http://www.timearchitect.net?
As well as being a project and time management tool for EA, Time Architect offers a very powerful sort,filter and analysis function (and more...). From this data grid it is possible to export the grid to Excel including the element notes.
From here you can sort and filter your requirements by all of the standard EA tags before you export to Excel.
You now have everything you need in Excel
Now explore TA...
Hope this helps! Once installed, this should get your data out to Excel in about 2 minutes (depending on the number of requirements!)
Any questions please feel free to ask.
All the best,
Matt
Solutions Reality Limited
(Creators of Time Architect)
May I suggest that you download the free 20 day evaluation copy of Time Architect v1.1 from http://www.timearchitect.net?
As well as being a project and time management tool for EA, Time Architect offers a very powerful sort,filter and analysis function (and more...). From this data grid it is possible to export the grid to Excel including the element notes.
From here you can sort and filter your requirements by all of the standard EA tags before you export to Excel.
- Download and install Time Architect. There are 2 versions of the installer depending on whether you have .net 2.0 installed or not.
- Open your project in EA
- Select the package that you wish to export to Excel (can export child packages too).
- Open Add-in>Time Architect>Draw Gantt chart.
- If you want child packages too, then check the 'Include Child Packages' Option
- Click the 'Get Gantt Chart - Element View' button.
- When complete you will see a Gantt Chart (you can ignore this for now!)
- Click on the grid icon in the Time Architect toolbar - to the left of the ? icon
- Filter and sort as needed
- Click the arrow to the right of the grid icon
- Click the 'Export Grid to Excel with notes' icon - 2nd one.
You now have everything you need in Excel
Now explore TA...
Hope this helps! Once installed, this should get your data out to Excel in about 2 minutes (depending on the number of requirements!)
Any questions please feel free to ask.
All the best,
Matt
Solutions Reality Limited
(Creators of Time Architect)