Magicodes.IE.Excel
导出Excel 组件,非常好用的. 本人在使用过程中遇到的一些小小问题分享给大家注意的:
第一:注意字段不能有空格
第二:注意属性类型最好都是string类型
[HttpPost]
[Route("[area]/[controller]/[action]")]
public IActionResult DownloadEmployee(DownloadEmployeeInput input)
{
ResponseModalX responseModalX = new ResponseModalX();
DataBaseContext dataBaseContext = new DataBaseContext();
if (!IsFrommApi)
{
input.MainComId = input.MainComId ?? WebCookieBase.MainComId;
}
if (CheckMaincomConsistency(input.MainComId) == false && IsFrommApi)
{
responseModalX.meta = new MetaModalX
{
Success = false,
ErrorCode = (int)GeneralReturnCode.REQUIRED_CORRECT_PARMS_MAINCOM_ID,
Message = GeneralReturnCode.REQUIRED_CORRECT_PARMS_MAINCOM_ID.GetEnumDescription()
};
return Ok(responseModalX);
}
var employeeLists = from s in dataBaseContext.Employee.Where(c => c.MainComId == input.MainComId)
select s;
if (!String.IsNullOrEmpty(input.Search))
{
input.Search = WebUtility.UrlDecode(input.Search).Trim();
employeeLists = employeeLists.Where(s => s.FirstName.Contains(input.Search)
|| s.LastName.Contains(input.Search)
|| s.CnName.Contains(input.Search)
|| s.Email.Contains(input.Search)
|| s.PhoneNumber.Contains(input.Search)
|| s.ContractorName.Contains(input.Search)
|| s.SiteName.Contains(input.Search)
|| s.DepartmentName.Contains(input.Search)