C# 导出EXCEL 和 导入

使用winfrom简单做个界面

选择导出路径 + XLSX起名字

打开导出是XLSX文件

// 创建Excel应用程序对象Excel.Application excelApp = new Excel.Application();excelApp.Visible = false;// 创建工作簿Excel.Workbook workbook = excelApp.Workbooks.Add(Type.Missing);Excel.Worksheet worksheet = (Excel.Worksheet)workbook.ActiveSheet;// 填充数据DataTable dt = GetDataTable(); // 获取数据源for (int i = 0; i < dt.Rows.Count; i++){for (int j = 0; j < dt.Columns.Count; j++){worksheet.Cells[i + 1, j + 1] = dt.Rows[i][j].ToString();}}// 保存Excel文件SaveFileDialog saveFileDialog = new SaveFileDialog();saveFileDialog.Filter = "Excel文件|*.xlsx";saveFileDialog.Title = "保存Excel文件";if (saveFileDialog.ShowDialog() == DialogResult.OK){workbook.SaveAs(saveFileDialog.FileName);MessageBox.Show("导出成功！");}// 关闭Excel应用程序excelApp.Quit();System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);