Exporting range to datatable & Customizing FillSeries Event

[Travis Chambers]

Good day,

I am looking to select a range of cells and export that range to a datatable (much like the spreadsheet control can do). Is there a function to do this? I see nothing in the documentation about the subject.

Also, I would like to customize the fill series event slightly by having the cells highlight with a certain color when a series is filled. Is it possible to customize this event?

[Sindhu Nagarajan]

Hi Travis, 

Thanks for contacting Syncfusion support. 

Query	Response
To select a range of cells and export that range to a datatable	Inorder to export the selected range of cells to excel, SelectedExport() method is used. Please refer to the below code,    Code Example  GridExcelConverterControl ExcelAdv = new GridExcelConverterControl();  SaveFileDialog saveFileDialog = new SaveFileDialog();  saveFileDialog.Filter = "Files(*.xlsx)|*.xlsx|Files(*.xls)|*.xls";  saveFileDialog.DefaultExt = ".xlsx";    if (saveFileDialog.ShowDialog() == DialogResult.OK)  {      ExcelAdv.SelectedExport(this.gridControl1.Model, saveFileDialog.FileName, ConverterOptions.Default);  }    Please refer to the dashboard sample that is available in your local machine from the below location,    Sample Location: <Installed Location>\Syncfusion\EssentialStudio\<Installed version>\Windows\Grid.Windows\Samples\Exporting\Exporting Demo\CS    Please refer to the below UG link to know about exporting selected range of cells to excel,  UG Link: https://help.syncfusion.com/windowsforms/grid/exporting#exporting-the-selected-ranges
To customize the fill series event slightly by having the cells highlight with a certain color when a series is filled.	As per our current  support, there is no event to customize the selected cells  after FillSeries is applied to the Gridcells. However, you can set the back color of the selected  range of cells before the FillSeries is applied, by handling MouseUp event. Please make use of the below code and sample,  Code Example  private void GridControl1_MouseUp(object sender, MouseEventArgs e)  {       int row, col;      gridControl1.PointToRowCol(new Point(e.X, e.Y), out row, out col);       GridRangeInfo r = gridControl1.Selections.Ranges.ActiveRange;       if (r.Bottom != row && r.Right != col)       {           int top = r.Top; int right = r.Right;           for (int i = top; i <= row; i++)           {               for (int j = right; j <= col; j++)               {                   gridControl1[i, j].BackColor = Color.Red;               }           }       }

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/F1369561925650196 

Please let us know if you have any other queries. 

Regards, 

Sindhu  

[Travis Chambers]

Thank you, however, I am not interested in exporting the grid to Excel, but importing the selected range to a dataTable so I can then import it into another business object, such as another girdcontrol, chart, etc. The spreadsheet control has a build in method for this and I would like to do the same in the gridcontrol if possible.

[Sindhu Nagarajan]

Hi Travis, 

 

Thanks for the update. 

 

 

GridControl does not have any direct function to export selected data in the grid to datatable like exporting the data to excelsheet. However, the selected range of values can be retrieved by iterating. The selected range is obtained by using SelectedRanges.ActiveRange property.  The values thus obtained are exported to the datatable. We have prepared the sample as per your requirement. Please refer to the below code and sample, 

 

Code Example 

  private void button1_Click(object sender, EventArgs e) 

  { 

      var range = this.gridControl1.Model.SelectedRanges.ActiveRange; 

      int col = range.Right - range.Left + 1; 

      int row = range.Bottom - range.Top + 1; 

      int top = range.Top; 

      int left = range.Left; 

      int Bottom = range.Bottom; 

      int right = range.Right; 

 

      int l = left; 

      int t = top; 

      DataTable dt = new DataTable(); 

      for (int c = 0; c < col; c++) 

      { 

          string colName = gridControl1.Model[0, l].Text; 

          l++; 

          dt.Columns.Add(colName); 

      } 

      l = left; 

      for (int i = 0; i < row; i++) 

      { 

          DataRow dr = dt.NewRow(); 

          for (int j = 0; j < col; j++) 

          { 

              dr[j] = this.gridControl1.Model[t, l].Text; 

              l++; 

          } 

          dt.Rows.Add(dr); 

          t++; 

          l = left; 

      } 

      gridControl1.RowCount = dt.Rows.Count; 

      gridControl1.ColCount = dt.Columns.Count;             

  } 

 

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/GridControlSample1692539947 

 

Please let us know if you have any other queries. 

 

 

Regards, 

Sindhu