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:
1132
|
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;
}
}
|
Like this code? Bookmark and Share:
|
|
|
|
This is what i'm looking... thank you.
|
|
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?
|
|
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
|
|
|
|
|
|
|