Home > Code > C# > Open an existing Excel file using C#.NET

Open an existing Excel file using C#.NET

by Narain Siddharth   on May 22, 2011   Category: C#   |  Views: 18107    |  Points: 25   |  Silver 


Below c# code shows how to open the existing excel file from particular folder.


using System;
using System.Text;
using System.IO;

protected void BtnOpen_Click(object sender, EventArgs e)
{
try
{
string XlsPath = Server.MapPath(@"~/Add_data/test.xlsx");
FileInfo fileDet = new System.IO.FileInfo(XlsPath);
Response.Clear();
Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(fileDet.Name));
Response.AddHeader("Content-Length", fileDet.Length.ToString());
Response.ContentType = "application/ms-excel";
Response.WriteFile(fileDet.FullName);
Response.End();
}
catch (Exception ex)
{
throw ex;
}
}






Post Code  |  Code Snippet Home

User Responses


  Re :Open an existing Excel file using C#.NET   
Posted by Raja
on 23/05/2011
Points : 5

This is what i'm looking... thank you.
  Re :Open an existing Excel file using C#.NET   
Posted by Akkineni2009
on 20/07/2011
Points : 5

This code helps. And i tried to use it in my application as i need to open the excel spreed sheet.

But when i use this code it is openiing the file but not displaying as excel spreed sheet.
it open as if we open the spread sheet into notepad or text pad.
Any help on what the Response.charset should be?
  Re :Open an existing Excel file using C#.NET   
Posted by Akkineni2009
on 20/07/2011
Points : 5

Actually, I removed the two lines for the code
Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.UTF8;

it is now working.

This is a great help
Thanks to Narain Siddharth

Submit feedback about this code snippet

Please sign in to post feedback

Latest Posts