public IActionResult SetExcelValue(string companyName, string sheetName, int row, int col, string newData)
{
var excelpath = Path.Combine(_host.WebRootPath, "excel", companyName + ".xlsx");
AnalyExcelService.SetCellValue(excelpath, sheetName, row, col, newData);
return(Json(new Result()
{
IsSuccess = true
}));
}
public IActionResult AnalyExcelFile(string companyName, string sheetName, int pageNum, string searchWords)
{
var excelpath = Path.Combine(_host.WebRootPath, "excel", companyName + ".xlsx");
if (pageNum == 0)
{
pageNum = 1;
}
return(View(AnalyExcelService.GetView(excelpath, sheetName, pageNum, searchWords)));
}
