1、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控件

2、名</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); Works

3、heet sheet = book.Worksheets1 as Worksheet; /sheet.Name = "student" /遍歷所有的列標題 for (int i = 0; i < gridView.ColumnCount; i+) sheet.Cells1, i + 1 = gridView.Columnsi.HeaderText; /循環(huán)讀取所有的數(shù)據(jù) for (int i = 0; i < gridView.Rows.Count; i+) for (int j = 0; j < gridView.Columns.Count; j+) s

4、heet.Cellsi + 2, j + 1 = gridView.Rowsi.Cellsj.Value; /設置禁止彈出保存和覆蓋的詢問提示框 app.DisplayAlerts = false; app.AlertBeforeOverwriting = false; /sheet.SaveAs(Environment.CurrentDirectory + "" + filename + ".xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.

5、Missing, Type.Missing, Type.Missing, Type.Missing); /保存excel文件 sheet.SaveAs(filename, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); book.Close(Type.Missing, Type.Missing, Type.Missing); app.Workbooks.Close(); app.Quit()

6、; / <summary> / 導入Excel / </summary> / <param name="gridView">dataGridView控件名</param> / <param name="filename">路徑名</param> public static void ReadingExcel(DataGridView gridView, string fileName) Microsoft.Office.Interop.Excel.Application app =

7、new Microsoft.Office.Interop.Excel.Application(); Workbook book = app.Workbooks.Open(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); Workshee

8、t sheet = book.Worksheets1 as Worksheet; gridView.Rows.Clear(); gridView.Columns.Clear(); /添加每一列的列標題 for (int i = 1; ; i+) string value = (sheet.Cells1, i as Range).Text.ToString();/獲得每列第一行數(shù)據(jù)。 if (value = string.Empty)/如果為空則代表已無數(shù)據(jù) break; gridView.Columns.Add("", value); /導入每一行的數(shù)據(jù) for (int

9、i = 2; ; i+) string value = (sheet.Cellsi, 1 as Range).Text.ToString();/獲得每行第一列數(shù)據(jù)。 if (value = string.Empty)/如果為空則代表已無數(shù)據(jù) break; /獲得EXCEL中每行上的每列數(shù)據(jù) string ID = (sheet.Cellsi, 1 as Range).Text.ToString(); string param1 = (sheet.Cellsi, 2 as Range).Text.ToString(); string param2 = (sheet.Cellsi, 3 as Ra

10、nge).Text.ToString(); string param3 = (sheet.Cellsi, 4 as Range).Text.ToString(); string param4 = (sheet.Cellsi, 5 as Range).Text.ToString(); string param5 = (sheet.Cellsi, 6 as Range).Text.ToString(); string param6 = (sheet.Cellsi, 7 as Range).Text.ToString(); gridView.Rows.Add(new object ID, param1, param2, param3, param4, par