eplus操作excle行高自动换行

private static void ChangeAllRowHeight(string filePath, string sheetName, double rowHeight)
{
    using (ExcelPackage excelPackage = new ExcelPackage(new FileInfo(filePath)))
    {
        ExcelWorksheet excelWorksheet = excelPackage.Workbook.Worksheets[sheetName];
        int rowCount = excelWorksheet.Dimension.End.Row;
        
        // Set row height for each row and disable wrap text
        for (int i = 1; i <= rowCount; i++)
        {
            excelWorksheet.Row(i).Height = rowHeight;
            excelWorksheet.Row(i).Style.WrapText = false; // Disable wrap text
            
            // Set background color for the first row
            if (i == 1)
            {
                excelWorksheet.Row(i).Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
                excelWorksheet.Row(i).Style.Fill.BackgroundColor.SetColor(Color.Gray); // Set gray background
            }
        }
        
        excelPackage.Save();
    }
}