public static void SetValue(Cell cell, string text, SharedStringTableWithIndex sharedStringTable)
{
var index = sharedStringTable.SetSharedString(text == null ? "" : text);
cell.CellValue = new CellValue(index.ToString());
cell.DataType = new EnumValue <CellValues>(CellValues.SharedString);
}
public SeedTable(string sheetName, Sheet sheet, Worksheet worksheet, SharedStringTableWithIndex sharedStringTable, int columnNamesRowIndex = 2, int dataStartRowIndex = 3, IEnumerable <string> ignoreColumnNames = null, string keyColumnName = "id", string versionColumnName = null) : base(columnNamesRowIndex, dataStartRowIndex, ignoreColumnNames, keyColumnName, versionColumnName)
{
SheetName = sheetName;
Sheet = sheet;
Worksheet = worksheet;
SharedStringTable = sharedStringTable;
GetColumns();
}
public static string ValueString(Cell cell, SharedStringTableWithIndex sharedStringTable)
{
if (cell == null)
{
return(null);
}
// 数式
if (cell.CellFormula != null)
{
//Console.WriteLine("FORMULA: "+cell.CellFormula.Text+" -> "+ cell.CellValue.Text);
return(cell.CellValue.Text);
}
// SharedString以外
if (cell.DataType == null || cell.DataType != CellValues.SharedString || sharedStringTable == null)
{
return(cell.InnerText);
}
// SharedString
return(sharedStringTable.SharedString(int.Parse(cell.InnerText)));
}
public static object Value(Cell cell, SharedStringTableWithIndex sharedStringTable)
{
if (cell == null || cell.CellValue == null)
{
return(null);
}
else if (cell.DataType == null)
{
return(cell.CellValue.InnerText);
}
else
{
string text = cell.CellFormula == null ? cell.CellValue.InnerText : cell.CellValue.Text;
switch (cell.DataType.Value)
{
case CellValues.InlineString:
return(text);
case CellValues.SharedString:
return(sharedStringTable.SharedString(int.Parse(text)));
case CellValues.String:
return(text);
case CellValues.Boolean:
return(text.Trim() != "0");
case CellValues.Date:
return(DateTime.Parse(text));
case CellValues.Error:
return(new Exception(text));
case CellValues.Number:
return(double.Parse(text));
default:
return(null);
}
}
}
public ExcelData(SpreadsheetDocument document)
{
Document = document;
Sheets = WorkbookPart.Workbook.Descendants <Sheet>();
SharedStringTable = new SharedStringTableWithIndex(WorkbookPart.SharedStringTablePart.SharedStringTable, WorkbookPart);
}
public SeedTableCell(Cell cell, SharedStringTableWithIndex sharedStringTable)
{
Cell = cell;
SharedStringTable = sharedStringTable;
}
public SeedTableRow(Row row, SharedStringTableWithIndex sharedStringTable)
{
Row = row;
SharedStringTable = sharedStringTable;
}
