怎么遍历DataGrid中的所有行和列,并将数据写入Excel文件中?
时间: 2024-05-02 09:20:00 浏览: 23
可以使用DataGrid控件的Items属性来访问所有行和列,然后使用Excel COM对象将数据写入Excel文件中。以下是一个示例代码:
```C#
private void ExportToExcel(DataGrid dataGrid)
{
// 创建Excel对象
Excel.Application excel = new Excel.Application();
Excel.Workbook workbook = excel.Workbooks.Add();
Excel.Worksheet worksheet = workbook.ActiveSheet;
// 遍历DataGrid中的所有行和列
for (int i = 0; i < dataGrid.Items.Count; i++)
{
for (int j = 0; j < dataGrid.Columns.Count; j++)
{
// 获取单元格的值
DataGridCell cell = GetCell(i, j);
TextBlock tb = cell.Content as TextBlock;
string value = tb.Text;
// 将值写入Excel单元格
worksheet.Cells[i + 1, j + 1] = value;
}
}
// 保存Excel文件
workbook.SaveAs("data.xlsx");
workbook.Close();
excel.Quit();
}
private DataGridCell GetCell(int row, int column)
{
DataGridRow rowContainer = GetRow(row);
if (rowContainer != null)
{
DataGridCellsPresenter presenter = GetVisualChild<DataGridCellsPresenter>(rowContainer);
if (presenter == null)
{
rowContainer.ApplyTemplate();
presenter = GetVisualChild<DataGridCellsPresenter>(rowContainer);
}
if (presenter != null)
{
DataGridCell cell = presenter.ItemContainerGenerator.ContainerFromIndex(column) as DataGridCell;
if (cell == null)
{
dataGrid.ScrollIntoView(rowContainer, dataGrid.Columns[column]);
cell = presenter.ItemContainerGenerator.ContainerFromIndex(column) as DataGridCell;
}
return cell;
}
}
return null;
}
private DataGridRow GetRow(int index)
{
DataGridRow row = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromIndex(index);
if (row == null)
{
dataGrid.UpdateLayout();
dataGrid.ScrollIntoView(dataGrid.Items[index]);
row = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromIndex(index);
}
return row;
}
private T GetVisualChild<T>(Visual parent) where T : Visual
{
T child = default(T);
int numVisuals = VisualTreeHelper.GetChildrenCount(parent);
for (int i = 0; i < numVisuals; i++)
{
Visual visual = (Visual)VisualTreeHelper.GetChild(parent, i);
child = visual as T;
if (child == null)
{
child = GetVisualChild<T>(visual);
}
if (child != null)
{
break;
}
}
return child;
}
```