/// <summary>
/// 读取CSV(Excel)文件
/// </summary>
private void ReadFile_CSV()
{
string url = "文件存放路径";//另外几篇中有获取文件存放路径的方法供参考
Aspose.Cells.TxtLoadOptions lo = new TxtLoadOptions();
lo.Encoding = Encoding.Default;//设置编码方式
Workbook workbook = new Workbook(url,lo);
//配置读取文件的类型(CSV)
workbook.FileFormat = FileFormatType.CSV;//可在此配置Excel文件类型
Worksheet worksheet = workbook.Worksheets[0];//默认第一个Sheet页
Cells cells = worksheet.Cells;
//读取到DataTable中
DataTable dt = cells.ExportDataTableAsString(0, 0, cells.MaxDataRow + 1, cells.MaxColumn + 1, true);
//释放资源
workbook = null;
worksheet = null;
}