如何将Excel Interop与ClosedXml混合使用:样式

using Excel = Microsoft.Office.Interop.Excel;

// 打开Excel文件
Excel.Application excelApp = new Excel.Application();
Excel.Workbook workbook = excelApp.Workbooks.Open("path/to/excel/file.xlsx");
Excel.Worksheet worksheet = workbook.ActiveSheet;

using ClosedXML.Excel;

// 创建ClosedXml的工作簿
XLWorkbook closedXmlWorkbook = new XLWorkbook();

// 将Excel Interop的工作表数据复制到ClosedXml的工作表
Excel.Range range = worksheet.UsedRange;
object[,] values = range.Value;
for (int row = 1; row <= values.GetLength(0); row++)
{
    for (int column = 1; column <= values.GetLength(1); column++)
    {
        closedXmlWorkbook.Worksheets.Worksheet(1).Cell(row, column).Value = values[row, column];
    }
}

// 保存ClosedXml的工作簿
closedXmlWorkbook.SaveAs("path/to/new/excel/file.xlsx");