C# 快捷读取Excel。

using System;

using System.Data;

using System.Configuration;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using Microsoft.Office.Interop.Excel;

using System.Diagnostics;

using System.Collections.Generic;

namespace MMSSend

{

    public class ExcelHelper

    {

        private _Application excelApp;

        private string fileName = string.Empty;

        private WorkbookClass wbclass;

        public ExcelHelper(string _filename)

        {

            excelApp = new Application();

            object objOpt = System.Reflection.Missing.Value;

            wbclass = (WorkbookClass)excelApp.Workbooks.Open(_filename, objOpt, false, objOpt, objOpt, objOpt, true, objOpt, objOpt, true, objOpt, objOpt, objOpt, objOpt, objOpt);

        }

        /// <summary>

        /// 所有sheet的名称列表

        /// </summary>

        /// <returns></returns>

        public List<string> GetSheetNames()

        {

            List<string> list = new List<string>();

            Sheets sheets = wbclass.Worksheets;

            string sheetNams = string.Empty;

            foreach (Worksheet sheet in sheets)

            {

                list.Add(sheet.Name);

            }

            return list;

        }

        /// <summary>

        /// 通过文件名获取表格

        /// </summary>

        /// <param name="name">文件名</param>

        /// <returns></returns>

        public Worksheet GetWorksheetByName(string name)

        {

            Worksheet sheet = null;

            Sheets sheets = wbclass.Worksheets;

            foreach (Worksheet s in sheets)

            {

                if (s.Name == name)

                {

                    sheet = s;

                    break;

                }

            }

            return sheet;

        }

        /// <summary>

        /// 读取Excel单元

        /// </summary>

        /// <param name="sheetName">sheet名称</param>

        /// <returns></returns>

        public Array GetContent(string sheetName)

        {

            Worksheet sheet = GetWorksheetByName(sheetName);

            //获取A1 到AM24范围的单元格

            Range rang = sheet.get_Range("A1", "AM24");

            //我自己加的

            //sheet[index].Columns[index].copy();

            //sheet.Cells[1, 1] = "第一列";

            //sheet.Cells[1, 1] = "第一列 ";

            //sheet.Cells[2, 1] = "第一列 ";

            //sheet.Cells[1, 2] = "第二列 ";

            //sheet.Cells[2, 2] = "第二列 ";

            //sheet.get_Range(sheet.Cells[1, 1], sheet.Cells[sheet.UsedRange.Rows.Count, 1]).Delete(XlDeleteShiftDirection.xlShiftToLeft);

            //读一个单元格内容

            //sheet.get_Range("A1", Type.Missing);

            //不为空的区域,列,行数目

            //int l = sheet.UsedRange.Columns.Count;

            //int w = sheet.UsedRange.Rows.Count;

            //object[,] dell = sheet.UsedRange.get_Value(Missing.Value) as object[,];

            System.Array values = (Array)rang.Cells.Value2;

            return values;

        }

        public string GetContents(string sheetName)

        {

            Worksheet sheet = GetWorksheetByName(sheetName);

            //获取A1 到AM24范围的单元格

            Range rang = sheet.get_Range("A1", "AM24");

        }

        /// <summary>

        /// 关闭Excel文件

        /// </summary>

        public void Close()

        {

            excelApp.Quit();

            excelApp = null;

        }

    }

}