Export Option for Excel

adam_hafner

Can you add the ability to have Excel output for the dependency list?  I know you can export to XML but it would be much more valuable to users to have a direct output to Excel format where it would list the object, what uses that object and what objects it uses just like in the PDF, but something that could be edited or expanded upon.

Jon_Kirkwood

Hi @adam_hafner

 

Thank you for reaching out on the Redgate forums, I can submit this to our developers as a potential feature request.

Looking through our internal systems; I have referenced a few requests for an ability to export a list into Excel over the years. However, there hasn't been enough demand previously to prioritize implementing this feature.

 

Currently, the solutions provided within the application are to export the XML and open into Excel or to copy the diagram and paste it into Excel or similar programs as an image.

 

I did some testing and used Excels data import to bring tables from the PDF export into Excel; as a rough test it did import as separate books within Excel, but it may be possible to build a solution using that export.  

adam_hafner

@Jon_Kirkwood Would you be able to provide some instructions on how you were able to import this into Excel?  I tried something similar, but it was not intuitive and I couldn't get anything that was very useful without a lot of effort.  So if there's something I was overlooking, I am open to suggestions for a workaround until an Excel output could be possible.

Thanks!

--Adam