使用EPPLUS - MVC获取excel文件后，将日期mm/dd/yyyy更改为dd/mm/yyyy

using OfficeOpenXml;

public ActionResult ChangeDateFormat()
{
    string filePath = "路径/文件名.xlsx";
    
    using (ExcelPackage package = new ExcelPackage(new FileInfo(filePath)))
    {
        ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
        
        // 在这里进行日期格式更改的操作
    }
    
    return View();
}

for (int row = 1; row <= worksheet.Dimension.End.Row; row++)
{
    for (int col = 1; col <= worksheet.Dimension.End.Column; col++)
    {
        if (worksheet.Cells[row, col].Value is DateTime)
        {
            DateTime dateValue = (DateTime)worksheet.Cells[row, col].Value;
            worksheet.Cells[row, col].Style.Numberformat.Format = "dd/mm/yyyy";
            worksheet.Cells[row, col].Value = dateValue;
        }
    }
}

package.Save();