I'm using the Workbook class in a manual way.

I used Excel's COM interop to export excel before, and it has the api to autofit the column.

I can't find this feature in ultra's class library, maybe i've missed something however this is a quite useful feature to be added to your product.

Hi, is there any news about this feature?

Has it been included in recent releases?

No, this has not yet been implemented. You should also submit a feature request because the number of requests is considered when determining what should be implemented in each release.

Wrote this method to autosize the columns.  Someone else can probably write it a bit more elegantly than I did, but it works great.

/// <summary>
/// Autosize the columns using their text as a measuring guide
/// </summary>
/// <param name="book">Excel book</param>
public static void AutoSizeColumns(Workbook book)
{
     Dictionary<int, int> colWidths = new Dictionary<int, int>();

     foreach (var wksheet in book.Worksheets)
     {
          foreach (var row in wksheet.Rows)
          {
               foreach (var cell in row.Cells)
               {
                    object value = cell.Value;
                    if (!colWidths.ContainsKey(cell.ColumnIndex))
                         colWidths.Add(cell.ColumnIndex, value.ToString().Length);
                    else if (value.ToString().Length > colWidths[cell.ColumnIndex])
                         colWidths[cell.ColumnIndex] = value.ToString().Length;
               }
          }

          foreach (var colIndex in colWidths.Keys)
          {
               wksheet.Columns[colIndex].Width = colWidths[colIndex] * 256;
          }
     }
}

Hello all,

Could you please try out the following code and see if it meets your requirements:

  private void ultraGridExcelExporter1_BeginExport(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.BeginExportEventArgs e)
  {
      e.Layout.PerformAutoResizeColumns(true, Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand,                        Infragistics.Win.UltraWinGrid.AutoResizeColumnWidthOptions.All);

  }

Thanks for this recommendation.  The problem with this block of code is that we are not using the UltraGridExcelExporter, but using the Infragistics Excel interops to write directly to an excel file.  There is no "BeginExport" event to tie this code to.

Big thanks to miker55!  I dropped this method into my solution and BAM! worked like a charm.

Thanks a ton!

Miker55,

Thanks for your contribution.  I am using your latest revision and it seems to work fine.  I'm using the InfragisticsWPF4.Excel.v10.3 library and it doesn't have a SetWidth method.  I'm using this instead and it seems to work OK.

wksheet.Columns[colIndex].Width = colWidths[colIndex] * 256;

instead of

wksheet.Columns[colIndex].SetWidth(colWidths[colIndex] + 2, WorksheetColumnWidthUnit.Character);

Upon testing, the widths were either WAY too big or just a tiny bit too small.  So, I changed it to use the SetWidth() method and used the WorksheetColumnWidthUnit.Character since I knew the specific number of characters.  I was also able to track down the too big problem to being that spaces take up a LOT smaller space than any other charcter so I cut the number of characters for spaces in half.  And finally since Excel changes the width down by fractions of characters most likely for the grid lines and padding, I decided to just add 2 more to the final width to compensate.  Here is the revised method with comments:

/// <summary>
/// Autosize the columns using their text as a measuring guide
/// </summary>
/// <param name="book">Excel book</param>
/// <param name="sheet">Excel sheet</param>
public static void AutoSizeColumns(Workbook book, Worksheet sheet)
{
     Dictionary<int, int> colWidths = new Dictionary<int, int>();

     using (Graphics g = Graphics.FromHwnd(IntPtr.Zero))
     {
          // loops through all worksheets in the workbook
          foreach (var wksheet in book.Worksheets)
          {
               //
               if (sheet == null || (book.Worksheets.Contains(sheet) && wksheet == sheet))
               {
                    // couldn't guarantee that the worksheet had columns every time
                    // so had to loop through rows and cells instead to find the correct width
                    foreach (var row in wksheet.Rows)
                    {
                         foreach (var cell in row.Cells)
                         {
                              // get width of cell value
                              string value = cell.Value.ToString();

                              // width w/o spaces is initially retrieved
                              int width = value.Replace(" ", "").Length;

                              // reduces width to compensate for small size of spaces
                              width += (value.Length - width) / 2;

                              // add width to collection for later reference
                              if (!colWidths.ContainsKey(cell.ColumnIndex))
                                   colWidths.Add(cell.ColumnIndex, width);
                              else if (value.ToString().Length > colWidths[cell.ColumnIndex])
                                   colWidths[cell.ColumnIndex] = width;
                         }
                    }
               }
               // loops through the new column widths and set each column to the new widths
               foreach (var colIndex in colWidths.Keys)
               {
                    wksheet.Columns[colIndex].SetWidth(colWidths[colIndex] + 2, WorksheetColumnWidthUnit.Character);
               }
          }
     }
}