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