C#导入、导出Excel的代码.docx

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 / / 导出Excel / / dataGridView控件名 / 路径名 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.Worksheets1 as Worksheet; /sheet.Name = student; /遍历所有的列标题 for (int i = 0; i gridView.ColumnCount; i+) sheet.Cells1, i + 1 = gridView.Columnsi.HeaderText; /循环读取所有的数据 for (int i = 0; i gridView.Rows.Count; i+) for (int j = 0; j gridView.Columns.Count; j+) sheet.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.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(); / / 导入Excel / / dataGridView控件名 / 路径名 public static void ReadingExcel(DataGridView gridView, string fileName) Microsoft.Office.Interop.Excel.Application app = 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); Worksheet 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();/获得每列第一行数据。 if (value = string.Empty)/如果为空则代表已无数据 break; gridView.Columns.Add(, value); /导入每一行的数据 for (int i = 2; ; i+) string value = (sheet.Cellsi, 1 as Range).Text.ToString();/获得每行第一列数据。 if (value = string.Empty)/如果为空则代表已无数据 break; /获得EXCEL中每行上的每列数据 string ID = (sheet.Cellsi, 1 as Range).Text.ToString(); string param1 = (sheet.Cellsi, 2 as Range).Text.ToString(); string param2 = (sheet.Cellsi, 3 as Range).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, param5, param6 ); bo