public List <sheetName> postExcel([FromForm(Name = "file")] IFormFile input) { var file = input.FileName; string uploadsFolder = Path.Combine(Directory.GetCurrentDirectory(), "uploadFolder"); if (!Directory.Exists(uploadsFolder)) { Directory.CreateDirectory(uploadsFolder); } string uniqueFileName = Guid.NewGuid().ToString() + "_" + input.FileName; string filePath = Path.Combine(uploadsFolder, uniqueFileName); FileStream fs = new FileStream(filePath, FileMode.Create); input.CopyTo(fs); // fs.Flush(); fs.Close(); FileStream fs2 = new FileStream(filePath, FileMode.Open); IWorkbook workbook = WorkbookFactory.Create(fs2); List <sheetName> res = new List <sheetName>(); for (var i = 0; i < workbook.NumberOfSheets; i++) { var fpath = new sheetName(); fpath.sname = workbook.GetSheetAt(i).SheetName; res.Add(fpath); } fs2.Close(); var tempN = new sheetName(); tempN.sname = filePath; res.Add(tempN); return(res); }
public void delExcel([FromBody] sheetName namePrm) { if (System.IO.File.Exists(namePrm.sname)) { System.IO.File.Delete(namePrm.sname); } }