第4章电路探秘思维导图目录using System;using System.Collections.Generic; using System.Linq;using System.Text;using System.Windows.Forms;using Microsoft.Office.Interop.Excel;namespace ExcelTools{public class ReadingAndwriting{///<summary>///导出Excel///</summary>///<param name="gridView">dataGridView控件名</param>///<param name="filename">路径名</param>public static void WritingExcel(DataGridView gridView, string filename){Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();Workbook book = app.Workbooks.Add(Type.Missing);Worksheet sheet = book.Worksheets[1] as Worksheet;// = "student";//遍历所有的列标题for (int i = 0; i < gridView.ColumnCount; i++){sheet.Cells[1, i + 1] = gridView.Columns[i].HeaderText;}//循环读取所有的数据for (int i = 0; i < gridView.Rows.Count; i++){for (int j = 0; j < gridView.Columns.Count; j++){sheet.Cells[i + 2, j + 1] = gridView.Rows[i].Cells[j].Value;}}//设置禁止弹出保存和覆盖的询问提示框app.DisplayAlerts = false;app.AlertBeforeOverwriting = false;//sheet.SaveAs(Environment.CurrentDirectory + "\\" + filename + ".xls",。
