private async Task SaveCoupons(string fileName, string userId) { using (var x = _excelStream.Load(fileName)) { using (var sheet = x.LoadSheet(1)) { // Reading the data from sheet var index = 1; int baseUrlIndex = 0, priceIndex = 0, titleIndex = 0, shopNameIndex = 0, productNameIndex = 0, startIndex = 0, endIndex = 0, productTypeIndex = 0, pictureUrlIndex = 0, productUrlIndex = 0; IList <Coupon> coupons = new List <Coupon>(); foreach (var item in sheet) { if (index == 1) { for (var childIndex = 0; childIndex < item.Count; childIndex++) { switch (item[childIndex].Trim()) { case "商品名称": productNameIndex = childIndex; break; case "商品主图": pictureUrlIndex = childIndex; break; case "商品一级类目": productTypeIndex = childIndex; break; case "淘宝客链接": productUrlIndex = childIndex; break; case "商品价格": priceIndex = childIndex; break; case "店铺名称": shopNameIndex = childIndex; break; case "优惠券面额": titleIndex = childIndex; break; case "优惠券开始时间": startIndex = childIndex; break; case "优惠券结束时间": endIndex = childIndex; break; case "商品优惠券推广链接": baseUrlIndex = childIndex; break; } } index++; continue; } var coupon = new Coupon(); //Spider(item[10]); coupon.BaseUrl = item[baseUrlIndex]; coupon.Title = item[titleIndex]; coupon.ShopName = item[shopNameIndex]; coupon.ProductUrl = item[productUrlIndex]; coupon.PictureUrl = item[pictureUrlIndex]; coupon.ProductName = item[productNameIndex]; coupon.ProductType = item[productTypeIndex]; double price = 0; double.TryParse(item[priceIndex], out price); coupon.Price = price; DateTime startDate; DateTime.TryParse(item[startIndex], out startDate); coupon.StartDate = startDate; DateTime endDate; DateTime.TryParse(item[endIndex], out endDate); coupon.EndDate = endDate; coupon.UserId = userId; coupon.Id = Guid.NewGuid().ToString(); coupon.AddTime = DateTime.Now; coupon.Version = 0; coupons.Add(coupon); } await _service.AddAsync(coupons); } } }