Exporting XAMgrid to excell | Infragistics Forums

Thanks Rumen, you helped point me in the right direction. This isn't eloquent or anything but it works.

All changes below are to the blog's XamDataGridExcelExporter.cs file.

I added a dictionary member to the class.
private readonly Dictionary<int, ComboBoxItemsProvider> comboEditors = new Dictionary<int, ComboBoxItemsProvider>();

I added a new method to fill the dictionary, Making the call to this method as the first line in the public export methods:

    /// <summary>
    /// Identifies the combo editors and saves their data source to the dictionary.
    /// </summary>
    /// <param name="xamDataGrid">The xam data grid.</param>
    private void IdentifyComboEditors(DataPresenterBase xamDataGrid)
    {
      foreach (var fieldLayout in xamDataGrid.FieldLayouts)
      {
        foreach (var field in fieldLayout.Fields)
        {
          if (field == null || field.Settings == null || field.Settings.EditorStyle == null || field.Settings.EditorStyle.TargetType == null) continue;
 
          if (field.Settings.EditorStyle.TargetType != typeof (XamComboEditor)) continue;
 
          ComboBoxItemsProvider statusProvider = ((System.Windows.Setter)field.Settings.EditorStyle.Setters[0]).Value as ComboBoxItemsProvider;
          comboEditors.Add(field.Index, statusProvider);
        }
      }
    }

Added this new code to the MakeWorkSheetRow method: (if(comboEditors.ContainsKey(i)) is the first if I added)

      //Fill the Worksheet Cells with the values from the DataRecord Cells Subtracting 1 for the Relation 
      //_column if it is a normal DataRecord
      if (record != null)
        if (record.GetType() == typeof(DataRecord) && dataRecord != null)
        {
          for (int i = 0; i < dataRecord.Cells.Count; i++)
          {
            if (dataRecord.Cells[i].Field.IsExpandableResolved != true)
            {
              if(comboEditors.ContainsKey(i))
              {
                foreach (var item in comboEditors[i].Items)
                {
                  Type classType = item.GetType();
 
                  PropertyInfo valueProperty = classType.GetProperty(comboEditors[i].ValuePath);
 
                  int itemValue;
                  int dataValue;
 
                  if (!int.TryParse(valueProperty.GetValue(item, null).ToString(), out itemValue) || dataRecord.Cells[i].Value == null || !int.TryParse(dataRecord.Cells[i].Value.ToString(), out dataValue))
                    continue;
 
                  if (itemValue != dataValue) continue;
 
                  PropertyInfo displayTextProperty = classType.GetProperty(comboEditors[i].DisplayMemberPath);
 
                  excelWorkSheetRow.Cells[i + level].Value = displayTextProperty.GetValue(item, null);
                  break;
                }
              }
              else
              {
                excelWorkSheetRow.Cells[i + level].Value = dataRecord.Cells[i].Value;
              }
            }
          }
        }

I hope this make sense and helps people! I'm sure I could clean the code up a bit, but it's time to go home and the code is working. :)