Using Grid View for Excel

[Kevin Shay]

I'm trying to find the correct syntax for searching the columns in a Syncfusion Grid. I'm exporting data to Excel with a button click from data in the grid viewer. I'm basically viewing a bunch of data in the Syncfusion equivalent of a data grid viewer for the standard C# VS. Below is the code. It errors on the Columns and Rows section of the code. Perhaps there is an assembly reference I am not seeing but I've added almost all of them and it still doesn't work.

for (int i =1; i < CK_QA_DataGridView.Columns.Count + 1, i++)

{

     ExcelApp.Cells[1, i] = CK_QA_DataGridView.Columns[i - 1].HeaderText;

}

for (int i = 0; i < CK_QA_DataGridview.Rows.Count; i++)

{

    for (int j = 0; j < CK_QA_DataGridview.Columns.Count; j++)

     { 

              ExcelApp.Cells[i + 2, j +1] = CK_QA_DataGridView.Rows[i].Cells[j].Value.ToString();

     }

}

Any help would be appreciated.

[Solai A L]

Hi Kevin,

Thank you for your interest in Syncfusion Products.

In order to achieve your requirement please make use of QueryImportExportCellInfo event of GridExcelConvertercontrol class. Please refer the below code snippet and sample for reference. In this sample , Export button click has been hooked with the event QueryImportExportCellInfo.

CodeSnippet[c#]:

private void Export_Click(object sender, System.EventArgs e)

              {

                     Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl();

 

                     SaveFileDialog saveFileDialog = new SaveFileDialog();

                     saveFileDialog.Filter = "Files(*.xls)|*.xls";

                     saveFileDialog.DefaultExt = ".xls";

            gecc.QueryImportExportCellInfo += gecc_QueryImportExportCellInfo;

                     if(saveFileDialog.ShowDialog() == DialogResult.OK)

                     {

                           gecc.GridToExcel(this.gridDataBoundGrid1.Model, saveFileDialog.FileName,

                                  Syncfusion.GridExcelConverter.ConverterOptions.RowHeaders);           

                           if(MessageBox.Show("Do you wish to open the xls file now?", "Export to Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)

                           {

                                  Process proc = new Process();

                                  proc.StartInfo.FileName = saveFileDialog.FileName;

                                  proc.Start();

                           }

                     }

          

              }

 

        void gecc_QueryImportExportCellInfo(object sender, GridImportExportCellInfoEventArgs e)

        {

            if (e.ColIndex > 0 && e.RowIndex > 0 && (this.gridDataBoundGrid1.Binder.InternalColumns[e.ColIndex-1].HeaderText == "CustomerID"))

            {

                //now the column name with CustomerID has been identified.

 

            }

 

        }

 

Sample:

http://www.syncfusion.com/downloads/support/directtrac/118359/CS-1568472712.zip

Please let us know if you have any other concerns.

 

Thanks & Regards,

AL.Solai.