C# Excel在复制后保持打开状态

using Excel = Microsoft.Office.Interop.Excel;

// 创建Excel应用程序对象
Excel.Application excelApp = new Excel.Application();

// 打开要复制的Excel文件
Excel.Workbook workbook = excelApp.Workbooks.Open("原始文件路径");

// 复制Excel文件
Excel.Workbook copiedWorkbook = workbook.Copy();

// 保持复制后的Excel文件打开状态
copiedWorkbook.Activate();

// 读取数据示例
Excel.Worksheet worksheet = copiedWorkbook.Worksheets[1];
Excel.Range range = worksheet.UsedRange;
int rowCount = range.Rows.Count;
int columnCount = range.Columns.Count;

for (int i = 1; i <= rowCount; i++)
{
    for (int j = 1; j <= columnCount; j++)
    {
        string cellValue = range.Cells[i, j].Value.ToString();
        Console.WriteLine(cellValue);
    }
}

// 关闭并保存复制后的Excel文件
copiedWorkbook.Close(true);

// 关闭原始Excel文件
workbook.Close(false);

// 退出Excel应用程序
excelApp.Quit();

// 释放资源
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(copiedWorkbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);