wpf文本框数据导出excel
时间: 2023-11-23 11:07:56 浏览: 19
以下是将 WPF 文本框中的数据导出到 Excel 的示例代码:
```csharp
private void ExportToExcel_Click(object sender, RoutedEventArgs e)
{
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
excel.Visible = true;
Microsoft.Office.Interop.Excel.Workbook workbook = excel.Workbooks.Add(System.Reflection.Missing.Value);
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.ActiveSheet;
worksheet.Cells[1, 1] = "Column 1 Header";
worksheet.Cells[1, 2] = "Column 2 Header";
worksheet.Cells[1, 3] = "Column 3 Header";
int rowIndex = 2;
foreach (object item in ListBox1.Items)
{
if (item is MyDataClass)
{
MyDataClass data = item as MyDataClass;
worksheet.Cells[rowIndex, 1] = data.Column1;
worksheet.Cells[rowIndex, 2] = data.Column2;
worksheet.Cells[rowIndex, 3] = data.Column3;
rowIndex++;
}
}
workbook.SaveAs("ExportedData.xlsx", Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook, System.Reflection.Missing.Value,
System.Reflection.Missing.Value, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
Microsoft.Office.Interop.Excel.XlSaveConflictResolution.xlUserResolution, true, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value);
}
```
在这里,我们使用 Microsoft.Office.Interop.Excel 库来创建一个新的 Excel 文件,并将 WPF ListBox 中的数据导出到该文件中。请注意,这只是一个示例,你需要根据你自己的需求进行修改。