Aspose.Cells Excel删除行

时间:2022-12-08 15:37:29

导出Excel所引用的dll,Aspose.Cells.dll下载地址:
http://download.csdn.net/detail/qq285679784/8569327

///
/// 删除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();
workbook.LoadData(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;
    }