Jan 17, 2015

Upload and Read CSV File in ASP.NET MVC

To read CSV file doesn’t mean to use String.Split(). CSV files may contain commas, carriage returns, speechmarks…etc within strings. In this post, we will learn how to upload and read CSV File in ASP.NET MVC WITHOUT using Jet/ACE OLEDB provider. It is helpful when you have to deploy your code on shared hosting, Azure website or any server where ACE Database engine is not available. We will use a fast CSV Reader by Sebastien Lorien.

Read Also: Upload and Read Excel File (.xls, .xlsx) in ASP.NET MVC.

Steps:

1. Create ASP.NET MVC 5 Empty Project

2. To install CSVReader, run the following command in the Package Manager Console:

Install-Package LumenWorksCsvReader

3. Add New Controller say HomeController and add following action:

 public ActionResult Upload()
        {
            return View();
        }

4. Add View of Upload action and use following code:

@model System.Data.DataTable
@using System.Data;

<h2>Upload File</h2>

@using (Html.BeginForm("Upload", "Home", null, FormMethod.Post, new { enctype = "multipart/form-data" }))
{
    @Html.AntiForgeryToken()    
    @Html.ValidationSummary()
    
    <div class="form-group">
        <input type="file" id="dataFile" name="upload" />
    </div>
    
    <div class="form-group">
        <input type="submit" value="Upload" class="btn btn-default" />
    </div>
    
    if (Model != null)
    {
        <table>
            <thead>
                <tr>
                    @foreach (DataColumn col in Model.Columns)
                    {         
                        <th>@col.ColumnName</th>
                    }
                </tr>
            </thead>
            <tbody>
                @foreach (DataRow row in Model.Rows)
                {        
                    <tr>
                        @foreach (DataColumn col in Model.Columns)
                        {             
                            <td>@row[col.ColumnName]</td>
                        }
                    </tr>
                }
            </tbody>
        </table>
    }
}

We will read CSV file, get data in DataTable and show DataTable in View.

5. To read the submitted CSV file:

		[HttpPost]
        [ValidateAntiForgeryToken]
         public ActionResult Upload(HttpPostedFileBase upload)
        {
            if (ModelState.IsValid)
            {

                if (upload != null && upload.ContentLength > 0)
                {                   

                    if (upload.FileName.EndsWith(".csv"))
                    {
                        Stream stream = upload.InputStream;
                        DataTable csvTable = new DataTable();
                        using (CsvReader csvReader =
                            new CsvReader(new StreamReader(stream), true))
                        {
                            csvTable.Load(csvReader);
                        }
                        return View(csvTable);
                    }
                    else
                    {
                        ModelState.AddModelError("File", "This file format is not supported");
                        return View();
                    }
                }
                else
                {
                    ModelState.AddModelError("File", "Please Upload Your file");
                }
            }
            return View();
        }

It is assumed the file will have column names in first row.

Output:

CSV Read

In this post, we implemented to read CSV file with CSVReader in ASP.NET MVC.

Hope It helps. Feel free to share your opinion in comment box.

10 comments

    1. Certain can be you will just have to parse the data in the Upload controller method and insert it into the database there.

  1. Hi there,

    How do we bind the result to the page.

    I’m getting similar errors

    Server Error in ‘/’ Application.
    The view ‘Upload’ or its master was not found or no view engine supports the searched locations. The following locations were searched:
    ~/Views/PbStatus/Upload.aspx
    ~/Views/PbStatus/Upload.ascx
    ~/Views/Shared/Upload.aspx
    ~/Views/Shared/Upload.ascx
    ~/Views/PbStatus/Upload.cshtml
    ~/Views/PbStatus/Upload.vbhtml
    ~/Views/Shared/Upload.cshtml
    ~/Views/Shared/Upload.vbhtml
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.InvalidOperationException: The view ‘Upload’ or its master was not found or no view engine supports the searched locations. The following locations were searched:
    ~/Views/PbStatus/Upload.aspx
    ~/Views/PbStatus/Upload.ascx
    ~/Views/Shared/Upload.aspx
    ~/Views/Shared/Upload.ascx
    ~/Views/PbStatus/Upload.cshtml
    ~/Views/PbStatus/Upload.vbhtml
    ~/Views/Shared/Upload.cshtml
    ~/Views/Shared/Upload.vbhtml

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    https://forums.asp.net/t/1551746.aspx
    https://www.codeproject.com/Questions/76008/ASP-NET-MVC-Views-location-Problem-The-view-Index

  2. this doesn’t work. when adding upload to the homecontroller and the view it returns a 404 error when navigating to home/upload

    edit: i was missing the first action(it works)

Leave a Reply

Your email address will not be published. Required fields are marked *