public StringKey(string key) { Value = new Excel.SharedStringItem { Text = new Excel.Text(key) }; Key = key; }
private string GetCellValue(WorkbookPart workbook, OpenXmlReader reader) { OpenXML.Cell c = (OpenXML.Cell)reader.LoadCurrentElement(); if (c.DataType != null && c.DataType == OpenXML.CellValues.SharedString) { OpenXML.SharedStringItem ssi = workbook.SharedStringTablePart. SharedStringTable.Elements <OpenXML.SharedStringItem>().ElementAt (int.Parse(c.CellValue.InnerText)); return(ssi.Text.Text); } else { return(c.CellValue.InnerText); } }
public StringKey(Excel.SharedStringItem item) { Value = item; Key = item.InnerText; }