Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I assume you know how to export a DataTable to excel(you can use existing libraries like Aspose Cells or using Interop), so I just write the code for creating that DataTable:</p> <pre><code>private DataTable CreateDataTableFromSelectedRows() { var dtToExport = new DataTable(); foreach(DataGridViewRow row in dataGridView1.SelectedRows) { var dr = row.DataBoundItem as DataRow; dtToExport.ImportRow(dr); } return dtToExport; } </code></pre> <p>If you use <a href="http://www.aspose.com/.net/excel-component.aspx" rel="nofollow">Aspose cells</a> it would simply become:</p> <pre><code>private void btnExportSelectedRows(object sender, EventArgs e) { string filePath = "C:\\test.xlsx"; Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(); wb.FileFormat = Aspose.Cells.FileFormatType.Xlsx; Worksheet sheet = wb.Worksheets[0]; DataTable dt = CreateDataTableFromSelectedRows(); sheet.Cells.ImportDataTable(dt, true, "A1"); wb.Save(filePath); } </code></pre> <p>But by using the export code you provide it all become: (I removed existing comments on the code for brevity)</p> <pre><code>private void button1_Click_1(object sender, EventArgs e) { Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing); Microsoft.Office.Interop.Excel._Worksheet worksheet = null; app.Visible = true; worksheet = workbook.Sheets["Sheet1"]; worksheet = workbook.ActiveSheet; worksheet.Name = "Exported from gridview"; for(int i=1;i&lt;dataGridView1.Columns.Count+1;i++) { worksheet.Cells[1, i] = dataGridView1.Columns[i-1].HeaderText; } // It's the part which we are interested in // we just need to change dataGridView1.Rows to dataGridView1.SelectedRows for (int i=0; i &lt; dataGridView1.SelectedRows.Count ; i++) { for(int j=0;j&lt;dataGridView1.Columns.Count;j++) { worksheet.Cells[i + 2, j + 1] = dataGridView1.SelectedRows[i].Cells[j].Value.ToString(); } } workbook.SaveAs("c:\\output.xls",Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive , Type.Missing, Type.Missing, Type.Missing, Type.Missing); app.Quit(); } </code></pre> <p>I guess it would do the trick.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to export only selected rows from datagridview into excel?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USVahidNaderi
    1. USVahidNaderi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to export only selected rows from datagridview into excel?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COcan you also plz provide code for exporting dgv to excel including your above code. Sorry, I'm new to this field.
      singulars
      1. PO
      1. USPravii
    2. COI've code for exporting the dgv into excel, but it will not export the selected rows. If you want that I'll provide you. thank u.
      singulars
      1. PO
      1. USPravii
    3. COI think it saves us time, so please provide that code.
      singulars
      1. PO
      1. USVahidNaderi
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload