worksheet获取cell_Aspose.Cells读取Excel获取DataTable方法

///

/// 转DataTable

///

/// Excel文件地址

/// Sheet名称

/// 开始行数

/// 开始列数

///

public static DataTable GetDataTable(string ExcelPath, string SheetName, int StartRowIndex, int StartColumnIndex)

{

DataTable dt = new DataTable();

try

{

Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(ExcelPath);

Aspose.Cells.Worksheet sheet = workbook.Worksheets[SheetName];

dt = sheet.Cells.ExportDataTable(StartRowIndex, StartColumnIndex, sheet.Cells.MaxDataRow + 1, sheet.Cells.MaxDataColumn + 1, true);

}

catch (Exception ex)

{

dt = null;

}

return dt;

}

删除行方法：

///

/// 删除Excel多行

///

/// Excel路径

/// Sheet表名

/// 删除多行，注意删除的顺序必须为倒序(RowNumber="4,3,2,1,0")

///

public static bool DeleteRow(string ExcelPath, string SheetName, string RowNumber)

{

bool IsDelete = false;

try

{

Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(ExcelPath);

Aspose.Cells.Worksheet sheet = workbook.Worksheets[SheetName];

string[] InputStr = RowNumber.Split(',');

foreach (string item in InputStr)

{

sheet.Cells.DeleteRow(int.Parse(item));

}

workbook.Save(ExcelPath);

IsDelete = true;

}

catch (Exception)

{

IsDelete = false;

}

return IsDelete;

}