How to Create Excel File in Asp.net C#

Question

1.00/5 (1 vote)

See more:

How to create Excel File in Web Application with C# using Microsoft.Office.Interop.Excel Template.
If anyone knows please post the Answer.

Posted 23-Apr-13 19:24pm

Murugesh0209

Add a Solution

Comments

vijay__p 24-Apr-13 1:34am

Have you checked this link? http://msdn.microsoft.com/en-us/library/ms173186(v=vs.80).aspx

NixonUposseen 30-Mar-17 1:32am

In short, you should reconsider that approach which you had in mind, the C# using Microsoft.Office.Interop.Excel Template, it's not safe to use it on server. Instead you should consider some alternative, like a C# library for Excel and create an Excel in C# with it instead. Also here is what you can do with Excel files in ASP.NET.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ManojDhobale · Answer 1 · 2013-04-23T21:45:00

Solution 1

Add Microsoft.Office.Interop.Word.dll

And please refer this
http://msdn.microsoft.com/en-IN/library/ms173186%28v=vs.80%29.aspx[^]

Posted 23-Apr-13 21:45pm

ManojDhobale

Comments

Murugesh0209 24-Apr-13 5:11am

Thank u for Answering..please can you tell for Writing/Reading Excel file with using the Microsoft.Office.Interop.Excel Template.

Gerxy · Answer 2 · 2013-04-23T22:04:00

Solution 2

There will be plenty of such discussion, blog articles on your topic, if you do a search. My link will do a little guidance, please check:
Stackoverflow discussion on your topics[^]
create excel in asp.net [^]
How to create Excel file dynamically in ASP.NET[^]
More Excel developing reference[^]

Best Regards

Posted 23-Apr-13 22:04pm

Gerxy

Comments

Murugesh0209 24-Apr-13 5:16am

Thank u for Answering Gerxy..Actually i solved that question. So please can you tell for Writing/Reading Excel file with using the Microsoft.Office.Interop.Excel Template.

[no name] 24-Apr-13 7:13am

That is a completely different question and you are likely to get the same answers. You need to actually try something for yourself.

crazie.coder · Answer 3 · 2013-04-24T03:08:00

Hi,
Try this..
it worked for me
but is not using Microsoft.Office.Interop.Excel

public partial class createxl : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//This code is completely working ...tested by juhi paunikar on dated 9th april,2013
}

protected void btnExport_Click(object sender, EventArgs e)
{
DataTable dt = CreateDataTable();
ExporttoExcel(dt);
}
private void ExporttoExcel(DataTable table)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.Write(@");

HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1250");
//sets font
HttpContext.Current.Response.Write("");
HttpContext.Current.Response.Write("

");
//sets the table border, cell spacing, border color, font of the text, background, foreground, font height
HttpContext.Current.Response.Write("");
//am getting my grid's column headers
//int columnscount = GridView_Result.Columns.Count;

//for (int j = 0; j < columnscount; j++)
//{ //write in new column
// HttpContext.Current.Response.Write("");
//}

for (int j = 0; j < table.Columns.Count; j++)
{ //write in new column
HttpContext.Current.Response.Write("");
}

HttpContext.Current.Response.Write("");
foreach (DataRow row in table.Rows)
{//write in new row
HttpContext.Current.Response.Write("");
for (int i = 0; i < table.Columns.Count; i++)
{
HttpContext.Current.Response.Write("");
}

HttpContext.Current.Response.Write("");
}
HttpContext.Current.Response.Write("

"); // //Get column headers and make it as bold in excel columns // HttpContext.Current.Response.Write(""); // HttpContext.Current.Response.Write(GridView_Result.Columns[j].HeaderText.ToString()); // HttpContext.Current.Response.Write(""); // HttpContext.Current.Response.Write("	"); //Get column headers and make it as bold in excel columns HttpContext.Current.Response.Write(""); HttpContext.Current.Response.Write(table.Columns[j].ColumnName.ToString()); HttpContext.Current.Response.Write(""); HttpContext.Current.Response.Write("
"); HttpContext.Current.Response.Write(row[i].ToString()); HttpContext.Current.Response.Write("

");
HttpContext.Current.Response.Write("

");
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}

private DataTable CreateDataTable()
{
DataTable companies = new DataTable("Companies");
DataColumn column;

column = new DataColumn("CompanyName");
companies.Columns.Add(column);

column = new DataColumn("CompanyCountry");
companies.Columns.Add(column);

column = new DataColumn("YearSales");
companies.Columns.Add(column);

column = new DataColumn("GrossProfit");
companies.Columns.Add(column);

column = new DataColumn("CreationDate");
companies.Columns.Add(column);

companies.Rows.Add("Mexican Tequila", "Mexico", "10875600", "4975200", "03/24/1995 2:35:00PM");
companies.Rows.Add("Canadian Food", "Canada", "308450870", "103476200", "08/12/1983");
companies.Rows.Add("French Wines", "France", "285309567", "81650000", "11/21/1990 17:40:00");
companies.Rows.Add("German Beer", "Germany", "285309567", "81650000", "11/21/1990 17:40:00");
companies.Rows.Add("Russian Vodka", "Russia", "285309567", "81650000", "11/21/1990 17:40:00");
companies.Rows.Add("Spanish Paella", "Spain", "285309567", "81650000", "11/21/1990 17:40:00");
companies.Rows.Add("Argentinian Beef", "Argentina", "285309567", "81650000", "11/21/1990 17:40:00");
companies.Rows.Add("Italian Pasta", "Italy", "285309567", "81650000", "11/21/1990 17:40:00");

return companies;
}
}
Let me know whether it helped you or not.

How to Create Excel File in Asp.net C#

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us