i am trying to insert an array of object into excel as bulk.
This is my object class (called "DailyValues"):
- Code: Select all
public string ColumnName { get; set; }
public string Accounts { get; set; }
public string AccountNumber { get; set; }
public double Amount { get; set; }
public Boolean IsExist { get; set; }
This is how i use the function:
- Code: Select all
TargetPivotData.InsertArray(DailyUsage.Where(x => x != null).ToArray(), 1, 1,True);
This is the result (in the excel):
ApplicationName.DailyValues Account Number Attribute Value
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
ApplicationName.DailyValues
Thanks