1.OpenXmlSDK是个很好的类库，可惜只能通过C＃调用，C＃的童鞋又福气了。

2.服务端程序由于没法安装office,所以这个对asp.net网站来说是最理想的库了。需要.net 4.0版本以上.

3.以流形式,sax模型读取大文件。

 

using System;using System.Collections.Generic;using System.Linq;using System.Text;using DocumentFormat.OpenXml;using DocumentFormat.OpenXml.Packaging;using DocumentFormat.OpenXml.Spreadsheet;namespace ConsoleApplication1{    class ProductObject    {        public String xinghao;//型号        public String changjia;//厂家        public String pihao;//批号        public String fengzhuang;//封装        public String shuliang;//数量        public void init()         {            //初始化成员变量        }    }    class Program    {        static void Main(string[] args)        {            String fileName = @"E:\software\TestData\xlsx\test.xlsx";            Program pro = new Program();            pro.ReadAllCellValues(fileName);        }        void CallSqlInsert(ProductObject po)        {            //call bl interface method to insert data to database.            //注意处理空值的情况            Console.Out.Write("{0}:{1}:{2}:{3}:{4} ", po.xinghao, po.changjia, po.pihao, po.fengzhuang, po.shuliang);            Console.Out.WriteLine();        }        String GetCellValue(WorkbookPart workbookPart,Cell c)         {            string cellValue;            if (c.DataType != null && c.DataType == CellValues.SharedString)            {                SharedStringItem ssi = workbookPart.SharedStringTablePart.SharedStringTable.Elements
     
      ().ElementAt(int.Parse(c.CellValue.InnerText));                cellValue = ssi.Text.Text;            }            else            {                cellValue = c.CellValue.InnerText;            }            return cellValue;        }        Boolean StoreProductObject(OpenXmlReader reader, WorkbookPart workbookPart, ProductObject po)         {            reader.ReadFirstChild();            if (reader.ElementType != typeof(Cell))            {                return false;            }            Cell c = (Cell)reader.LoadCurrentElement();            po.xinghao = GetCellValue(workbookPart,c);            reader.ReadNextSibling();            c = (Cell)reader.LoadCurrentElement();            po.changjia = GetCellValue(workbookPart,c);            reader.ReadNextSibling();            c = (Cell)reader.LoadCurrentElement();            po.pihao = GetCellValue(workbookPart,c);            reader.ReadNextSibling();            c = (Cell)reader.LoadCurrentElement();            po.fengzhuang = GetCellValue(workbookPart,c);            reader.ReadNextSibling();            c = (Cell)reader.LoadCurrentElement();            po.shuliang = GetCellValue(workbookPart,c);            return true;        }        //这种SAX的读取方式很高效,至于是读一行提交一行好还是读100行再提交100行好自己决定.        //这种SAX的方式对读取超大xlsx文件不存在内存占用过大和慢的问题.        void ReadAllCellValues(string fileName)        {            using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(fileName, false))            {                WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;                ProductObject po = new ProductObject();                foreach (WorksheetPart worksheetPart in workbookPart.WorksheetParts)                {                    OpenXmlReader reader = OpenXmlReader.Create(worksheetPart);                    while (reader.Read())                    {                        if (reader.ElementType == typeof(Worksheet))                        {                            if (reader.ReadFirstChild())                            {                                SheetProperties properties = (SheetProperties)reader.LoadCurrentElement();                                //只处理名字是Sheet1的,其他不处理                                if (properties.CodeName != "Sheet1")                                {                                    break;                                }                            }                        }                        if (reader.ElementType == typeof(Row))                        {                            //先调用一个成员函数初始化init,自己写.                            po.init();                            if (StoreProductObject(reader, workbookPart, po))                             {                                CallSqlInsert(po);                            }                                                    }                    }                }            }        }    }}