Well, I'm having a similar situation, but I am using AJAX in UpdatePanel.  Everything is working fine, but when I do a Export(grdResults, oWorkbook), it brings back a blank Excel worksheet.

Is there a way to export the grdResults using the AJAX UpdatePanel at the current state (with all filters, sorting, column moves applied)?

 Hello Nicolas,

This may explain the problem - the grid will need to be binded to data again in the Export button event handler, since after that postback the data populated from the menu event handler will be lost.

I think the easiest solution would be to store the DataSet with data in Cache or Session in the LoadGridmethod and then restore the state from Session/Cache in the event handler called for the Export button (or you can directly call LoadGrid() in the event handler of the export button).

Hi,

No AJAX at all. I just dragged and dropped a webgrid, a button and an excelexporter. nothing else!!!

I have also an infragistics menu that loads the grid passing it a stored procedure like this:
  

 protected void LoadGrid(string storedProcecure)
    {
        mainGrid.DataSource = null;
        SqlConnection connMG = new SqlConnection(ConfigurationManager.AppSettings["connString"]);
        try
        {
            SqlCommand comm = new SqlCommand(storedProcecure, connMG);
            comm.CommandType = CommandType.StoredProcedure;

            DataSet dsMG = new DataSet();
            SqlDataAdapter daMG = new SqlDataAdapter(comm);
            daMG.Fill(dsMG);

            if (dsMG.Tables[0].Rows.Count > 0)
            {
                mainGrid.DataSource = dsMG.Tables[0];
                mainGrid.DataBind();
                //hide the id column
                mainGrid.DisplayLayout.Bands[0].Columns[0].Hidden = true;
                mainGrid.Rows[0].Selected = true;
            }
        }
        catch (Exception ex)
        {
            lblErrorMessage.Text = ex.Message;
        }
    }