Organization Chart (Import from Excel) Example for WPF

Organization Chart (Import from Excel) Example for WPF

Nevron NOV Diagram for WPF ships with hundreds of examples with full source code, as part of the Nevron Open Vision Suite. All WPF Diagram examples are also available as a stand-alone Visual Studio solution in C# and VB.NET, which you can download from the links below.

Organization Chart (Import from Excel) Example for WPF Description

Demonstrates how to create an organization chart diagram (org chart) from an Excel spreadsheet.


Org Chart Import Example

C# Organization Chart (Import from Excel) Example Code for Nevron Diagram for WPF
Language: C#

using Nevron.Nov;
using Nevron.Nov.Diagram;
using Nevron.Nov.Diagram.Shapes.Business.OrgChart;
using Nevron.Nov.Diagram.Themes;
using Nevron.Nov.Dom;
using Nevron.Nov.Graphics;
using Nevron.Nov.Layout;
using Nevron.Nov.UI;
using Nevron.Nov.Windows.Forms;
using System.Windows.Forms;

namespace NovWinFormsProject
{
	public partial class Form1 : Form
	{
		#region Constructors

		public Form1()
		{
			InitializeComponent();

			// Set form title
			Text = "NOV WinForms - NOrgChartImportExample";

			// Create the NOV example and its controls
			NWidget exampleContent = CreateExampleContent();
			NWidget exampleControls = CreateExampleControls();
			if (exampleControls != null)
			{
				exampleControls.PreferredWidth = 300;
			}

			// Place the example and its controls in a pair box
			NPairBox pairBox = new NPairBox(exampleContent, exampleControls);
			pairBox.FillMode = ENStackFillMode.First;
			pairBox.FitMode = ENStackFitMode.First;
			pairBox.Margins = new NMargins(NDesign.HorizontalSpacing, NDesign.VerticalSpacing);

			// Host the example in the form
			NNovWidgetHost host = new NNovWidgetHost(pairBox);
			host.Dock = DockStyle.Fill;
			Controls.Add(host);
		}

		#endregion

		#region Example

		public NWidget CreateExampleContent()
		{
			// Create a simple drawing
			NDrawingViewWithRibbon drawingViewWithRibbon = new NDrawingViewWithRibbon();
			m_DrawingView = drawingViewWithRibbon.View;

            // hide grid and ports
            m_DrawingView.Content.ScreenVisibility.ShowGrid = false;
            m_DrawingView.Content.ScreenVisibility.ShowPorts = false;

            m_DrawingView.Document.HistoryService.Pause();
			try
			{
				InitDiagram(m_DrawingView.Document);
			}
			finally
			{
				m_DrawingView.Document.HistoryService.Resume();
			}

			return drawingViewWithRibbon;
		}
		public NWidget CreateExampleControls()
		{
			return null;
		}
		public string GetExampleDescription()
		{
			return @"

Demonstrates how to create an organization chart diagram (org chart) from an Excel spreadsheet.

"; } /// /// Gets the relevant documentation links for the example /// /// public (string Name, string Url)[] GetDocumentationUrls() { return new[] { ("Shapes", "https://www.nevron.com/docs/openvision/diagram-shapes.html"), ("Data Tables", "https://www.nevron.com/docs/openvision/data-tables.html"), ("Layered Tree Layout", "https://www.nevron.com/docs/openvision/diagram-layered-tree-layout.html"), ("Text Block", "https://www.nevron.com/docs/openvision/diagram-text-block.html"), }; } private void InitDiagram(NDrawingDocument drawingDocument) { NPage page = drawingDocument.Content.ActivePage; // Create an org chart from an Excel spreadsheet NOrganizationChartVisualizer importer = new NOrganizationChartVisualizer(); importer.Columns.Add("Id", "ID"); importer.Columns.Add("Name", "Employee Name"); importer.Columns.Add("ReportsTo", "Reports to"); importer.Columns.Add("Position", "Position"); importer.BuildDiagramFromStream(m_DrawingView, new System.IO.MemoryStream(Nevron.Nov.NConvert.FromBase64String("UEsDBBQABgAIAAAAIQBBN4LPbgEAAAQFAAATAAgCW0NvbnRlbnRfVHlwZXNdLnhtbCCiBAIooAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACsVMluwjAQvVfqP0S+Vomhh6qqCBy6HFsk6AeYeJJYJLblGSj8fSdmUVWxCMElUWzPWybzPBit2iZZQkDjbC76WU8kYAunja1y8T39SJ9FgqSsVo2zkIs1oBgN7+8G07UHTLjaYi5qIv8iJRY1tAoz58HyTulCq4g/QyW9KuaqAvnY6z3JwlkCSyl1GGI4eINSLRpK3le8vFEyM1Ykr5tzHVUulPeNKRSxULm0+h9J6srSFKBdsWgZOkMfQGmsAahtMh8MM4YJELExFPIgZ4AGLyPdusq4MgrD2nh8YOtHGLqd4662dV/8O4LRkIxVoE/Vsne5auSPC/OZc/PsNMilrYktylpl7E73Cf54GGV89W8spPMXgc/oIJ4xkPF5vYQIc4YQad0A3rrtEfQcc60C6Anx9FY3F/AX+5QOjtQ4OI+c2gCXd2EXka469QwEgQzsQ3Jo2PaMHPmr2w7dnaJBH+CW8Q4b/gIAAP//AwBQSwMEFAAGAAgAAAAhALVVMCP0AAAATAIAAAsACAJfcmVscy8ucmVscyCiBAIooAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACskk1PwzAMhu9I/IfI99XdkBBCS3dBSLshVH6ASdwPtY2jJBvdvyccEFQagwNHf71+/Mrb3TyN6sgh9uI0rIsSFDsjtnethpf6cXUHKiZylkZxrOHEEXbV9dX2mUdKeSh2vY8qq7iooUvJ3yNG0/FEsRDPLlcaCROlHIYWPZmBWsZNWd5i+K4B1UJT7a2GsLc3oOqTz5t/15am6Q0/iDlM7NKZFchzYmfZrnzIbCH1+RpVU2g5abBinnI6InlfZGzA80SbvxP9fC1OnMhSIjQS+DLPR8cloPV/WrQ08cudecQ3CcOryPDJgosfqN4BAAD//wMAUEsDBBQABgAIAAAAIQDK41uktAIAAC4GAAAPAAAAeGwvd29ya2Jvb2sueG1spFTbTuMwEH1faf8h8nvIhSRtI1JEW6qtBCwCFniohNzEbSwcO2s7vQjx7ztOmhboCwtRa8ce5/jMzJk5OV0XzFoSqajgCfKOXGQRnoqM8kWC/tyN7S6ylMY8w0xwkqANUei0//PHyUrI55kQzxYAcJWgXOsydhyV5qTA6kiUhINlLmSBNSzlwlGlJDhTOSG6YI7vupFTYMpRgxDLz2CI+ZymZCTSqiBcNyCSMKyBvsppqVq0Iv0MXIHlc1XaqShKgJhRRvWmBkVWkcaTBRcSzxi4vfZCay3hF8Hfc2Hw25vAdHBVQVMplJjrI4B2GtIH/nuu43nvQrA+jMHnkAJHkiU1OdyxktEXWUU7rGgP5rnfRvNAWrVWYgjeF9HCHTcf9U/mlJH7RroWLssrXJhMMWQxrPR5RjXJEtSBpViR/UaILFmVg4oysPqR73eQ09/J+VpaGZnjiuk7EHILD5XhB74fmZMgjDOmieRYk6HgGnS49eu7mquxh7kAhVs35G9FJYHCAn2BrzDiNMYzdY11blWSJWgUT6/IUgo+vfp9Pz1f46JkRE2HQpLpDVGikiksB5RjuZk+Xtw+Tt9IFh/Wx3+IFqcmEg6EoqHbvH8MC7CWcSvMay0teJ+MLiA5t3gJqQJBZNtKnkAuvOMnnsrYe3oJe8No7A96djcYBnbgRwP7bNwL7e5593gc+MMONI9XcEZGcSpwpfOtCgx0ggJI+YHpEq9bi+fGFc32NF7c7WOb+cPQ2l6Nw6bf3VOyUnu9mKW1fqA8E6sE9SIXnNq0y6BjRL+qjQ800zkILgy7u71fhC5yYOyFx2YT6sIwS9A7RqOG0Rge2wzvGDlvKNWdFajVs8Xrarg13daDFm7mOsig/tjcISeZVyex/SzFLAX1m6k+GISR35xoW33/HwAAAP//AwBQSwMEFAAGAAgAAAAhAIE+lJfzAAAAugIAABoACAF4bC9fcmVscy93b3JrYm9vay54bWwucmVscyCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKxSTUvEMBC9C/6HMHebdhUR2XQvIuxV6w8IybQp2yYhM3703xsqul1Y1ksvA2+Gee/Nx3b3NQ7iAxP1wSuoihIEehNs7zsFb83zzQMIYu2tHoJHBRMS7Orrq+0LDppzE7k+ksgsnhQ45vgoJRmHo6YiRPS50oY0as4wdTJqc9Adyk1Z3su05ID6hFPsrYK0t7cgmilm5f+5Q9v2Bp+CeR/R8xkJSTwNeQDR6NQhK/jBRfYI8rz8Zk15zmvBo/oM5RyrSx6qNT18hnQgh8hHH38pknPlopm7Ve/hdEL7yim/2/Isy/TvZuTJx9XfAAAA//8DAFBLAwQUAAYACAAAACEAsVk7jJADAACFCQAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbJyTXY+jIBSG7zfZ/0C4r2hrv0ztZDJNs3O32c9risdKCuIC/cpm//setLaT9KYzRjko8LzvgePi6aQVOYB10tQ5TaKYEqiFKWS9zenPH+vBjBLneV1wZWrI6RkcfVp+/rQ4GrtzFYAnSKhdTivvm4wxJyrQ3EWmgRpHSmM19/hqt8w1FnjRLtKKDeN4wjSXNe0ImX2EYcpSClgZsddQ+w5iQXGP/l0lG9fTtHgEp7nd7ZuBMLpBxEYq6c8tlBItstdtbSzfKMz7lKRckJPFe4jPqJdpv98paSmscab0EZJZ5/k+/TmbMy6upPv8H8IkKbNwkOEAb6jhxywl4ytreIONPgibXGFhu2y2l0VO/8aXa4AxCU18a/qxf3S5KCSecMiKWChz+pxkqylly0VbP78kHN2bPvF88x0UCA+okVASynNjzC5MfMVPMRJdOyEQufDyAC+gVE5fMFP3p9XALgqwq8Lbfq+2bgv6qyUFlHyv/Ddz/AJyW3mUTaMxJhoqJSvOK3ACSxSlo9E4cIVRCMGWaBn+NSwxfurMysJXOR1F8Ww+S0dTpGzA+bUMUErE3nmjf3eTkguqg6D3FoLxeBmfRsl0Ppm9A4Kn00Iw9hBUfdBBelmMsV8cR+N0eLFw7521+/AfAAD//wAAAP//lJThDoIgFIVfxfEAGYJajdhSXsSZm7+shbN6+67QAG/U8h/j3nP23XMZQvddN6pmbKS4Xe7J7UgoSfS1GTScDpwk/QiHcpOT5EF50x7OT9XpthvgervhOZGinVWnWWbEUNBwO8lMpJMUafvuqD47KFu21JGWZYf67PAeKUzgxsiWY0TgmYfPDDBFwGDhhtkhjrDGXW1BwNYQsGhkYOEI9igrq0DMKlTkcS5Yarjg38lww4X2VIGF46JbBGYlaPsqlJRxMHhj/4PNy5ukj968wgosPBjKprYSnFgo+ZJYsQasMGDeyYKBhQPDgVkFGkWFiiIeWLmGqzRc3slygYUPDO2sthIcWCjBgaX+P3kBAAD//wAAAP//NI1BDoJQDAWv0vQAojHGaPis3LBwxQmqFGhE2pSqiaf3Y8LuzVvMlEY9X8l7mWYYuYuE280RwaUf1h1q//eAcNMIfa40MLXsC+0ROtVYoajKxdtwvAyMjL2RLyc8IagLT0EhOiU09XCSQHizh9xpvJhkX+6fpU3odbvDLCs+6o95YI7qBwAA//8DAFBLAwQUAAYACAAAACEAvaC/vUsHAAAdIgAAEwAAAHhsL3RoZW1lL3RoZW1lMS54bWzsWktvGzcQvhfofyD2nliyJccyIgeWLMVJ/IKtpMiRWlG7tLnLBUnZ0a1IjgUKFE2LXgr01kPRNkAC9JL+Grcp2hTIX+iQXElLi4qtxkVfdoB4H98M583ZoW/eepQwdEyEpDytB+XrpQCRNOQ9mkb14H6nfW0lQFLhtIcZT0k9GBIZ3Fp7/72beFXFJCEI6FO5iutBrFS2urAgQ3iM5XWekRTe9blIsIJbES30BD4BvglbWCyVlhcSTNMApTgBtrv9Pg0J6miWwdqIeYvBbaqkfhAycaBZE4fCYHtHZY2QQ9lkAh1jVg9gnR4/6ZBHKkAMSwUv6kHJ/AQLazcX8GpOxNQM2gJd2/zkdDlB72jRrCmi7njRcrtSu7Ex5m8ATE3jWq1Ws1Ue8zMAHIagqZWlyLPSXik3RjwLIHs5zbtZqpYqLr7Af2lK5lqj0ajWclksUwOyl5Up/EppubK+6OANyOKrU/hKY73ZXHbwBmTxy1P49o3acsXFG1DMaHo0hdYObbdz7mNIn7NNL3wF4CulHD5BQTSMo0sv0eepmhVrCT7kog0ADWRY0RSpYUb6OIQobuKkKygOUIZTLuFBabHULi3B//pfxVxV9PJ4leACnX0UyqlHWhIkQ0EzVQ/uAtegAHnz8ts3L5+jNy+fnT5+cfr4h9MnT04ff295OYSbOI2KhK+//uT3Lz9Evz3/6vXTz/x4WcT//N1HP/34qR8I+TXR/9Xnz3558ezVFx//+s1TD3xd4G4R3qEJkWiHnKB9noBuxjCu5KQr5qPoxJg6FDgG3h7WLRU7wJ0hZj5cg7jGeyCgtPiAtweHjqwHsRgo6ln5Xpw4wG3OWYMLrwHu6bUKFu4M0si/uBgUcfsYH/vWbuLUcW1rkEFNhZCdtn0zJo6YewynCkckJQrpd/yIEA/ZQ0odu27TUHDJ+wo9pKiBqdckHdp1AmlCtEkT8MvQJyC42rHN9gPU4Myn9QY5dpGQEJh5hO8Q5pjxNh4onPhYdnDCigbfwir2CXkwFGER15IKPB0RxlGrR6T00ewK0Lfg9HsYqpnX7dtsmLhIoeiRj+cW5ryI3OBHzRgnmVdmmsZF7B15BCGK0R5XPvg2dzNE34MfcDrT3Q8ocdx9fiG4TyNHpEmA6DcD4fHlbcLdfByyPia+KrMuEqewrkMN90VHYxA5ob1FCMMnuEcIun/HI0GDZ47NJ0LfjaGqbBJfYN3Fbqzq+5RI6I10MzOdpltUOiF7QCI+Q57t4ZnCM8RpgsUszjvgdSd0YW/zltJdFh4VgTsUej6IF69RdiXwKAR3axbXvRg7u5a+l/54HQrHfxfJMcjLw3nzEmjI3DRQ2C9smw5mzgKTgOlgirZ85RZIHPdPSPS+asgGXrq+m7QTN0A35DQ5CU3f1vEwCg480/FUrzoe27Kd7XhmVZbNM33OLNy/sLvZwIN0j8CGMl26rpqbq+Ym+M83N7Ny+aqluWpprloa30fYX9LSTLoYaHAmEx4z70lmjnv6lLEDNWRkS5qJj4QPm14bHppRlJlHjsd/WQyXWh9YwMFFAhsaJLj6gKr4IMYZDIfKZngZyZx1JFHGJcyMzGMzRiVneJvBKIWRkJlxVvX0y9pPYrXNe/bxUnHKOWZjpIrMJHW00JJmcNHFlm6822JlK9VMs7mqlY1opmNwVBurrE08sv5YNXg4tiZ8MSP4zgYrL8OwWcsOczRor3va7tZHI7fopS/VRTKGb8LcR1rvaR+VjZNGsTKliNbDBoOeWJ7jo8JqNc32HVa7iJOKy1VmLDfy3rt4aTSmnXhJ5+2ZdGRpMTlZik7qQa26WA1QiLN60IcBLVwmGXhd6u8dzCI45QiVsGF/bjKbcJ14s+YPyzLM3K3dpxR26kAmpNrAMrahYV7lIcBSM0428i9WwayXpYCnGl1MiqUVCIa/TQqwo+ta0u+TUBWdXXhi5ukGkJdSPlBEHMS9E9RlA7GPwf06VEGfHpUwSTcVQd/AoZC2tnnlFuc86YpHMQZnn2OWxTgvtzpFR5ls4aYgjWUwd1ZaIx7o5pXdKDe/KiblL0mVYhj/z1TR+wmMtpd62gMhnEkKjHSm1AMuVMyhCmUxDdsCDmRM7YBogYNFeA1BBSej5rcgx/q3zTnLw6Q1TCjVPo2QoLAfqVgQsgdlyUTfOczK+d5lWbKcke0wJuLKzIrdJceEdXQNXNZ7e4BiCHVTTfIyYHBn48+9zzOoG+km55/a+dhknrc9mOyqlv6CvUilUPQLW0HNu/eZnmpcDt6ysc+51dqKNaXxYvXCW20GBxRwLqkgJkIqQhg0mtYXvNzh+1BbEZya2/YKQVRfs40H0gXSlscuNE72oQ0mzcp2Xnl3e+ltFJyt5p3ueF3I0j/T6c5p7HFz5i7n5OLbu8/5jJ1b2LF1sdP1mBqS9myK6vZo9CFjHGP+PqP4JxS8ewiO3oDD6gFT0h5DP4LjKPjKsMfdkPzWuYZ07Q8AAAD//wMAUEsDBBQABgAIAAAAIQAuG4qk3gIAAPcGAAANAAAAeGwvc3R5bGVzLnhtbKRVbWvbMBD+Pth/EPruynbjLAm2y9LUUOjGIC3sq2LLjqhejKxkzsb+e0+2k7i0e+sIRNLp7rnnXnSOr1op0J6ZhmuV4ODCx4ipXBdcVQl+uM+8GUaNpaqgQiuW4ANr8FX6/l3c2INg6y1jFgGEahK8tbZeENLkWyZpc6FrpuCm1EZSC0dTkaY2jBaNM5KChL4/JZJyhXuEhcz/BkRS87irvVzLmlq+4YLbQ4eFkcwXt5XShm4EUG2DCc1RG0xNiFpzdNJJX/iRPDe60aW9AFyiy5Ln7CXdOZkTmp+RAPltSEFE/PBZ7K15I9KEGLbnrnw4jUutbINyvVM2wSEQdSlYPCr9TWXuCio8aKVx8x3tqQBJgEka51pogyyUDjLXSRSVrNe4poJvDHdqJZVcHHpx6ARdtQc9ySH3Tkgcj57NyE+n3/sx1SbBWRZ2P2dxdrZmlWbo4fZVbwNwtzTggAsxCrcXpDH0hWVGZXCLhv39oYa4FLRwzw+u/qhdGXoIwmhkQDqHabzRpoAnc0y0y2kvSmPBSgvxGF5t3Wp1Df8bbS20VRoXnFZaUeFydLQYNhBOzoRYu2f1tXyG3ZZI7WQm7W2RYHigLrvHLQQybHu8/uDwx2g99gg2BMr/Dova8oT/K+sA+L1O6mSNaF2Lg2vIodU6rsBulIJnCTiFglyfJPizmykC2nuggzY7LixXrwQPmEV7TqfvqmndfOgSffICWS1YSXfC3p8uE3zef2IF30l4UYPWF77XtoNI8Hl/56oeTJ0P1tq7Bt4ArGhneIJ/3Cw/zFc3WejN/OXMm1yyyJtHy5UXTa6Xq1U290P/+udoSv3HjOqGKhQ4mCwaAZPMDMEO5NdnWYJHh55+1+9Ae8x9Hk79j1Hge9mlH3iTKZ15s+ll5GVREK6mk+VNlEUj7tEbZ5lPgqCfio58tLBcMsHVsVbHCo2lUCQ4/iYIcqwEOX+x0icAAAD//wMAUEsDBBQABgAIAAAAIQAbWlnfFwEAABACAAAUAAAAeGwvc2hhcmVkU3RyaW5ncy54bWxkkUFLAzEQhe+C/yHkbrOKFJHdLdJqsbAiovQ87I7d0GRmzWRr++9N0YNkj/k+hsd7KRdH79QBg1imSl/PCq2QWu4s7Sr98f50daeVRKAOHBNW+oSiF/XlRSkSVbolqXQf43BvjLQ9epAZD0jJfHLwENMz7IwMAaGTHjF6Z26KYm48WNKq5ZFiyp1rNZL9GnH5B251XYqty1g3do9qzaFjKk2sS3PGv+oNBw5RVOTcPK9y8spiYyqZ88cjtmO0B8xFAwQ7DDleMsno0iIxNw8i9jzVRGyg3asVf8s0vWGyLagGTtOkDfekVkAWneRZW+ucBa+24Nx+errGtDqqTVoNpo394PiEqF7A/2tt0o/WPwAAAP//AwBQSwMEFAAGAAgAAAAhADttMkvBAAAAQgEAACMAAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0MS54bWwucmVsc4SPwYrCMBRF9wP+Q3h7k9aFDENTNyK4VecDYvraBtuXkPcU/XuzHGXA5eVwz+U2m/s8qRtmDpEs1LoCheRjF2iw8HvaLb9BsTjq3BQJLTyQYdMuvpoDTk5KiceQWBULsYVRJP0Yw37E2bGOCamQPubZSYl5MMn5ixvQrKpqbfJfB7QvTrXvLOR9V4M6PVJZ/uyOfR88bqO/zkjyz4RJOZBgPqJIOchF7fKAYkHrd/aea30OBKZtzMvz9gkAAP//AwBQSwMEFAAGAAgAAAAhALbkMxB6AwAAUA0AACcAAAB4bC9wcmludGVyU2V0dGluZ3MvcHJpbnRlclNldHRpbmdzMS5iaW7sVluPVEUQru/rnj4999kLsAt7ObuAXJS94CqoKLs7C+wSAkR4IMYHSQ4qiYFE11ddSXw3PvJm4g/Qv2B84MGf4D/xYa06ZwYWlkxmcbLRxOpUpk9XV33V1VXVc01W5aack0VZ0NGWB7I3gr8w+qds1tyN7wApy+PqUswEksgdQn8l5xVZ2qPdfrabdXYQ7PdFat998NDO83OrI1EF03FB5Ff/jZdPyvGnZlvu6qkfKqdy7YVozOeRsdi0ezhk2NuJyB/83RAyOMI5zxJDBui86VulIMnOj+jKqKDKGutssOmkYlI65mpMGFk2Q7YCE1LtwKNUUZsJE5foxpgqcnWXooxmqDPqQZW9cikNaZJKPTfYAYA0uvZZQvBbiV+OflmathpTF1P/HJACNxJIq1AyTxCQIMbhMmVIfZDhDOrQiLnqZ+VepoF4hsBA3cwyK9RDuzoaaLoWhzCMEYzyAA/yEMfcOA/zCCc4ySlOM+UMZ3mUx3icr/EET/IUT/N1vIEzmMM8FrCIs3gTS3gLb0NocCEPoZ9VPIuhr3jF88t113BNtDDkhjnCUXQAmQP6CT/pp/x0UEDM4ig6gDiJUzgNBeSZbC6bzxa4E/AczvMdvsv33AW8jw9wEctYwSrbWOOlcJlXuM4NXvXiipR4FjTkl48a8jiYW0UcwoFwMBwKY8l4chhHMIFJTGHaZV2/RO8kzjAOSalzD6LpQM2S2PKxVaSY09xzJWcBkFjkHHQhzoSQhBjKoRKqoRbqoUHRHFPtusYsjmsxFTeWR9IKRdbPS2oTr1zWsaTJ9Lgqcla/jS3JPtfvxe97S8FH2g9+8QKMmb1sZzU11ZSmT9EtNJ87sh9s44p8Kfe1QL/oUX69RInkXYhP+tLXvR+3r39068Mrq+25jXavmn/e3ivqaWW/BI9Q4ssa2isGYb/Utrf/5Q7un3s/KlRbbsh1uSwbsiaXdHZbZyv6xPRL/1R/fZCFtLW19dTv3/LeoE+8Da/cJ63JPflUi/lrLedNfW1v6femjvv69n4mXw3qdhItn7E7VkBaRo9yJ8107a9tGzU80WajrYsqobWHslJvbGt//VARl4GdQ93bbTFfiYXAmu7eafdp8u771JB1np1sgq5Od93+SEG+VYmxUbd9D+r0/9sZRARKxbv9nwrmvr98eT8YUIj+BgAA//8DAFBLAwQUAAYACAAAACEAnUqduWABAAByAgAAEQAIAWRvY1Byb3BzL2NvcmUueG1sIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAfJJJT8MwEIXvSPyHyPfESbrQWkkqKOqJIiTKIm7GnrYR8SLbdOHX4yRtaAXimLw337w3cjbZiSrYgLGlkjlKohgFIJnipVzl6GkxC0cosI5KTislIUd7sGhSXF5kTBOmDDwYpcG4EmzgSdISpnO0dk4TjC1bg6A28g7pxaUygjr/aVZYU/ZBV4DTOB5iAY5y6iiugaHuiOiA5KxD6k9TNQDOMFQgQDqLkyjBP14HRtg/BxrlxClKt9e+0yHuKZuzVuzcO1t2xu12G217TQyfP8Gv87vHpmpYyvpWDFCRcUaYAeqUKa7lCqrgPgqma2XeKf9al7DJ8ImjvmZFrZv7wy9L4Df74oFu/NBzRbny3t+6X9D0abcAD3xC0vY5Ki+96e1ihoo0TkZhPAjT0SIekV5K+sO3ev3ZfJ24/SEOIf4lpv0wTsN0vEiuSH9M0sEJ8Qgomtznr6T4BgAA//8DAFBLAwQUAAYACAAAACEAKQ/1xn0BAAD+AgAAEAAIAWRvY1Byb3BzL2FwcC54bWwgogQBKKAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACckstOwzAQRfdI/EPkPXUKCKHKMUI8xAJEpRZYG2fSWLh25Bmilq9nkoiSAit287i6Pr62utisfdZCQhdDIaaTXGQQbCxdWBXiaXl7dC4yJBNK42OAQmwBxYU+PFDzFBtI5AAztghYiJqomUmJtoa1wQmvA2+qmNaGuE0rGavKWbiO9n0NgeRxnp9J2BCEEsqjZmcoBsdZS/81LaPt+PB5uW0YWKvLpvHOGuJb6gdnU8RYUXazseCVHC8V0y3AvidHW50rOW7VwhoPV2ysK+MRlPweqDswXWhz4xJq1dKsBUsxZeg+OLZjkb0ahA6nEK1JzgRirE42NH3tG6SkX2J6wxqAUEkWDMO+HGvHtTvV017Axb6wMxhAeLGPuHTkAR+ruUn0B/F0TNwzDLwDzqLjG84c8/VX5pN+eN+78IZPzTJeG4Kv7PaHalGbBCXHvct2N1B3HFvynclVbcIKyi/N70X30s/Dd9bTs0l+kvMjjmZKfn9c/QkAAP//AwBQSwECLQAUAAYACAAAACEAQTeCz24BAAAEBQAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQC1VTAj9AAAAEwCAAALAAAAAAAAAAAAAAAAAKcDAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQDK41uktAIAAC4GAAAPAAAAAAAAAAAAAAAAAMwGAAB4bC93b3JrYm9vay54bWxQSwECLQAUAAYACAAAACEAgT6Ul/MAAAC6AgAAGgAAAAAAAAAAAAAAAACtCQAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECLQAUAAYACAAAACEAsVk7jJADAACFCQAAGAAAAAAAAAAAAAAAAADgCwAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAi0AFAAGAAgAAAAhAL2gv71LBwAAHSIAABMAAAAAAAAAAAAAAAAApg8AAHhsL3RoZW1lL3RoZW1lMS54bWxQSwECLQAUAAYACAAAACEALhuKpN4CAAD3BgAADQAAAAAAAAAAAAAAAAAiFwAAeGwvc3R5bGVzLnhtbFBLAQItABQABgAIAAAAIQAbWlnfFwEAABACAAAUAAAAAAAAAAAAAAAAACsaAAB4bC9zaGFyZWRTdHJpbmdzLnhtbFBLAQItABQABgAIAAAAIQA7bTJLwQAAAEIBAAAjAAAAAAAAAAAAAAAAAHQbAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0MS54bWwucmVsc1BLAQItABQABgAIAAAAIQC25DMQegMAAFANAAAnAAAAAAAAAAAAAAAAAHYcAAB4bC9wcmludGVyU2V0dGluZ3MvcHJpbnRlclNldHRpbmdzMS5iaW5QSwECLQAUAAYACAAAACEAnUqduWABAAByAgAAEQAAAAAAAAAAAAAAAAA1IAAAZG9jUHJvcHMvY29yZS54bWxQSwECLQAUAAYACAAAACEAKQ/1xn0BAAD+AgAAEAAAAAAAAAAAAAAAAADMIgAAZG9jUHJvcHMvYXBwLnhtbFBLBQYAAAAADAAMACYDAAB/JQAAAAA="))); // Add a title shape NShape titleShape = CreateTitleShape("Org Chart Import"); page.Items.Add(titleShape); // Size the page to content page.SizeToContent(); } #endregion #region Implementation private NShape CreateTitleShape(string title) { NDrawingTheme theme = NDrawingTheme.MyDrawNature; NShape titleShape = new NShape(); titleShape.SetBounds(0, -75, 350, 50); titleShape.Text = title; NTextBlock titleTextBlock = (NTextBlock)titleShape.TextBlock; titleTextBlock.ResizeMode = ENTextBlockResizeMode.ShapeSize; titleTextBlock.FontSize = 28; titleTextBlock.FontStyleBold = true; // Set theme-based colors to the title text, so that it changes when the user changes the theme NColor strokeColor = theme.ColorPalette.Variants[0][0]; strokeColor.Tag = new NThemeVariantColorInfo(0); titleTextBlock.Stroke = new NStroke(strokeColor); NColor fillColor = theme.ColorPalette.Variants[0][4]; fillColor.Tag = new NThemeVariantColorInfo(4); titleTextBlock.Fill = new NColorFill(fillColor); // Alternatively, you can also use fixed colors (uncomment the 2 lines below) //titleTextBlock.Stroke = new NStroke(NColor.DarkBlue); //titleTextBlock.Fill = new NColorFill(NColor.LightBlue); // Set an expression to center the title horizontally in the page titleShape.SetFx(NShape.PinXProperty, new NFormulaFx("$ParentSheet.X + $ParentSheet.Width / 2", true)); return titleShape; } #endregion #region Event Handlers #endregion #region Fields private NDrawingView m_DrawingView; #endregion #region Static Methods #endregion #region Constants #endregion #region Nested Types #endregion } }

Download a fully functional C# (.cs) Organization Chart (Import from Excel) Example for WPF Solution

VB.NET Organization Chart (Import from Excel) Example Code for Nevron Diagram for WPF
Language: VB.NET

Imports Nevron.Nov
Imports Nevron.Nov.Diagram
Imports Nevron.Nov.Diagram.Shapes.Business.OrgChart
Imports Nevron.Nov.Diagram.Themes
Imports Nevron.Nov.Dom
Imports Nevron.Nov.Graphics
Imports Nevron.Nov.Layout
Imports Nevron.Nov.UI
Imports Nevron.Nov.Windows.Wpf

Class MainWindow

#Region "Constructors"

	Public Sub New()
		' This call is required by the designer.
		InitializeComponent()

		' Add any initialization after the InitializeComponent() call.

		' Set form title
		Title = "NOV WPF - NOrgChartImportExample"

		' Create the NOV example and its controls
		Dim exampleContent As NWidget = CreateExampleContent()
		Dim exampleControls As NWidget = CreateExampleControls()
		If Not exampleControls Is Nothing Then
			exampleControls.PreferredWidth = 300
		End If

		' Place the example and its controls in a pair box
		Dim pairBox As NPairBox = New NPairBox(exampleContent, exampleControls)
		pairBox.FillMode = ENStackFillMode.First
		pairBox.FitMode = ENStackFitMode.First
		pairBox.Margins = New NMargins(NDesign.HorizontalSpacing, NDesign.VerticalSpacing)

		' Host the example in the form
		Dim host As NNovWidgetHost(Of NWidget) = New NNovWidgetHost(Of NWidget)(pairBox)
		Content = host
	End Sub


#End Region

#Region "Example"

        Public Function CreateExampleContent() As NWidget
            ' Create a simple drawing
            Dim drawingViewWithRibbon As NDrawingViewWithRibbon = New NDrawingViewWithRibbon()
            m_DrawingView = drawingViewWithRibbon.View

            ' hide grid and ports
            m_DrawingView.Content.ScreenVisibility.ShowGrid = False
            m_DrawingView.Content.ScreenVisibility.ShowPorts = False

            m_DrawingView.Document.HistoryService.Pause()
            Try
                InitDiagram(m_DrawingView.Document)
            Finally
                m_DrawingView.Document.HistoryService.Resume()
            End Try

            Return drawingViewWithRibbon
        End Function
        Public Function CreateExampleControls() As NWidget
            Return Nothing
        End Function
        Public Function GetExampleDescription() As String
            Return "

Demonstrates how to create an organization chart diagram (org chart) from an Excel spreadsheet.

" End Function ''' ''' Gets the relevant documentation links for the example ''' ''' Public Function GetDocumentationUrls() As (String, String)() Return {("Shapes", "https://www.nevron.com/docs/openvision/diagram-shapes.html"), ("Data Tables", "https://www.nevron.com/docs/openvision/data-tables.html"), ("Layered Tree Layout", "https://www.nevron.com/docs/openvision/diagram-layered-tree-layout.html"), ("Text Block", "https://www.nevron.com/docs/openvision/diagram-text-block.html")} End Function Private Sub InitDiagram(drawingDocument As NDrawingDocument) Dim page = drawingDocument.Content.ActivePage ' Create an org chart from an Excel spreadsheet Dim importer As NOrganizationChartVisualizer = New NOrganizationChartVisualizer() importer.Columns.Add("Id", "ID") importer.Columns.Add("Name", "Employee Name") importer.Columns.Add("ReportsTo", "Reports to") importer.Columns.Add("Position", "Position") importer.BuildDiagramFromStream(m_DrawingView, new System.IO.MemoryStream(Nevron.Nov.NConvert.FromBase64String("UEsDBBQABgAIAAAAIQBBN4LPbgEAAAQFAAATAAgCW0NvbnRlbnRfVHlwZXNdLnhtbCCiBAIooAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACsVMluwjAQvVfqP0S+Vomhh6qqCBy6HFsk6AeYeJJYJLblGSj8fSdmUVWxCMElUWzPWybzPBit2iZZQkDjbC76WU8kYAunja1y8T39SJ9FgqSsVo2zkIs1oBgN7+8G07UHTLjaYi5qIv8iJRY1tAoz58HyTulCq4g/QyW9KuaqAvnY6z3JwlkCSyl1GGI4eINSLRpK3le8vFEyM1Ykr5tzHVUulPeNKRSxULm0+h9J6srSFKBdsWgZOkMfQGmsAahtMh8MM4YJELExFPIgZ4AGLyPdusq4MgrD2nh8YOtHGLqd4662dV/8O4LRkIxVoE/Vsne5auSPC/OZc/PsNMilrYktylpl7E73Cf54GGV89W8spPMXgc/oIJ4xkPF5vYQIc4YQad0A3rrtEfQcc60C6Anx9FY3F/AX+5QOjtQ4OI+c2gCXd2EXka469QwEgQzsQ3Jo2PaMHPmr2w7dnaJBH+CW8Q4b/gIAAP//AwBQSwMEFAAGAAgAAAAhALVVMCP0AAAATAIAAAsACAJfcmVscy8ucmVscyCiBAIooAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACskk1PwzAMhu9I/IfI99XdkBBCS3dBSLshVH6ASdwPtY2jJBvdvyccEFQagwNHf71+/Mrb3TyN6sgh9uI0rIsSFDsjtnethpf6cXUHKiZylkZxrOHEEXbV9dX2mUdKeSh2vY8qq7iooUvJ3yNG0/FEsRDPLlcaCROlHIYWPZmBWsZNWd5i+K4B1UJT7a2GsLc3oOqTz5t/15am6Q0/iDlM7NKZFchzYmfZrnzIbCH1+RpVU2g5abBinnI6InlfZGzA80SbvxP9fC1OnMhSIjQS+DLPR8cloPV/WrQ08cudecQ3CcOryPDJgosfqN4BAAD//wMAUEsDBBQABgAIAAAAIQDK41uktAIAAC4GAAAPAAAAeGwvd29ya2Jvb2sueG1spFTbTuMwEH1faf8h8nvIhSRtI1JEW6qtBCwCFniohNzEbSwcO2s7vQjx7ztOmhboCwtRa8ce5/jMzJk5OV0XzFoSqajgCfKOXGQRnoqM8kWC/tyN7S6ylMY8w0xwkqANUei0//PHyUrI55kQzxYAcJWgXOsydhyV5qTA6kiUhINlLmSBNSzlwlGlJDhTOSG6YI7vupFTYMpRgxDLz2CI+ZymZCTSqiBcNyCSMKyBvsppqVq0Iv0MXIHlc1XaqShKgJhRRvWmBkVWkcaTBRcSzxi4vfZCay3hF8Hfc2Hw25vAdHBVQVMplJjrI4B2GtIH/nuu43nvQrA+jMHnkAJHkiU1OdyxktEXWUU7rGgP5rnfRvNAWrVWYgjeF9HCHTcf9U/mlJH7RroWLssrXJhMMWQxrPR5RjXJEtSBpViR/UaILFmVg4oysPqR73eQ09/J+VpaGZnjiuk7EHILD5XhB74fmZMgjDOmieRYk6HgGnS49eu7mquxh7kAhVs35G9FJYHCAn2BrzDiNMYzdY11blWSJWgUT6/IUgo+vfp9Pz1f46JkRE2HQpLpDVGikiksB5RjuZk+Xtw+Tt9IFh/Wx3+IFqcmEg6EoqHbvH8MC7CWcSvMay0teJ+MLiA5t3gJqQJBZNtKnkAuvOMnnsrYe3oJe8No7A96djcYBnbgRwP7bNwL7e5593gc+MMONI9XcEZGcSpwpfOtCgx0ggJI+YHpEq9bi+fGFc32NF7c7WOb+cPQ2l6Nw6bf3VOyUnu9mKW1fqA8E6sE9SIXnNq0y6BjRL+qjQ800zkILgy7u71fhC5yYOyFx2YT6sIwS9A7RqOG0Rge2wzvGDlvKNWdFajVs8Xrarg13daDFm7mOsig/tjcISeZVyex/SzFLAX1m6k+GISR35xoW33/HwAAAP//AwBQSwMEFAAGAAgAAAAhAIE+lJfzAAAAugIAABoACAF4bC9fcmVscy93b3JrYm9vay54bWwucmVscyCiBAEooAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKxSTUvEMBC9C/6HMHebdhUR2XQvIuxV6w8IybQp2yYhM3703xsqul1Y1ksvA2+Gee/Nx3b3NQ7iAxP1wSuoihIEehNs7zsFb83zzQMIYu2tHoJHBRMS7Orrq+0LDppzE7k+ksgsnhQ45vgoJRmHo6YiRPS50oY0as4wdTJqc9Adyk1Z3su05ID6hFPsrYK0t7cgmilm5f+5Q9v2Bp+CeR/R8xkJSTwNeQDR6NQhK/jBRfYI8rz8Zk15zmvBo/oM5RyrSx6qNT18hnQgh8hHH38pknPlopm7Ve/hdEL7yim/2/Isy/TvZuTJx9XfAAAA//8DAFBLAwQUAAYACAAAACEAsVk7jJADAACFCQAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbJyTXY+jIBSG7zfZ/0C4r2hrv0ztZDJNs3O32c9risdKCuIC/cpm//setLaT9KYzRjko8LzvgePi6aQVOYB10tQ5TaKYEqiFKWS9zenPH+vBjBLneV1wZWrI6RkcfVp+/rQ4GrtzFYAnSKhdTivvm4wxJyrQ3EWmgRpHSmM19/hqt8w1FnjRLtKKDeN4wjSXNe0ImX2EYcpSClgZsddQ+w5iQXGP/l0lG9fTtHgEp7nd7ZuBMLpBxEYq6c8tlBItstdtbSzfKMz7lKRckJPFe4jPqJdpv98paSmscab0EZJZ5/k+/TmbMy6upPv8H8IkKbNwkOEAb6jhxywl4ytreIONPgibXGFhu2y2l0VO/8aXa4AxCU18a/qxf3S5KCSecMiKWChz+pxkqylly0VbP78kHN2bPvF88x0UCA+okVASynNjzC5MfMVPMRJdOyEQufDyAC+gVE5fMFP3p9XALgqwq8Lbfq+2bgv6qyUFlHyv/Ddz/AJyW3mUTaMxJhoqJSvOK3ACSxSlo9E4cIVRCMGWaBn+NSwxfurMysJXOR1F8Ww+S0dTpGzA+bUMUErE3nmjf3eTkguqg6D3FoLxeBmfRsl0Ppm9A4Kn00Iw9hBUfdBBelmMsV8cR+N0eLFw7521+/AfAAD//wAAAP//lJThDoIgFIVfxfEAGYJajdhSXsSZm7+shbN6+67QAG/U8h/j3nP23XMZQvddN6pmbKS4Xe7J7UgoSfS1GTScDpwk/QiHcpOT5EF50x7OT9XpthvgervhOZGinVWnWWbEUNBwO8lMpJMUafvuqD47KFu21JGWZYf67PAeKUzgxsiWY0TgmYfPDDBFwGDhhtkhjrDGXW1BwNYQsGhkYOEI9igrq0DMKlTkcS5Yarjg38lww4X2VIGF46JbBGYlaPsqlJRxMHhj/4PNy5ukj968wgosPBjKprYSnFgo+ZJYsQasMGDeyYKBhQPDgVkFGkWFiiIeWLmGqzRc3slygYUPDO2sthIcWCjBgaX+P3kBAAD//wAAAP//NI1BDoJQDAWv0vQAojHGaPis3LBwxQmqFGhE2pSqiaf3Y8LuzVvMlEY9X8l7mWYYuYuE280RwaUf1h1q//eAcNMIfa40MLXsC+0ROtVYoajKxdtwvAyMjL2RLyc8IagLT0EhOiU09XCSQHizh9xpvJhkX+6fpU3odbvDLCs+6o95YI7qBwAA//8DAFBLAwQUAAYACAAAACEAvaC/vUsHAAAdIgAAEwAAAHhsL3RoZW1lL3RoZW1lMS54bWzsWktvGzcQvhfofyD2nliyJccyIgeWLMVJ/IKtpMiRWlG7tLnLBUnZ0a1IjgUKFE2LXgr01kPRNkAC9JL+Grcp2hTIX+iQXElLi4qtxkVfdoB4H98M583ZoW/eepQwdEyEpDytB+XrpQCRNOQ9mkb14H6nfW0lQFLhtIcZT0k9GBIZ3Fp7/72beFXFJCEI6FO5iutBrFS2urAgQ3iM5XWekRTe9blIsIJbES30BD4BvglbWCyVlhcSTNMApTgBtrv9Pg0J6miWwdqIeYvBbaqkfhAycaBZE4fCYHtHZY2QQ9lkAh1jVg9gnR4/6ZBHKkAMSwUv6kHJ/AQLazcX8GpOxNQM2gJd2/zkdDlB72jRrCmi7njRcrtSu7Ex5m8ATE3jWq1Ws1Ue8zMAHIagqZWlyLPSXik3RjwLIHs5zbtZqpYqLr7Af2lK5lqj0ajWclksUwOyl5Up/EppubK+6OANyOKrU/hKY73ZXHbwBmTxy1P49o3acsXFG1DMaHo0hdYObbdz7mNIn7NNL3wF4CulHD5BQTSMo0sv0eepmhVrCT7kog0ADWRY0RSpYUb6OIQobuKkKygOUIZTLuFBabHULi3B//pfxVxV9PJ4leACnX0UyqlHWhIkQ0EzVQ/uAtegAHnz8ts3L5+jNy+fnT5+cfr4h9MnT04ff295OYSbOI2KhK+//uT3Lz9Evz3/6vXTz/x4WcT//N1HP/34qR8I+TXR/9Xnz3558ezVFx//+s1TD3xd4G4R3qEJkWiHnKB9noBuxjCu5KQr5qPoxJg6FDgG3h7WLRU7wJ0hZj5cg7jGeyCgtPiAtweHjqwHsRgo6ln5Xpw4wG3OWYMLrwHu6bUKFu4M0si/uBgUcfsYH/vWbuLUcW1rkEFNhZCdtn0zJo6YewynCkckJQrpd/yIEA/ZQ0odu27TUHDJ+wo9pKiBqdckHdp1AmlCtEkT8MvQJyC42rHN9gPU4Myn9QY5dpGQEJh5hO8Q5pjxNh4onPhYdnDCigbfwir2CXkwFGER15IKPB0RxlGrR6T00ewK0Lfg9HsYqpnX7dtsmLhIoeiRj+cW5ryI3OBHzRgnmVdmmsZF7B15BCGK0R5XPvg2dzNE34MfcDrT3Q8ocdx9fiG4TyNHpEmA6DcD4fHlbcLdfByyPia+KrMuEqewrkMN90VHYxA5ob1FCMMnuEcIun/HI0GDZ47NJ0LfjaGqbBJfYN3Fbqzq+5RI6I10MzOdpltUOiF7QCI+Q57t4ZnCM8RpgsUszjvgdSd0YW/zltJdFh4VgTsUej6IF69RdiXwKAR3axbXvRg7u5a+l/54HQrHfxfJMcjLw3nzEmjI3DRQ2C9smw5mzgKTgOlgirZ85RZIHPdPSPS+asgGXrq+m7QTN0A35DQ5CU3f1vEwCg480/FUrzoe27Kd7XhmVZbNM33OLNy/sLvZwIN0j8CGMl26rpqbq+Ym+M83N7Ny+aqluWpprloa30fYX9LSTLoYaHAmEx4z70lmjnv6lLEDNWRkS5qJj4QPm14bHppRlJlHjsd/WQyXWh9YwMFFAhsaJLj6gKr4IMYZDIfKZngZyZx1JFHGJcyMzGMzRiVneJvBKIWRkJlxVvX0y9pPYrXNe/bxUnHKOWZjpIrMJHW00JJmcNHFlm6822JlK9VMs7mqlY1opmNwVBurrE08sv5YNXg4tiZ8MSP4zgYrL8OwWcsOczRor3va7tZHI7fopS/VRTKGb8LcR1rvaR+VjZNGsTKliNbDBoOeWJ7jo8JqNc32HVa7iJOKy1VmLDfy3rt4aTSmnXhJ5+2ZdGRpMTlZik7qQa26WA1QiLN60IcBLVwmGXhd6u8dzCI45QiVsGF/bjKbcJ14s+YPyzLM3K3dpxR26kAmpNrAMrahYV7lIcBSM0428i9WwayXpYCnGl1MiqUVCIa/TQqwo+ta0u+TUBWdXXhi5ukGkJdSPlBEHMS9E9RlA7GPwf06VEGfHpUwSTcVQd/AoZC2tnnlFuc86YpHMQZnn2OWxTgvtzpFR5ls4aYgjWUwd1ZaIx7o5pXdKDe/KiblL0mVYhj/z1TR+wmMtpd62gMhnEkKjHSm1AMuVMyhCmUxDdsCDmRM7YBogYNFeA1BBSej5rcgx/q3zTnLw6Q1TCjVPo2QoLAfqVgQsgdlyUTfOczK+d5lWbKcke0wJuLKzIrdJceEdXQNXNZ7e4BiCHVTTfIyYHBn48+9zzOoG+km55/a+dhknrc9mOyqlv6CvUilUPQLW0HNu/eZnmpcDt6ysc+51dqKNaXxYvXCW20GBxRwLqkgJkIqQhg0mtYXvNzh+1BbEZya2/YKQVRfs40H0gXSlscuNE72oQ0mzcp2Xnl3e+ltFJyt5p3ueF3I0j/T6c5p7HFz5i7n5OLbu8/5jJ1b2LF1sdP1mBqS9myK6vZo9CFjHGP+PqP4JxS8ewiO3oDD6gFT0h5DP4LjKPjKsMfdkPzWuYZ07Q8AAAD//wMAUEsDBBQABgAIAAAAIQAuG4qk3gIAAPcGAAANAAAAeGwvc3R5bGVzLnhtbKRVbWvbMBD+Pth/EPruynbjLAm2y9LUUOjGIC3sq2LLjqhejKxkzsb+e0+2k7i0e+sIRNLp7rnnXnSOr1op0J6ZhmuV4ODCx4ipXBdcVQl+uM+8GUaNpaqgQiuW4ANr8FX6/l3c2INg6y1jFgGEahK8tbZeENLkWyZpc6FrpuCm1EZSC0dTkaY2jBaNM5KChL4/JZJyhXuEhcz/BkRS87irvVzLmlq+4YLbQ4eFkcwXt5XShm4EUG2DCc1RG0xNiFpzdNJJX/iRPDe60aW9AFyiy5Ln7CXdOZkTmp+RAPltSEFE/PBZ7K15I9KEGLbnrnw4jUutbINyvVM2wSEQdSlYPCr9TWXuCio8aKVx8x3tqQBJgEka51pogyyUDjLXSRSVrNe4poJvDHdqJZVcHHpx6ARdtQc9ySH3Tkgcj57NyE+n3/sx1SbBWRZ2P2dxdrZmlWbo4fZVbwNwtzTggAsxCrcXpDH0hWVGZXCLhv39oYa4FLRwzw+u/qhdGXoIwmhkQDqHabzRpoAnc0y0y2kvSmPBSgvxGF5t3Wp1Df8bbS20VRoXnFZaUeFydLQYNhBOzoRYu2f1tXyG3ZZI7WQm7W2RYHigLrvHLQQybHu8/uDwx2g99gg2BMr/Dova8oT/K+sA+L1O6mSNaF2Lg2vIodU6rsBulIJnCTiFglyfJPizmykC2nuggzY7LixXrwQPmEV7TqfvqmndfOgSffICWS1YSXfC3p8uE3zef2IF30l4UYPWF77XtoNI8Hl/56oeTJ0P1tq7Bt4ArGhneIJ/3Cw/zFc3WejN/OXMm1yyyJtHy5UXTa6Xq1U290P/+udoSv3HjOqGKhQ4mCwaAZPMDMEO5NdnWYJHh55+1+9Ae8x9Hk79j1Hge9mlH3iTKZ15s+ll5GVREK6mk+VNlEUj7tEbZ5lPgqCfio58tLBcMsHVsVbHCo2lUCQ4/iYIcqwEOX+x0icAAAD//wMAUEsDBBQABgAIAAAAIQAbWlnfFwEAABACAAAUAAAAeGwvc2hhcmVkU3RyaW5ncy54bWxkkUFLAzEQhe+C/yHkbrOKFJHdLdJqsbAiovQ87I7d0GRmzWRr++9N0YNkj/k+hsd7KRdH79QBg1imSl/PCq2QWu4s7Sr98f50daeVRKAOHBNW+oSiF/XlRSkSVbolqXQf43BvjLQ9epAZD0jJfHLwENMz7IwMAaGTHjF6Z26KYm48WNKq5ZFiyp1rNZL9GnH5B251XYqty1g3do9qzaFjKk2sS3PGv+oNBw5RVOTcPK9y8spiYyqZ88cjtmO0B8xFAwQ7DDleMsno0iIxNw8i9jzVRGyg3asVf8s0vWGyLagGTtOkDfekVkAWneRZW+ucBa+24Nx+errGtDqqTVoNpo394PiEqF7A/2tt0o/WPwAAAP//AwBQSwMEFAAGAAgAAAAhADttMkvBAAAAQgEAACMAAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0MS54bWwucmVsc4SPwYrCMBRF9wP+Q3h7k9aFDENTNyK4VecDYvraBtuXkPcU/XuzHGXA5eVwz+U2m/s8qRtmDpEs1LoCheRjF2iw8HvaLb9BsTjq3BQJLTyQYdMuvpoDTk5KiceQWBULsYVRJP0Yw37E2bGOCamQPubZSYl5MMn5ixvQrKpqbfJfB7QvTrXvLOR9V4M6PVJZ/uyOfR88bqO/zkjyz4RJOZBgPqJIOchF7fKAYkHrd/aea30OBKZtzMvz9gkAAP//AwBQSwMEFAAGAAgAAAAhALbkMxB6AwAAUA0AACcAAAB4bC9wcmludGVyU2V0dGluZ3MvcHJpbnRlclNldHRpbmdzMS5iaW7sVluPVEUQru/rnj4999kLsAt7ObuAXJS94CqoKLs7C+wSAkR4IMYHSQ4qiYFE11ddSXw3PvJm4g/Qv2B84MGf4D/xYa06ZwYWlkxmcbLRxOpUpk9XV33V1VXVc01W5aack0VZ0NGWB7I3gr8w+qds1tyN7wApy+PqUswEksgdQn8l5xVZ2qPdfrabdXYQ7PdFat998NDO83OrI1EF03FB5Ff/jZdPyvGnZlvu6qkfKqdy7YVozOeRsdi0ezhk2NuJyB/83RAyOMI5zxJDBui86VulIMnOj+jKqKDKGutssOmkYlI65mpMGFk2Q7YCE1LtwKNUUZsJE5foxpgqcnWXooxmqDPqQZW9cikNaZJKPTfYAYA0uvZZQvBbiV+OflmathpTF1P/HJACNxJIq1AyTxCQIMbhMmVIfZDhDOrQiLnqZ+VepoF4hsBA3cwyK9RDuzoaaLoWhzCMEYzyAA/yEMfcOA/zCCc4ySlOM+UMZ3mUx3icr/EET/IUT/N1vIEzmMM8FrCIs3gTS3gLb0NocCEPoZ9VPIuhr3jF88t113BNtDDkhjnCUXQAmQP6CT/pp/x0UEDM4ig6gDiJUzgNBeSZbC6bzxa4E/AczvMdvsv33AW8jw9wEctYwSrbWOOlcJlXuM4NXvXiipR4FjTkl48a8jiYW0UcwoFwMBwKY8l4chhHMIFJTGHaZV2/RO8kzjAOSalzD6LpQM2S2PKxVaSY09xzJWcBkFjkHHQhzoSQhBjKoRKqoRbqoUHRHFPtusYsjmsxFTeWR9IKRdbPS2oTr1zWsaTJ9Lgqcla/jS3JPtfvxe97S8FH2g9+8QKMmb1sZzU11ZSmT9EtNJ87sh9s44p8Kfe1QL/oUX69RInkXYhP+tLXvR+3r39068Mrq+25jXavmn/e3ivqaWW/BI9Q4ssa2isGYb/Utrf/5Q7un3s/KlRbbsh1uSwbsiaXdHZbZyv6xPRL/1R/fZCFtLW19dTv3/LeoE+8Da/cJ63JPflUi/lrLedNfW1v6femjvv69n4mXw3qdhItn7E7VkBaRo9yJ8107a9tGzU80WajrYsqobWHslJvbGt//VARl4GdQ93bbTFfiYXAmu7eafdp8u771JB1np1sgq5Od93+SEG+VYmxUbd9D+r0/9sZRARKxbv9nwrmvr98eT8YUIj+BgAA//8DAFBLAwQUAAYACAAAACEAnUqduWABAAByAgAAEQAIAWRvY1Byb3BzL2NvcmUueG1sIKIEASigAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAfJJJT8MwEIXvSPyHyPfESbrQWkkqKOqJIiTKIm7GnrYR8SLbdOHX4yRtaAXimLw337w3cjbZiSrYgLGlkjlKohgFIJnipVzl6GkxC0cosI5KTislIUd7sGhSXF5kTBOmDDwYpcG4EmzgSdISpnO0dk4TjC1bg6A28g7pxaUygjr/aVZYU/ZBV4DTOB5iAY5y6iiugaHuiOiA5KxD6k9TNQDOMFQgQDqLkyjBP14HRtg/BxrlxClKt9e+0yHuKZuzVuzcO1t2xu12G217TQyfP8Gv87vHpmpYyvpWDFCRcUaYAeqUKa7lCqrgPgqma2XeKf9al7DJ8ImjvmZFrZv7wy9L4Df74oFu/NBzRbny3t+6X9D0abcAD3xC0vY5Ki+96e1ihoo0TkZhPAjT0SIekV5K+sO3ev3ZfJ24/SEOIf4lpv0wTsN0vEiuSH9M0sEJ8Qgomtznr6T4BgAA//8DAFBLAwQUAAYACAAAACEAKQ/1xn0BAAD+AgAAEAAIAWRvY1Byb3BzL2FwcC54bWwgogQBKKAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACckstOwzAQRfdI/EPkPXUKCKHKMUI8xAJEpRZYG2fSWLh25Bmilq9nkoiSAit287i6Pr62utisfdZCQhdDIaaTXGQQbCxdWBXiaXl7dC4yJBNK42OAQmwBxYU+PFDzFBtI5AAztghYiJqomUmJtoa1wQmvA2+qmNaGuE0rGavKWbiO9n0NgeRxnp9J2BCEEsqjZmcoBsdZS/81LaPt+PB5uW0YWKvLpvHOGuJb6gdnU8RYUXazseCVHC8V0y3AvidHW50rOW7VwhoPV2ysK+MRlPweqDswXWhz4xJq1dKsBUsxZeg+OLZjkb0ahA6nEK1JzgRirE42NH3tG6SkX2J6wxqAUEkWDMO+HGvHtTvV017Axb6wMxhAeLGPuHTkAR+ruUn0B/F0TNwzDLwDzqLjG84c8/VX5pN+eN+78IZPzTJeG4Kv7PaHalGbBCXHvct2N1B3HFvynclVbcIKyi/N70X30s/Dd9bTs0l+kvMjjmZKfn9c/QkAAP//AwBQSwECLQAUAAYACAAAACEAQTeCz24BAAAEBQAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQC1VTAj9AAAAEwCAAALAAAAAAAAAAAAAAAAAKcDAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQDK41uktAIAAC4GAAAPAAAAAAAAAAAAAAAAAMwGAAB4bC93b3JrYm9vay54bWxQSwECLQAUAAYACAAAACEAgT6Ul/MAAAC6AgAAGgAAAAAAAAAAAAAAAACtCQAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECLQAUAAYACAAAACEAsVk7jJADAACFCQAAGAAAAAAAAAAAAAAAAADgCwAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAi0AFAAGAAgAAAAhAL2gv71LBwAAHSIAABMAAAAAAAAAAAAAAAAApg8AAHhsL3RoZW1lL3RoZW1lMS54bWxQSwECLQAUAAYACAAAACEALhuKpN4CAAD3BgAADQAAAAAAAAAAAAAAAAAiFwAAeGwvc3R5bGVzLnhtbFBLAQItABQABgAIAAAAIQAbWlnfFwEAABACAAAUAAAAAAAAAAAAAAAAACsaAAB4bC9zaGFyZWRTdHJpbmdzLnhtbFBLAQItABQABgAIAAAAIQA7bTJLwQAAAEIBAAAjAAAAAAAAAAAAAAAAAHQbAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0MS54bWwucmVsc1BLAQItABQABgAIAAAAIQC25DMQegMAAFANAAAnAAAAAAAAAAAAAAAAAHYcAAB4bC9wcmludGVyU2V0dGluZ3MvcHJpbnRlclNldHRpbmdzMS5iaW5QSwECLQAUAAYACAAAACEAnUqduWABAAByAgAAEQAAAAAAAAAAAAAAAAA1IAAAZG9jUHJvcHMvY29yZS54bWxQSwECLQAUAAYACAAAACEAKQ/1xn0BAAD+AgAAEAAAAAAAAAAAAAAAAADMIgAAZG9jUHJvcHMvYXBwLnhtbFBLBQYAAAAADAAMACYDAAB/JQAAAAA="))) ' Add a title shape Dim titleShape = CreateTitleShape("Org Chart Import") page.Items.Add(titleShape) ' Size the page to content page.SizeToContent() End Sub #End Region #Region "Implementation" Private Function CreateTitleShape(title As String) As NShape Dim theme = NDrawingTheme.MyDrawNature Dim titleShape As NShape = New NShape() titleShape.SetBounds(0, -75, 350, 50) titleShape.Text = title Dim titleTextBlock = CType(titleShape.TextBlock, NTextBlock) titleTextBlock.ResizeMode = ENTextBlockResizeMode.ShapeSize titleTextBlock.FontSize = 28 titleTextBlock.FontStyleBold = True ' Set theme-based colors to the title text, so that it changes when the user changes the theme Dim strokeColor = theme.ColorPalette.Variants(0)(0) strokeColor.Tag = New NThemeVariantColorInfo(0) titleTextBlock.Stroke = New NStroke(strokeColor) Dim fillColor = theme.ColorPalette.Variants(0)(4) fillColor.Tag = New NThemeVariantColorInfo(4) titleTextBlock.Fill = New NColorFill(fillColor) ' Alternatively, you can also use fixed colors (uncomment the 2 lines below) 'titleTextBlock.Stroke = new NStroke(NColor.DarkBlue); 'titleTextBlock.Fill = new NColorFill(NColor.LightBlue); ' Set an expression to center the title horizontally in the page titleShape.SetFx(NShape.PinXProperty, New NFormulaFx("$ParentSheet.X + $ParentSheet.Width / 2", True)) Return titleShape End Function #End Region #Region "Event Handlers" #End Region #Region "Fields" Private m_DrawingView As NDrawingView #End Region #Region "Static Methods" #End Region #Region "Constants" #End Region #Region "Nested Types" #End Region End Class

Download a fully functional VB.NET (.vb) Organization Chart (Import from Excel) Example for WPF Solution