private void LoadMasterFile() { var provider = new ExcelProvider(); var sheet = this.shellViewModel.Sheets.SelectedItem; if (sheet != null) { var schools = provider.Read(this.shellViewModel.MasterFilePath, sheet.Name); var distinct = (from s in schools orderby s.SchoolFullName select s).DistinctBy(s => s.SchoolFullName); this.shellViewModel.Schools.Clear(); this.shellViewModel.FilteredSchools.Clear(); foreach (var school in distinct) { var viewModel = new SchoolViewModel(school); this.shellViewModel.Schools.Add(viewModel); this.shellViewModel.FilteredSchools.Add(viewModel); } } this.shellViewModel.ApplyFilter(); }
private static void Main(string[] args) { var e = new ExcelProvider(); e.Read(OdsFile, "KiTa"); var data = File.ReadAllBytes(CsvFile); var lines = File.ReadAllLines(CsvFile); using (var reader = new StreamReader(CsvFile, true)) { reader.Read(); Console.WriteLine(reader.CurrentEncoding); } var c = new CsvProvider(); c.Read(CsvFile); }
public IActionResult ImportExcel(IFormFile files) { if (files == null) { return(Json(new { success = false, message = "Ko đọc được file" })); } List <Product> products = new List <Product>(); string fileName = ""; string folderName = "wwwroot\\Media\\"; string webRootPath = _hostEnvironment.ContentRootPath; string newPath = Path.Combine(webRootPath, folderName); string fullPath = ""; if (!Directory.Exists(newPath)) { Directory.CreateDirectory(newPath); } if (files != null) { fileName = ContentDispositionHeaderValue.Parse(files.ContentDisposition).FileName.Trim('"'); fullPath = Path.Combine(newPath, fileName); using (var stream = new FileStream(fullPath, FileMode.Create)) { files.CopyTo(stream); } } try { var dataset = ExcelProvider.Read(fullPath); var ExcelTable = dataset.Tables[0]; foreach (DataRow row in ExcelTable.Rows) { var a = row.ItemArray[0].ToString(); if (a != "Id") { var p = new Product { Id = row.ItemArray[0].ToString(), Name = row.ItemArray[1].ToString(), Description = row.ItemArray[2].ToString(), ImageUrl = row.ItemArray[3].ToString(), Price = float.Parse(row.ItemArray[4].ToString()), IsConfirm = bool.Parse(row.ItemArray[5].ToString()), Quantity = int.Parse(row.ItemArray[6].ToString()), CategoryId = row.ItemArray[7].ToString(), ShopId = row.ItemArray[8].ToString() }; products.Add(p); } } _db.Products.AddRange(products); _db.SaveChanges(); return(Json(new { success = true, message = "Thêm danh sách sản phẩm bằng excel thành công" })); } catch (Exception e) { return(Json(new { success = false, message = e.InnerException.Message })); } }