public virtual void FillData(int x, int y, string field, object value)
{
//if (!field.StartsWith("title_"))
// cell.SetStyle(GetDataStyle());
switch ((value ?? string.Empty).GetType().Name.ToLower())
{
case "int32":
case "int64":
case "decimal":
sheet.Cells[y, x].PutValue(PFDataHelper.ObjectToType <double>(value, 0));
break;
//case "System.String[]":
// var s = String.Join(",", (string[])value);
// sheet.Cells[y, x].PutValue(s);
// break;
default:
if (value is string[])
{
var s = String.Join(",", value as string[]);
sheet.Cells[y, x].PutValue(s);
}
else
{
sheet.Cells[y, x].PutValue(PFDataHelper.ObjectToString(value));
}
break;
}
}
public virtual void FillData(int x, int y, string field, object value)//x列y行
{
FixXY(x, y);
switch ((value ?? string.Empty).GetType().Name.ToLower())
{
case "int32":
case "int64":
case "decimal":
BuildCell(PFDataHelper.ObjectToType <double>(value, 0).ToString());
break;
default:
BuildCell(PFDataHelper.ObjectToString(value) ?? "");
break;
}
//if (y > curRow) {
//}
//if (table.Rows.Count < y+1) {
// for (int i = table.Rows.Count - 1; i < y; i++) {
// if (i < 0) { continue; }
// builder.MoveToCell(0,i,table.Rows[i].Count-1,0);
// builder.EndRow();
// }
//}
//sheet.MoveToCell(y,x);
////if (!field.StartsWith("title_"))
//// cell.SetStyle(GetDataStyle());
//switch ((value ?? string.Empty).GetType().Name.ToLower())
//{
// case "int32":
// case "int64":
// case "decimal":
// sheet.Cells[y, x].PutValue(PFDataHelper.ObjectToType<double>(value, 0));
// break;
// default:
// sheet.Cells[y, x].PutValue(PFDataHelper.ObjectToString(value));
// break;
//}
}
