C# (CSharp) WorkbookPart.GetPartsCountOfType示例

示例#1

        private List <string> GetSharedStringList()
        {
            SharedStringTablePart shareStringPart;

            if (_workbookPart.GetPartsCountOfType <SharedStringTablePart>() > 0)
            {
                shareStringPart = _workbookPart.GetPartsOfType <SharedStringTablePart>().First();
            }
            else
            {
                shareStringPart = _workbookPart.AddNewPart <SharedStringTablePart>();
            }

            if (shareStringPart.SharedStringTable == null)
            {
                shareStringPart.SharedStringTable = new SharedStringTable();
            }

            var items = shareStringPart.SharedStringTable.Elements <SharedStringItem>();

            return(items.Select(x => x.InnerText).ToList());
        }

示例#2

        private static SharedStringTablePart GetSharedStringPart(WorkbookPart workbookPart)
        {
            SharedStringTablePart shareStringPart;

            if (workbookPart.GetPartsCountOfType <SharedStringTablePart>() > 0)
            {
                shareStringPart = workbookPart.GetPartsOfType <SharedStringTablePart>().First();
            }
            else
            {
                return(null);
            }

            if (shareStringPart.SharedStringTable == null)
            {
                shareStringPart.SharedStringTable = new SharedStringTable();
            }

            return(shareStringPart);
        }