Asp.net upload and read excel file

Create one button to upload the data to the server, one label to show you what file's data is showing in the grid view, and use one GridView control in which we will show our Excel sheet's data. View All. NET GridView. Sourabh Somani Updated date Jan 18, So my design aspx page is like; this you can just copy and paste the aspx page given below:.

Year - My ASP. Models; using System; using System. Generic; using System. IO; using System. Linq; using System. Web; using System. Split '. Combine directoryFullPathInput, fname ; file. Cells[row, 4]. You would require ExcelDataReader nuget package, I used 3. Latest versions of ExcelDataReader support netstandard2. NET Core 2. It also targets netstandard1. NET Core 1. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. Asked 3 years, 9 months ago. Active 11 months ago. Viewed 20k times.

Riz Riz 6, 18 18 gold badges 60 60 silver badges 99 99 bronze badges. Are you talking about this library: github. NET Core — Vlince. Add a comment. Active Oldest Votes. Net Core' By This Code. Net using C and VB. Download DocumentFormat. OpenXml and ClosedXml Libraries. You can download the libraries using the following download locations.

Download ClosedXml Library. You will need to import the following namespaces. Imports System. Imports ClosedXML. Then the instance of the first Sheet is determined and all the rows present in the Sheet are fetched. Finally a loop is executed over the fetched rows and a DataTable is populated which is then bound to the GridView. Worksheet 1 ;. Add cell. ToString ;.