Tengo un problema para encontrar el código jQuery o JavaScript adecuado para permitir que los usuarios descarguen un archivo de Excel que se generó en el controlador API de C#, probé muchas formas diferentes y ninguna de ellas funcionó.
public ApiResponse DownloadAllMembersFile(IEnumerable<IMember> members) { using (var workbook = new XLWorkbook()) { var worksheet = workbook.Worksheets.Add("AllMembers"); var currentRow = 1; #region Header worksheet.Cell(currentRow, 1).Value = "StudentId"; worksheet.Cell(currentRow, 2).Value = "Name"; worksheet.Cell(currentRow, 3).Value = "Email"; #endregion #region Body foreach (var member in members) { currentRow++; worksheet.Cell(currentRow, 1).Value = member.Id; worksheet.Cell(currentRow, 2).Value = member.Name; worksheet.Cell(currentRow, 3).Value = member.Email; } #endregion using (var stream = new MemoryStream()) { workbook.SaveAs(stream); var content = stream.ToArray(); return new ApiResponse( true,"done",File( content, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "AllMembers.xlsx" )); } } }