本文实例为大家分享了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());
}
}
}
}
