C#在excel单元格中查找和替换换行符

using Microsoft.Office.Interop.Excel;

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

// 打开Excel文件
Workbook workbook = excelApp.Workbooks.Open("文件路径");
Worksheet worksheet = workbook.Worksheets[1];

// 定位到需要操作的单元格范围
Range range = worksheet.UsedRange;

// 查找和替换换行符
range.Replace("\n", "替换内容", XlLookAt.xlPart, XlSearchOrder.xlByRows, false, false, false);

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

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

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