删除sheet

        /// <summary>
        /// 删除sheet
        /// </summary>
        /// <param name="fileName"></param>
        /// <param name="sheetToDelete"></param>
        /// <returns></returns>
        public static bool XLDeleteSheet(string fileName, string sheetToDelete)
        {
            bool returnValue = false;
            using (SpreadsheetDocument xlDoc = SpreadsheetDocument.Open(fileName, true))
            {
                XmlDocument doc = new XmlDocument();
                doc.Load(xlDoc.WorkbookPart.GetStream());

                XmlNamespaceManager nsManager = new XmlNamespaceManager(doc.NameTable);
                nsManager.AddNamespace("d", doc.DocumentElement.NamespaceURI);

                string searchString = string.Format("//d:sheet[@name='{0}']", sheetToDelete);
                XmlNode node = doc.SelectSingleNode(searchString, nsManager);
                if (node != null)
                {
                    XmlAttribute relationAttribute = node.Attributes["r:id"];
                    if (relationAttribute != null)
                    {
                        string relId = relationAttribute.Value;
                        xlDoc.WorkbookPart.DeletePart(relId);
                        node.ParentNode.RemoveChild(node);
                        doc.Save(xlDoc.WorkbookPart.GetStream(FileMode.Create));
                        returnValue = true;
                    }
                }
            }
            return returnValue;
        }

 

转载于:https://www.cnblogs.com/kingline/p/9356235.html