Using visio to Create an OrgChart from a CSV file in C#

[TomServo]

Hello all,
There is a way to have visio load an orgchart by feeding it a CSV file. I am
not sure how to do that in C# because in Visio when loading this file you end
up going through a wizard with some options to choose.
http://office.microsoft.com/en-us/visio/HA011101591033.aspx

this is done in Visio using a wizard that takes a number of options, such as
name, manager name, which are all headers of rows in the csv or excel file. I
have the excel file available, but I need to open op visio and feed it this
file and build the orgchart using C# code. Is that possible? and are there
any different approaches to performing this?

 

[AlEdlund]

A couple of things.
a.) Check out David Parker's blog for some interesting 'build org charts
without the wizard'
http://bvisual.spaces.live.com/blog/cns!3350D61BC93733A9!1311.entry
b.) I'd start by getting the visio sdk and then do some research on calling
add-ins programmatically. I've seen examples in vba, not in c# but they are
probably out there.
c.) the wizard is pretty strong on having the right data in the correct
field.
al