/// <summary>
        /// Change the currently active document.
        /// </summary>
        internal void ChangeCurrentDocument()
        {
            Debug.WriteLine("Changing event document to " + Globals.ThisAddIn.Application.ActiveDocument.Name);

            //unhook existing events
            m_wddoc.ContentControlOnEnter  -= (Word.DocumentEvents2_ContentControlOnEnterEventHandler)m_alDocumentEvents[0];
            m_wddoc.ContentControlAfterAdd -= (Word.DocumentEvents2_ContentControlAfterAddEventHandler)m_alDocumentEvents[1];
            m_parts.PartAfterAdd           -= (Office._CustomXMLPartsEvents_PartAfterAddEventHandler)m_alPartsEvents[0];
            m_parts.PartBeforeDelete       -= (Office._CustomXMLPartsEvents_PartBeforeDeleteEventHandler)m_alPartsEvents[1];
            m_parts.PartAfterLoad          -= (Office._CustomXMLPartsEvents_PartAfterLoadEventHandler)m_alPartsEvents[2];
            m_currentPart.NodeAfterDelete  -= (Office._CustomXMLPartEvents_NodeAfterDeleteEventHandler)m_alPartEvents[0];
            m_currentPart.NodeAfterInsert  -= (Office._CustomXMLPartEvents_NodeAfterInsertEventHandler)m_alPartEvents[1];
            m_currentPart.NodeAfterReplace -= (Office._CustomXMLPartEvents_NodeAfterReplaceEventHandler)m_alPartEvents[2];

            //release the streams + stream handler references
            m_alDocumentEvents.Clear();
            m_alPartsEvents.Clear();
            m_alPartEvents.Clear();

            //clean up the m_wddoc object (since otherwise the RCW gets disposed out from under it)
            m_wddoc = null;
            GC.WaitForPendingFinalizers();
            GC.Collect();
            GC.WaitForPendingFinalizers();
            GC.Collect();

            //hook up new objects
            m_wddoc       = Globals.ThisAddIn.Application.ActiveDocument;
            m_parts       = m_wddoc.CustomXMLParts;
            m_currentPart = m_parts[1];

            SetupEventHandlers();
        }
        public DocumentEvents(Controls.ControlMain cm)
        {
            //get the initial part
            m_cmTaskPane  = cm;
            m_wddoc       = Globals.ThisAddIn.Application.ActiveDocument;
            m_parts       = m_wddoc.CustomXMLParts;
            m_currentPart = cm.model.getUserPart(System.Configuration.ConfigurationManager.AppSettings["RootElement"]);

            //hook up event handlers
            SetupEventHandlers();
        }
        public DocumentEvents(Controls.ControlMain cm)
        {
            //get the initial part
            m_cmTaskPane  = cm;
            m_wddoc       = Globals.ThisAddIn.Application.ActiveDocument;
            m_parts       = m_wddoc.CustomXMLParts;
            m_currentPart = m_parts[1];

            //hook up event handlers
            SetupEventHandlers();
        }
示例#4
0
        public static void UpdateCustomXmlNode(Excel.Workbook workbook, string namespaceName, string xmlString, string xPath)
        {
            Office.CustomXMLParts ps = workbook.CustomXMLParts.SelectByNamespace(namespaceName);

            foreach (Office.CustomXMLPart p in ps)
            {
                var nsmgr = p.NamespaceManager;
                nsmgr.AddNamespace("x", namespaceName);

                Office.CustomXMLNode oldNode = p.SelectSingleNode(xPath);
                oldNode.ParentNode.ReplaceChildSubtree(xmlString, oldNode);
            }
        }
示例#5
0
        private string GetNovenaReportingWorkbookPropertiesXML(Excel.Workbook Wb)
        {
            Office.CustomXMLParts allXMLParts = Wb.CustomXMLParts;
            foreach (Office.CustomXMLPart part in allXMLParts)
            {
                if (part.DocumentElement.BaseName == "WorkbookProperties")
                {
                    return(part.XML);
                }
            }

            return(null);
        }
示例#6
0
        public static List <string> ListXmlNamespaces(Excel.Workbook workbook)
        {
            var result = new List <string>();

            Office.CustomXMLParts ps = workbook.CustomXMLParts;
            for (int i = 1; i <= workbook.CustomXMLParts.Count; i++)
            {
                Office.CustomXMLPart p = ps[i];

                //p.BuiltIn will be true for internal buildin excel parts
                if (p != null && !p.BuiltIn)
                {
                    result.Add(p.NamespaceURI);
                }
            }

            return(result);
        }
示例#7
0
        public static Office.CustomXMLNode GetCustomXmlNode(Excel.Workbook workbook, string xNameSpace,
                                                            string xPath)
        {
            Office.CustomXMLParts ps = workbook.CustomXMLParts;
            ps = ps.SelectByNamespace(xNameSpace);


            for (int i = 1; i <= ps.Count; i++)
            {
                Office.CustomXMLPart p = ps[i];
                var nsmgr = p.NamespaceManager;
                nsmgr.AddNamespace("x", xNameSpace);

                Office.CustomXMLNode node = p.SelectSingleNode(xPath);
                if (node != null)
                {
                    return(node);
                }
            }
            return(null);
        }
        internal void ConnectCurrent()
        {
            //hook up new objects
            m_wddoc = Globals.ThisAddIn.Application.ActiveDocument;
            m_parts = m_wddoc.CustomXMLParts;
            //m_currentPart = m_parts[1];  // bad that this is done here as well!

            m_cmTaskPane.model = OpenDoPEModel.Model.ModelFactory(m_wddoc);

            m_cmTaskPane.formPartList.Dispose();
            m_cmTaskPane.formPartList = new Forms.FormSwitchSelectedPart();
            m_cmTaskPane.formPartList.controlPartList.controlMain = m_cmTaskPane;

            if (m_cmTaskPane.model.userParts.Count == 0)
            {
                log.Error("No users part found! This shouldn't happen!");
            }
            m_currentPart = m_cmTaskPane.model.userParts[0];


            SetupEventHandlers();
        }
        public static T GetCustomXmlByNamespace <T>(Excel.Workbook workbook, string namespaceStr) where T : class, new()
        {
            if (null == workbook)
            {
                throw new ArgumentNullException("workbook");
            }

            if (string.IsNullOrWhiteSpace(namespaceStr))
            {
                throw new ArgumentNullException("namespaceStr");
            }

            Office.CustomXMLParts parts = workbook.CustomXMLParts.SelectByNamespace(namespaceStr);

            if (0 == parts.Count)
            {
                return(new T());
            }

            Office.CustomXMLNode node = parts[1].DocumentElement.FirstChild;
            string json = node.NodeValue.Trim();

            return(JsonConvert.DeserializeObject <T>(json));
        }
        internal void ConnectCurrent()
        {
            //hook up new objects
            m_wddoc = Globals.ThisAddIn.Application.ActiveDocument;
            m_parts = m_wddoc.CustomXMLParts;
            //m_currentPart = m_parts[1];  // bad that this is done here as well!

            m_cmTaskPane.model = OpenDoPEModel.Model.ModelFactory(m_wddoc);

            m_cmTaskPane.formPartList.Dispose();
            m_cmTaskPane.formPartList = new Forms.FormSwitchSelectedPart();
            m_cmTaskPane.formPartList.controlPartList.controlMain = m_cmTaskPane;

            if (m_cmTaskPane.model.userParts.Count == 0)
            {
                log.Error("No users part found! This shouldn't happen!");
            }
            m_currentPart = m_cmTaskPane.model.userParts[0];

            SetupEventHandlers();
        }
        public DocumentEvents(Controls.ControlMain cm)
        {
            //get the initial part
            m_cmTaskPane = cm;
            m_wddoc = Globals.ThisAddIn.Application.ActiveDocument;
            m_parts = m_wddoc.CustomXMLParts;
            m_currentPart = cm.model.getUserPart(System.Configuration.ConfigurationManager.AppSettings["RootElement"]);

            //hook up event handlers
            SetupEventHandlers();
        }
示例#12
0
 public static int CountXmlNamespace(Excel.Workbook workbook, string xNameSpace)
 {
     Office.CustomXMLParts ps = workbook.CustomXMLParts;
     ps = ps.SelectByNamespace(xNameSpace);
     return(ps.Count);
 }