public static bool AddSharedString(SpreadsheetDocument spreadsheet, string stringItem, bool save = true)
{
SharedStringTable sharedStringTable = spreadsheet.WorkbookPart.SharedStringTablePart.SharedStringTable;
if (0 == sharedStringTable.Where(item => item.InnerText == stringItem).Count())
{
sharedStringTable.AppendChild(new SharedStringItem(new Text(stringItem)));
if (save)
{
sharedStringTable.Save();
}
}
return(true);
}