Is it possible to read excel file in asp.net without uploading it to server?

Hi,

try this,

<asp:fileupload id="FileUpload1" runat="server" xmlns:asp="#unknown" />
<asp:button id="Button1" runat="server" text="Send File" onclick="Button1_Click" xmlns:asp="#unknown" />
<asp:gridview id="GridView1" runat="server" xmlns:asp="#unknown" />

// C# Code-Behind
protected void Button1_Click(object sender, EventArgs e) {
    // the ExcelDataReader takes a System.IO.Stream object
    var excelReader = new ExcelDataReader(FileUpload1.FileContent);
    FileUpload1.FileContent.Close();

    DataSet wb = excelReader.WorkbookData;
    // get the first worksheet of the workbook
    DataTable dt = excelReader.WorkbookData.Tables[0];

    GridView1.DataSource = dt.AsDataView();
    GridView1.DataBind();
}

Best Luck
Happy Coding:)

Put this code at Button Click


var excelReader = new ExcelDataReader(FileUpload1.FileContent);
FileUpload1.FileContent.Close();
DataSet wb = excelReader.WorkbookData;
DataTable dt = excelReader.WorkbookData.Tables[0];
GridView1.DataSource = dt.AsDataView();
GridView1.DataBind();