bryian,

Formula support was added to the Infragistics Excel engine in NetAdvantage for .NET 2007 Volume 3.  If you are using an earlier version of the toolset, then this method wouldn't exist.

I would like to know how you get the "ApplyFormula" to work, I kept getting

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 'Infragistics.Excel.Workbook' does not contain a definition ApplyFormula !

When you set-up your WebGrid columns (for example at design-time), it helps to set the column.Type to Infragistics.WebUI.UltraWebGrid.ColumnType.HyperLink so you can easily identify column(s) containing the hyperlinks.  Then you can do this,

protected void Page_Load( object sender, EventArgs e)
{
     // Handle the CellExported event on the exporter.
     this.UltraWebGridExcelExporter1.CellExported += new
          Infragistics.WebUI.UltraWebGrid.ExcelExport.CellExportedEventHandler(
               UltraWebGridExcelExporter1_CellExported);
}

void UltraWebGridExcelExporter1_CellExported( object sender,
     Infragistics.WebUI.UltraWebGrid.ExcelExport.CellExportedEventArgs e)
{
     if (e.GridColumn.Type == Infragistics.WebUI.UltraWebGrid.ColumnType.HyperLink)
     {
          // When cells in a Hyperlink-type column are exported,
          // apply the =HYPERLINK formula to their string value.
          e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[
               e.CurrentColumnIndex].ApplyFormula(
                    string.Format("=HYPERLINK(\"{0}\")", e.Value.ToString( )
               )
           );
     }
}

protected void btnExportToExcel_Click( object sender, EventArgs e)
{
     this.UltraWebGridExcelExporter1.Export( this.UltraWebGrid1);
}

Hi Mike,

  Thanks for the response. I am using UltraWebGridExcelExporter to export to excel.

How do I use formula on that?

Can you please explain to me?

Thanks,

Saravanan

Hyperlink style cells are not currently supported by the Excel library, so the grid exporters cannot export hyperlinks. However, you can manually convert the cell value to a hyperlink after the cell has been exported by applying a formula like this: =HYPERLINK(<hyperlink>). You can do this with the ApplyFormula method on the WorksheetCell instance.