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);
}
}
