From 423abcb9d7af20b0d18a49cc4f13167f4b64107f Mon Sep 17 00:00:00 2001
From: sunpengfei <i@angelzzz.com>
Date: 星期四, 11 九月 2025 14:19:00 +0800
Subject: [PATCH] feat:开发
---
FlexJobApi.Core/Utils/ExcelUtils/ExcelUtils.cs | 16 ++++++++++++++--
1 files changed, 14 insertions(+), 2 deletions(-)
diff --git a/FlexJobApi.Core/Utils/ExcelUtils/ExcelUtils.cs b/FlexJobApi.Core/Utils/ExcelUtils/ExcelUtils.cs
index c13dd1d..8ec4dc8 100644
--- a/FlexJobApi.Core/Utils/ExcelUtils/ExcelUtils.cs
+++ b/FlexJobApi.Core/Utils/ExcelUtils/ExcelUtils.cs
@@ -47,6 +47,14 @@
var config = new OpenXmlConfiguration();
config.TableStyles = TableStyles.None;
config.AutoFilter = false;
+ config.FastMode = true;
+ config.EnableAutoWidth = true;
+ config.StyleOptions = new OpenXmlStyleOptions
+ {
+ WrapCellContents = false
+ };
+ config.FreezeRowCount = 0;
+
config.DynamicColumns = typeof(T).GetProperties().Select(it =>
{
var propertyType = it.PropertyType;
@@ -68,14 +76,18 @@
return model?.Description;
}
return v;
- }
+ },
};
+ if (propertyType == typeof(DateTime))
+ {
+ column.Format = "yyyy-MM-dd HH:mm:ss";
+ }
return column;
}).ToArray();
var stream = new MemoryStream();
await MiniExcel.SaveAsAsync(stream, models, configuration: config);
stream.Seek(0, SeekOrigin.Begin);
- return AliyunOSSUtils.Upload(scene, stream, filename);
+ return AliyunOSSUtils.Upload(scene, stream, filename).Url;
}
}
}
--
Gitblit v1.9.1