CODEWITHSUNDEEP
file-upload.net-corefile-readwebapi
Sanam
Sanam

Reputation: 243

how to read excel file in memory (without saving it in disk) and return its content dotnet core

Im working on a webApi using dotnet core that takes the excel file from IFormFile and reads its content.Iam following the article https://levelup.gitconnected.com/reading-an-excel-file-using-an-asp-net-core-mvc-application-2693545577db which is doing the same thing except that the file here is present on the server and mine will be provided by user.

here is the code:

  public IActionResult Test(IFormFile file)
        {
           List<UserModel> users = new List<UserModel>();
            System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
            using (var stream = System.IO.File.Open(file.FileName, FileMode.Open, FileAccess.Read))
            {
                using (var reader = ExcelReaderFactory.CreateReader(stream))
                {    
                    while (reader.Read()) //Each row of the file
                    {
                        users.Add(new UserModel
                        {
                            Name = reader.GetValue(0).ToString(),
                            Email = reader.GetValue(1).ToString(),
                            Phone = reader.GetValue(2).ToString()
                        });
                    }
                }
            }
            return Ok(users);
        }
    }

When system.IO tries to open the file, it could not find the path as the path is not present. How it is possible to either get the file path (that would vary based on user selection of file)? are there any other ways to make it possible.

PS: I dont want to upload the file on the server first, then read it.

Upvotes: 4

Views: 12437

Answers (1)

Arakis
Arakis

Reputation: 889

You're using the file.FileName property, which refers to the file name the browser send. It's good to know, but not a real file on the server yet. You have to use the CopyTo(Stream) Method to access the data:

public IActionResult Test(IFormFile file)
{
    List<UserModel> users = new List<UserModel>();
    System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
    using (var stream = new MemoryStream())
    {
        file.CopyTo(stream);
        stream.Position = 0;
        using (var reader = ExcelReaderFactory.CreateReader(stream))
        {
            while (reader.Read()) //Each row of the file
            {
                users.Add(new UserModel{Name = reader.GetValue(0).ToString(), Email = reader.GetValue(1).ToString(), Phone = reader.GetValue(2).ToString()});
            }
        }
    }

    return Ok(users);
}

Reference

Upvotes: 10

Related Questions