How to Create Excel file in ASP.NET C#

Using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dsAnalysis.Tables[1], "Partner_Details"); wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center; wb.Style.Font.Bold = true; string Bank_Statement_Analysis_Server_Path = ConfigurationManager.AppSettings["Bank_Statement_Analysis_path"].ToString(); string FileName = Server.MapPath(Bank_Statement_Analysis_Server_Path) + "Bank_Statement_" + dsAnalysis.Tables[1].Rows[0]["ENTITY_NAME"] + "_" + RefrenceID + ".xlsx"; wb.SaveAs(FileName); Response.Clear(); Response.ContentType = @"application\octet-stream"; System.IO.FileInfo file = new System.IO.FileInfo(FileName); Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name); Response.AddHeader("Content-Length", file.Length.ToString()); Response.ContentType = "application/octet-stream"; Response.WriteFile(file.FullName); Response.Flush(); }

I trying your DCOM Config" steps for resolve "Exception from HRESULT: 0x800A03EC - Excel, .Net, SQL and Windows Server" but issue not resolve.

sir can you provide code for creating excel file in window store (C#, Xaml)

I do not see Excel in DCOM config. what do I do? Thanks. Tina

hi, i have used 'This User' and added a account, it seems somethings wrong, i'm not able to download files. Am i missing something ? i cannot user interactive user as somebody will have to be connected to the server in order to launch the ms excel on the server, using this user is the only option. Please help me out

Nice post. However this requires Excel to be installed in the server.

How to remove a comment from the cell.

Sir, Can i do fill color in particular cell, please advice, thanks

to avoid the errors you should use .NET Excel applications like Aspose.Cells for .NET it also uses c#, .net, vb.net to create excel file and you don't have to do the coding it will do everything for you. Here is the link of the API: http://www.aspose.com/.net/excel-component.aspx

Indeed a very helpful post. I have a query and a requirement too, if you can provide me with some suggesstion. This article will work great for both cases as specified, but when we try to implement either of the solution forvery huge data, will not be very time consuming? as we are wrting data cell by cell. Also problem will arise if we have to implement a formatting change, say changing cell color based on some criteria? What would you suggest in such case? Regards, Mudassar Software Specialist EntechUSB Pvt. Ltd.

Hi, I am getting error when use this code.I think you have used using (OpenXmlDataDataContext db = new OpenXmlDataDataContext()) in the section option(Microsoft.Office.Interop.Excel). can you please suggest me what should i do. Thanks, Sadheesh

with GemBox.Spreadsheet component (http://www.gemboxsoftware.com/spreadsheet/overview). Take a look here how easy it is to create Excel file from DataTable in ASP.NET application: http://www.gemboxsoftware.com/support/articles/asp-net-excel.

Hi Jayendra, First of all thanks for this article.. It will be help me a lot. Now I had added reference Microsoft Excel 14.0 Object Library from .NET COM and not found 12.0. So in code I am not able to get class OpenXmlDataDataContext that you had written in GetRecoredForExcelfile(). And I am using VS .net 2005 and framework 2.0 and My main requirement is I want to create .xlsx file using datatable and in this excel file I can save more than 1,00,000 records. So "Microsoft.Office.Interop.Excel" is work for this?

thank you, but i don't know add ExcelPackage.dll ExcelPackage.pdb ExcelPackageXmlDocumentationFile.xml GacReg.bat can you help me steps add in solution? thanh you!