Having trouble accessing a CSV file with JQuery and FileContentResult?

Question

Having trouble accessing a CSV file with JQuery and FileContentResult?

How can I make an ajax call without using ActionLink in my controller? Here is a snippet of my controller code:

public IActionResult ExportUsers(List<string> listOfEmails)
{
     /*some data processing*/
     return File(result, "text/csv", "ExportCandidates.csv");
}

When making the ajax call on the other side, I use the following method:

        $.ajax({
            url: '/Admin/Testcenter/GenerateInvitationPreview',
            type: 'post',
            data: {
                    //some input data to send to the controller   
           },
           success: function (response) {
               )
           }
       });

I have seen examples for PDF files where a base64 file is returned and handled in the ajax response. Is there a way to do something similar for CSV files so that the user can download it?

javascript c#ajax asp.net-mvc

Answer 1

Answer №1

Utilize NPOI Library to Create Excel Sheets  

  //Generating Excel Sheet
        try
                {
                    Guid gid = Guid.NewGuid();
                    string ext = ".xls";
                    string[] Headers = { "Appointment ID", "Date of Appointment", "Doctor's Name", "Patient's Name", "Visit Type", "Status" };
                    string fileName = "AppointmentsExcelSheet_" + gid.ToString() + ext;
                    var serverpath = _env.ContentRootPath;
                    string rootpath = serverpath + "/wwwroot/ExcelSheets/" + fileName;
                    FileInfo file = new FileInfo(Path.Combine(rootpath, fileName));
                    var memorystream = new MemoryStream();
                    using (var fs = new FileStream(rootpath, FileMode.Create, FileAccess.Write))
                    {
    
                        IWorkbook workbook = new XSSFWorkbook();
                        ISheet excelSheet = workbook.CreateSheet("List of Appointments");
                        IRow row = excelSheet.CreateRow(0);
                        var font = workbook.CreateFont();
                        font.FontHeightInPoints = 11;
                        font.FontName = "Calibri";
                        font.Boldweight = (short)FontBoldWeight.Bold;
                        for (var i = 0; i < Headers.Length; i++)
                        {
                            var cell = row.CreateCell(i);
                            cell.SetCellValue(Headers[i]);
                            cell.CellStyle = workbook.CreateCellStyle();
                            cell.CellStyle.SetFont(font);
                        }
    
                        var result = _Appointment.GetAppoinmentsPDf();
                        int index = 1;
                        foreach (var app in result.Items)
                        {
                            //var PatientDob = Convert.ToDouble(app.PatientDOB);
                            row = excelSheet.CreateRow(index);
                            row.CreateCell(0).SetCellValue(app.AppointmentId);
                            row.CreateCell(1).SetCellValue(app.DateofAppointment+" "+app.TimeofAppointment);
                            row.CreateCell(2).SetCellValue(app.DoctorFullName);
                            row.CreateCell(3).SetCellValue(app.SelectedPatientName);
                            row.CreateCell(4).SetCellValue(app.PurposeofVisit);
                            if (app.IsActive == false)
                            {
                                row.CreateCell(5).SetCellValue("Inactive");
                            }
                            else
                            {
                                row.CreateCell(5).SetCellValue("Active");
                            }
                            index++;
                        }
                        workbook.Write(fs);
                    }
                    using (var filestream = new FileStream(rootpath, FileMode.Open))
                    {
                        filestream.CopyToAsync(memorystream);
                    }
                    memorystream.Position = 0;
                    //pass filepath to jQuery function
                    response.Msg = "/ExcelSheets/" + fileName;
    
                }
                catch (Exception Ex)
                {
                  //handle exceptions here
                }
           return Ok(reponse.Msg)
    //Implementing JavaScript
    function GenerateAppointmentsExcelSheet() {
        //var token = Token;
        //var link = path;
        debugger
        $.ajax({
            //'Content-Type': 'application/pdf.',
            type: "GET",
            url: "/api/Appointments/GenerateAppointmentsExcelSheet",
            beforeSend: function () {
                $.blockUI({
                    message: ('<img src="/images/FadingLines.gif"/>'),
                    css: {
                        backgroundColor: 'none',
                        border: '0',
                        'z-index': 'auto'
                    }
                });
            },
            complete: function () {
                $.unblockUI();
            },
           
            success: function (data) {
                debugger
                //download the Excel sheet
                window.location.href = data.msg;
                
            }
    
        });
    
    }

Answer 2

Utilize NPOI Library to Create Excel Sheets  

  //Generating Excel Sheet
        try
                {
                    Guid gid = Guid.NewGuid();
                    string ext = ".xls";
                    string[] Headers = { "Appointment ID", "Date of Appointment", "Doctor's Name", "Patient's Name", "Visit Type", "Status" };
                    string fileName = "AppointmentsExcelSheet_" + gid.ToString() + ext;
                    var serverpath = _env.ContentRootPath;
                    string rootpath = serverpath + "/wwwroot/ExcelSheets/" + fileName;
                    FileInfo file = new FileInfo(Path.Combine(rootpath, fileName));
                    var memorystream = new MemoryStream();
                    using (var fs = new FileStream(rootpath, FileMode.Create, FileAccess.Write))
                    {
    
                        IWorkbook workbook = new XSSFWorkbook();
                        ISheet excelSheet = workbook.CreateSheet("List of Appointments");
                        IRow row = excelSheet.CreateRow(0);
                        var font = workbook.CreateFont();
                        font.FontHeightInPoints = 11;
                        font.FontName = "Calibri";
                        font.Boldweight = (short)FontBoldWeight.Bold;
                        for (var i = 0; i < Headers.Length; i++)
                        {
                            var cell = row.CreateCell(i);
                            cell.SetCellValue(Headers[i]);
                            cell.CellStyle = workbook.CreateCellStyle();
                            cell.CellStyle.SetFont(font);
                        }
    
                        var result = _Appointment.GetAppoinmentsPDf();
                        int index = 1;
                        foreach (var app in result.Items)
                        {
                            //var PatientDob = Convert.ToDouble(app.PatientDOB);
                            row = excelSheet.CreateRow(index);
                            row.CreateCell(0).SetCellValue(app.AppointmentId);
                            row.CreateCell(1).SetCellValue(app.DateofAppointment+" "+app.TimeofAppointment);
                            row.CreateCell(2).SetCellValue(app.DoctorFullName);
                            row.CreateCell(3).SetCellValue(app.SelectedPatientName);
                            row.CreateCell(4).SetCellValue(app.PurposeofVisit);
                            if (app.IsActive == false)
                            {
                                row.CreateCell(5).SetCellValue("Inactive");
                            }
                            else
                            {
                                row.CreateCell(5).SetCellValue("Active");
                            }
                            index++;
                        }
                        workbook.Write(fs);
                    }
                    using (var filestream = new FileStream(rootpath, FileMode.Open))
                    {
                        filestream.CopyToAsync(memorystream);
                    }
                    memorystream.Position = 0;
                    //pass filepath to jQuery function
                    response.Msg = "/ExcelSheets/" + fileName;
    
                }
                catch (Exception Ex)
                {
                  //handle exceptions here
                }
           return Ok(reponse.Msg)
    //Implementing JavaScript
    function GenerateAppointmentsExcelSheet() {
        //var token = Token;
        //var link = path;
        debugger
        $.ajax({
            //'Content-Type': 'application/pdf.',
            type: "GET",
            url: "/api/Appointments/GenerateAppointmentsExcelSheet",
            beforeSend: function () {
                $.blockUI({
                    message: ('<img src="/images/FadingLines.gif"/>'),
                    css: {
                        backgroundColor: 'none',
                        border: '0',
                        'z-index': 'auto'
                    }
                });
            },
            complete: function () {
                $.unblockUI();
            },
           
            success: function (data) {
                debugger
                //download the Excel sheet
                window.location.href = data.msg;
                
            }
    
        });
    
    }

Answer 3

Answer №2

To achieve your desired outcome, it is recommended to avoid using AJAX and instead opt for a link click that triggers a new window to open (especially when passing parameters). Another option could be to utilize a form with a target="_blank" attribute to facilitate the response process. Within this form, you can include a single field or multiple input fields with the same name to store the list of emails. Your action handler would then be able to extract and manipulate this list before returning a File response. By submitting the form, the new window will automatically display the file generated from the operation.

Answer 4

To achieve your desired outcome, it is recommended to avoid using AJAX and instead opt for a link click that triggers a new window to open (especially when passing parameters). Another option could be to utilize a form with a target="_blank" attribute to facilitate the response process. Within this form, you can include a single field or multiple input fields with the same name to store the list of emails. Your action handler would then be able to extract and manipulate this list before returning a File response. By submitting the form, the new window will automatically display the file generated from the operation.

Having trouble accessing a CSV file with JQuery and FileContentResult?

Answer №1

Answer №2

Similar questions

Understanding ReactJs component syntax: Exploring the nuances and distinctions

Redirecting script upon successful connection detection

Creating PDF documentation in a JavaScript architecture MVC framework, specifically utilizing Backbone.js

React JS server conditional response malfunctioning

Unlock the Power of Heroku: Leveraging Node.js to Share Environment Variables Across JavaScript Pages

How to achieve a typewriter effect in React using JavaScript

Trouble with $sce in Angular.js causing limitations on passing desired content into my directive

Unexpected appearance of a blue line in Material UI when the overflow attribute is included

Fade-in loader with centered placement on the full page

How can I use JavaScript to create a drop-down menu that only appears after selecting the previous one?

What steps do I need to take to begin posting on NodeJS?

The packery's overlapping issue arises when using the layout method to add HTML elements through AJAX, causing it to malfunction

Creating a Draft.js selection with a specified start and end point

Interacting with PHP variables in JSON format

Does PHP/AJAX only function when an output is generated?

Invoking a web service using jQuery remotely

Sending a POST request using Node.js Express: A step-by-step guide

Using Typeof in an IF statement is successful, but attempting to use ELSE with the same

Issues with exporting data to Excel in WEB API are causing problems and need to

How to handle non-ASCII characters when encoding in JSON?