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; //} }