這裡提供了兩種將DataGridView內容匯出到Excel檔案的方法。

方法1：

```csharp
/// <summary>
/// 在沒有安裝Excel的情況下，將DataGridView資料匯出到Excel
/// </summary>
private void ExportToExcel()
{
    SaveFileDialog saveFileDialog = new SaveFileDialog();
    saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
    saveFileDialog.FilterIndex = 0;
    saveFileDialog.RestoreDirectory = true;
    saveFileDialog.CreatePrompt = true;
    saveFileDialog.Title = "匯出到Excel";
    saveFileDialog.ShowDialog();
    if (saveFileDialog.FileName == "")
    {
        return;
    }
    Stream myStream = saveFileDialog.OpenFile();
    StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
    string str = "";
    try
    {
        for (int i = 0; i < dataGridView1.ColumnCount; i++)
        {
            if (dataGridView1.Columns[i].Visible == false || dataGridView1.Columns[i].DataPropertyName == "")
            {
                continue;
            }
            str += dataGridView1.Columns[i].HeaderText;
            str += "\t";
        }
        sw.WriteLine(str);

for (int j = 0; j < dataGridView1.Rows.Count - 1; j++)
        {
            string strTemp = "";
            for (int k = 0; k < dataGridView1.Columns.Count; k++)
            {
                if (dataGridView1.Columns[k].Visible == false || dataGridView1.Columns[k].DataPropertyName == "")
                {
                    continue;
                }
                object obj = dataGridView1.Rows[j].Cells[k].Value;

if (obj != null)
                {
                    strTemp += dataGridView1.Rows[j].Cells[k].Value.ToString();
                }
                else
                {
                    strTemp = "";
                }
                strTemp += "\t";
            }
            sw.WriteLine(strTemp);
        }

sw.Close();
        myStream.Close();

MessageBox.Show("成功匯出到Excel檔案：\n" + saveFileDialog.FileName);
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.ToString());
    }
    finally
    {
        sw.Close();
        myStream.Close();
    }
}

```

方法2：

```csharp
/// <summary>
/// 將DataGrirdView資料匯出到Excel
/// 需要引用Microsoft.Office.Interop.Excel.dll模組
/// </summary>
/// <param name="dgv">
/// <param name="bShowExcel">
/// <returns></returns>
private bool DataGridviewShowToExcel(DataGridView dgv, bool bShowExcel)
{
	if (dgv.Rows.Count == 0)
	{
		return false;
	}

//建立Excel物件      
	Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
	excel.Application.Workbooks.Add(true);
	excel.Visible = bShowExcel;

//生成欄位名稱    
	int k = 0;
	for (int i = 0; i < dgv.ColumnCount; i++)
	{
		if (dgv.Columns[i].Visible == false || dataGridView1.Columns[i].DataPropertyName == "")
		{
			k++;
			continue;
		}
		excel.Cells[1, i + 1 - k] = dgv.Columns[i].HeaderText;
	}

//填充資料     
	for (int i = 0; i < dgv.RowCount; i++)
	{
		k = 0;
		for (int j = 0; j < dgv.ColumnCount; j++)
		{
			if (dgv.Columns[j].Visible == false || dataGridView1.Columns[j].DataPropertyName == "")
			{
				k++;
				continue;
			}
			excel.Cells[i + 2, j + 1 - k] = dgv[j, i].Value.ToString();
		}
	}
	return true;
}

```

將dataGridView內容匯出到Excel檔案

相關文章