本文實例為大家分享了Aspose.Cells實現導入導出的具體代碼，供大家參考，具體內容如下

這是自己整理的導入導出類,里面有注釋。

using System;using System.Collections.Generic;using System.Data;using System.IO;using System.Linq;using System.Text;using System.Threading.Tasks;using Aspose.Cells;namespace Lzd.Mvc.EasyUi.Common.ExcelUtil{  ///   /// excel操作基類  ///   ///  public  class BaseExcelUtil  {    private Workbook m_Wb = null;        ///     /// 生成Excel    ///     /// 模板Excel的路徑+文件名    /// Excel文件的字節對象    public byte[] CreateExcel(string url)    {      FileStream fs = null;      try      {        //讀取模板Excel文件的中內容        fs = new FileStream(url, FileMode.Open, FileAccess.Read, FileShare.Read);         m_Wb = new Workbook();         m_Wb.Open(fs);         setValue(m_Wb);         //轉換為字節對象并返回        return m_Wb.SaveToStream().ToArray();       }      catch (Exception ex)      {        throw ex;      }      finally      {        fs.Close();      }    }      ///     /// 設定Excel中的數據     /// 數據源為datable類型    ///     /// 工作簿    public virtual void setValue(Workbook wb)    {      throw new Exception("The method or operation is not implemented.");    }             ///     /// 讀取Excel    ///     /// Excel的路徑+文件名    /// Excel文件的字節對象    public DataTable GetExcel(string url)    {      FileStream fs = null;      try      {        //讀取Excel文件的中內容        fs = new FileStream(url, FileMode.Open, FileAccess.Read, FileShare.Read);         m_Wb = new Workbook();         m_Wb.Open(fs);         //設定Excel中的數據       return  getValue(m_Wb);       }      finally      {        fs.Close();      }    }     ///     /// 取得Excel中的數據    ///     /// 工作簿    public virtual DataTable getValue(Workbook wb)    {      throw new Exception("The method or operation is not implemented.");    }    ///     /// 設置字符串值    ///     ///     ///     public void putValue(Cell c, object value)    {      try      {        if (value == null || object.Equals(value, DBNull.Value) || value.ToString().Trim().Length == 0)        {         }        else        {          c.PutValue(value.ToString());        }      }      catch (Exception)      {        c.PutValue("--");      }    }    ///     /// 設置數值值    ///     ///     ///     public void putValueDouble(Cell c, object value)    {      try      {        if (value == null || object.Equals(value, DBNull.Value) || value.ToString().Trim().Length == 0)        {         }        else        {          c.PutValue(Decimal.Parse(value.ToString()));        }      }      catch (Exception)      {        c.PutValue(value.ToString());      }    }    ///     /// 設置日期值    ///     ///     ///     public void putDateValue(Cell c, object value)    {      try      {        if (value == null || object.Equals(value, DBNull.Value) || value.ToString().Trim().Length == 0)        {         }        else        {          c.PutValue(DateTime.Parse(value.ToString()));        }      }      catch (Exception)      {        c.PutValue(value.ToString());      }    }    }  }