public override Task <Empty> SetCellValue(CellAddressWithValue addrv, ServerCallContext context)
=> Task.Factory.StartNew(() =>
{
_logger.LogDebug("SetCellValue(row:{0}, col:{1})", addrv.Row, addrv.Col, addrv.Value.Inspect());
GetOrCreateWrapper(context).SetCellValue(addrv);
return(new Empty());
});
public void SetCellValue(CellAddressWithValue addrv)
{
var cell = sheet.GetCell(addrv.Row, addrv.Col);
switch (addrv.Value.ValueType)
{
case CellValueTypes.Numeric:
cell.SetCellValue(addrv.Value.NumericValue);
break;
case CellValueTypes.String:
cell.SetCellValue(addrv.Value.StringValue);
break;
case CellValueTypes.Boolean:
cell.SetCellValue(addrv.Value.BoolValue);
break;
case CellValueTypes.DateTime:
cell.SetCellValue(DateUtil.GetExcelDate(new DateTime(addrv.Value.DateTimeValue.Seconds)));
break;
case CellValueTypes.Blank:
cell.SetCellType(CellType.Blank);
break;
case CellValueTypes.Error:
cell.SetCellValue(addrv.Value.ErrorValue);
cell.SetCellType(CellType.Error);
break;
}
}
