如何使用C#代码在Excel中的多个电子表格中拆分数据？

using Excel = Microsoft.Office.Interop.Excel;

public void SplitDataToMultipleWorksheets(string excelFilePath, string[] sheetNames, int batchSize)
{
    Excel.Application excelApp = new Excel.Application();
    Excel.Workbook workbook = excelApp.Workbooks.Open(excelFilePath);
    
    try
    {
        Excel.Worksheet activeSheet = workbook.ActiveSheet;

        for (int i = 0; i < sheetNames.Length; i++)
        {
            // 创建新的工作表
            Excel.Worksheet newWorksheet = workbook.Sheets.Add(Type.Missing, activeSheet, 1, Type.Missing);
            newWorksheet.Name = sheetNames[i];

            // 复制源数据到新的工作表
            Excel.Range sourceRange = activeSheet.Range["A1"].CurrentRegion;
            int rowCount = sourceRange.Rows.Count;

            int startIndex = i * batchSize + 1;
            int endIndex = Math.Min(startIndex + batchSize - 1, rowCount);

            Excel.Range destinationRange = newWorksheet.Range["A1"].Resize[endIndex - startIndex + 1, sourceRange.Columns.Count];
            sourceRange.Copy(destinationRange);

            // 删除源数据中已拆分的部分
            Excel.Range deleteRange = activeSheet.Range[$"A{startIndex}"].Resize[endIndex - startIndex + 1, sourceRange.Columns.Count];
            deleteRange.Delete(Excel.XlDeleteShiftDirection.xlShiftUp);
        }
    }
    finally
    {
        // 关闭并保存Excel文件
        workbook.Save();
        workbook.Close();
        excelApp.Quit();

        // 释放COM对象
        System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
        System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
    }
}