Good Night,
I'm trying to export the grid for excel or pdf with the filters, like the example https://www.syncfusion.com/forums/119826/export-filtered-grid-to-excel, but i'm getting the error: System.InvalidCastException: 'Unable to cast object of type 'System.Object' to type 'System.Collections.IEnumerable'.' at strong and sub line:
My code:
public void ExportToPdf(string GridModel)
{
PdfExport exp = new PdfExport();
var DataSource = new DB_DBEntities().vPerfil.ToList();
GridProperties obj = (GridProperties)ConvertGridObject(GridModel);
exp.Export(obj, (IEnumerable)obj.DataSource, "Export.pdf", false, false, "flat-saffron"); }
private GridProperties ConvertGridObject(string gridProperty)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
IEnumerable div = (IEnumerable)serializer.Deserialize(gridProperty, typeof(IEnumerable));
GridProperties gridProp = new GridProperties();
foreach (KeyValuePair<string, object> ds in div)
{
var property = gridProp.GetType().GetProperty(ds.Key, BindingFlags.Instance | BindingFlags.Public | BindingFlags.IgnoreCase);
if (property != null)
{
Type type = property.PropertyType;
string serialize = serializer.Serialize(ds.Value);
if (ds.Key == "dataSource")
{
List<vPerfil> value1 = serializer.Deserialize<List<vPerfil>>(serialize);
property.SetValue(gridProp, value1, null);
continue;
}
object value = serializer.Deserialize(serialize, type);
property.SetValue(gridProp, value, null);
}
}
return gridProp;
}
Thanks,
Fillipe
