在我的 MVC 控制器中,我试图逐行读取 Excel。但是有一个问题!
我希望能够将其映射到列表。模型类包含29个字段。
public class GroupMembershipUploadInput
{
public string chpt_cd {get;set;}
public string cnst_mstr_id {get;set;}
public string cnst_prefix_nm {get;set;}
public string cnst_first_nm {get;set;}
public string cnst_middle_nm {get;set;}
public string cnst_last_nm {get;set;}
public string cnst_addr1_street1 {get;set;}
public string cnst_addr1_street2 {get;set;}
public string cnst_addr1_city {get;set;}
public string cnst_addr1_state {get;set;}
public string cnst_addr1_zip {get;set;}
public string cnst_addr2_street1 {get;set;}
public string cnst_addr2_street2 {get;set;}
public string cnst_addr2_city {get;set;}
public string cnst_addr2_state {get;set;}
public string cnst_addr2_zip {get;set;}
public string cnst_phn1_num {get;set;}
public string cnst_phn2_num {get;set;}
public string cnst_phn3_num {get;set;}
public string cnst_email1_addr {get;set;}
public string cnst_email2_addr {get;set;}
public string job_title {get;set;}
public string company_nm {get;set;}
public string grp_cd {get;set;}
public string grp_nm {get;set;}
public string rm_ind {get;set;}
public string notes {get;set;}
public string stuart_cnst_grp_key {get;set;}
public string created_by {get;set;}
public string created_dt {get;set;}
}
public class ListGroupMembershipUploadInput
{
public List<GroupMembershipUploadInput> GroupMembershipUploadInputList { get; set; }
}
问题是
我应该根据列标题将 Excel 中的字段映射到此字段。像这里一样,Excel 中的列标题可以是
因此,无需硬编码,我应该能够将列标题“名字”下的值放入模型字段“cnst_first_nm”。
等等。
此列在 Excel 中也不必按此顺序。所以需要灵活处理。
我正在尝试:
ExcelPackage ep = new ExcelPackage(new FileInfo(savedFilePath));
ExcelWorksheet ws = ep.Workbook.Worksheets["Sheet1"];
ListGroupMembershipUploadInput gl = new ListGroupMembershipUploadInput();
for (int i = 3; i <= ws.Dimension.End.Row; i++)
{
GroupMembershipUploadInput gm = new GroupMembershipUploadInput();
for (int j = ws.Dimension.Start.Column; j <= ws.Dimension.End.Column; j++)
{
//gm.cnst_first_nm = ws.Cells[i, j].Value.ToString();
}
gl.Add(gm);
}
我无法解决它。我知道我在某个地方错过了一些东西。可以做什么?
一个简单的例子
public void readXLS(string FilePath)
{
FileInfo existingFile = new FileInfo(FilePath);
using (ExcelPackage package = new ExcelPackage(existingFile))
{
//get the first worksheet in the workbook
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
int colCount = worksheet.Dimension.End.Column; //get Column Count
int rowCount = worksheet.Dimension.End.Row; //get row count
for (int row = 1; row <= rowCount; row++)
{
for (int col = 1; col <= colCount; col++)
{
Console.WriteLine(" Row:" + row + " column:" + col + " Value:" + worksheet.Cells[row, col].Value.ToString().Trim());
}
}
}
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)