NPOI生成Excel文件时设置一整列为文本类型

var mappings = new List<(string propertyName, string caption)>()
{
 (nameof(ExportTemplateData.BusinessPartnerCode ),"合作伙伴代码"),
 (nameof(ExportTemplateData.BusinessPartnerName ),"合作伙伴名称"),
 (nameof(ExportTemplateData.OrganizationCode03 ),"工厂代码"),
 (nameof(ExportTemplateData.WarehouseCode),"仓库代码")
};
var data = new List<ExportTemplateData>();
var bytes = NOPIHelper.saveExcel(data, mappings, true, NOPIHelper.WorkbookType.xlsx, sheet =>
{
 var cellRange = new CellRangeAddressList(0, 65535, 0, 6);
 ICellStyle style = sheet.Workbook.CreateCellStyle();
 IDataFormat format = sheet.Workbook.CreateDataFormat();
 style.DataFormat = format.GetFormat("@"); // "@"符号表示文本格式
 sheet.SetDefaultColumnStyle(1, style);
 sheet.SetDefaultColumnStyle(2, style);
 sheet.SetDefaultColumnStyle(3, style);
 sheet.SetDefaultColumnStyle(4, style);

});
string fielName = $"映射模板.xlsx";
return (fielName, bytes);