[問題] 請教一個datagridview跟excel的問題
如題 我想將datagridview的data存到excel中
我的寫法是
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
Excel.ApplicationClass ExcelApp = new
Excel.ApplicationClass();
ExcelApp.Application.Workbooks.Add(Type.Missing);
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
DataGridViewRow row = dataGridView1.Rows[i];
for (int j = 0; j < row.Cells.Count; j++)
{
ExcelApp.Cells[i + 1, j + 1] = row.Cells[j].ToString();
}
}
ExcelApp.ActiveWorkbook.SaveCopyAs(saveFileDialog1.FileName);
ExcelApp.ActiveWorkbook.Saved = true;
ExcelApp.Quit();
------------------------------------------------------------------------------
(datagridview1是datagridview的name)
但是儲存之後在excel的cell中
出現的卻是DataGridViewTextBoxCell { ColumnIndex=0, RowIndex=0 }
而不是我期望的內容
請問該如何修正?我是用VS2008 謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.20.150.117
→
06/19 12:35, , 1F
06/19 12:35, 1F
→
06/19 12:36, , 2F
06/19 12:36, 2F
→
06/19 12:53, , 3F
06/19 12:53, 3F
→
06/19 12:53, , 4F
06/19 12:53, 4F
推
06/19 13:33, , 5F
06/19 13:33, 5F
→
06/19 13:33, , 6F
06/19 13:33, 6F
→
06/22 10:30, , 7F
06/22 10:30, 7F
討論串 (同標題文章)
以下文章回應了本文:
完整討論串 (本文為第 3 之 4 篇):