| | |
| | | int y = 1; |
| | | var columnTitles = new List<string>() |
| | | { |
| | | /*"建档时间",*/"客户单位","详细地址","联系电话","电子邮箱","客户微信" |
| | | "建档时间","客户来源","行业分类","客户类型","客户名称","客户单位","联系人微信" |
| | | ,"客户地址","网址","联系人座机","联系人手机","联系人QQ","联系人邮箱", |
| | | |
| | | "联系人2姓名","联系人2手机","联系人2QQ" |
| | | |
| | | }; |
| | | foreach(var columnTitle in columnTitles) |
| | | { |
| | |
| | | x++; |
| | | y = 1; |
| | | var cell = worksheet.Cells[x, y++]; |
| | | //cell.Value = item.CreatetimeName; |
| | | //cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.CreatetimeName; |
| | | |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.KhlyName; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.HyflName; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.KhlxName; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.Name; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.Name; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.Weixin; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.Address; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.Url; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.Tel; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.Phone; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.Qq; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.Email; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.Weixin; |
| | | cell.Value = item.YwName; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.YwTel; |
| | | cell = worksheet.Cells[x, y++]; |
| | | cell.Value = item.YwQq; |
| | | |
| | | |
| | | |
| | | } |