Create Excel File with Header Name by using C# Coding
Hi Friends,
Today we see how to create excel file with header|column name's through C# coding.
In previous article I explained How to
- Upload excel file data into gridview through C# coding .
- Create Excel Sheet With Header Column through Coding
- Export Gridview data into excel sheet file through C# coding
Step - 1 :
Visual Studio | --> | File | --> | New | --> | Web Site | --> | Asp.NET Empty Web Site |
Project Name : CreateExcelFilewithHeader | ---> | Ok |
Step - 2 : Add Reference of Excel
- In Solution Explorer, right-click your project's name and then click Add Reference. The Add Reference dialog box appears.
- On the Assemblies page, select Microsoft.Office.Interop.Word in the Component Name list, and then hold down the CTRL key and select Microsoft.Office.Interop.Excel. If you do not see the assemblies, you may need to ensure they are installed and displayed (see How to: Install Office Primary Interop Assemblies)
- Click OK.
HTML Markup : Design Page
<div style="margin:20px 50px 20px 50px;"> <table style="border-collapse:collapse;"> <tr> <td style="padding:5px 10px 5px 10px; border:1px solid #dddddd;"><asp:TextBox ID="txtcreateexcel" runat="server"></asp:TextBox></td> <td style="padding:5px 10px 5px 10px; border:1px solid #dddddd;"> <asp:Button ID="BtnCreateExcel" Text="Create Excel" runat="server" onclick="BtnCreateExcel_Click" /></td> </tr> </table> </div>
C# Coding
C# Coding : Namespace
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.IO; using System.Text; using Microsoft.Office.Interop.Excel;
C# Coding : Button Click Event
i'm creating excel sheet when i click on Create Excel Sheet button programmatically.
public partial class _Default : System.Web.UI.Page { protected void BtnCreateExcel_Click(object sender, EventArgs e) { string filename = @"F:\ExcelLibrary\" + txtcreateexcel.Text + ".xls"; if (File.Exists(filename)) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('File Name Alread Exist...');", true); } Microsoft.Office.Interop.Excel._Application oApp; Microsoft.Office.Interop.Excel._Worksheet oSheet; Microsoft.Office.Interop.Excel._Workbook oBook; oApp = new Microsoft.Office.Interop.Excel.Application(); oBook = oApp.Workbooks.Add(); oSheet = (Microsoft.Office.Interop.Excel._Worksheet)oBook.Worksheets.get_Item(1); oSheet.Cells[1, 1] = "Name"; oSheet.Cells[1, 2] = "Date Of Birth"; oSheet.Cells[1, 3] = "Gender"; oSheet.Cells[1, 4] = "Email Address"; oSheet.Cells[1, 5] = "Phone Number"; Microsoft.Office.Interop.Excel.Range oRange = oSheet.Range["A1", "B3"]; if (oApp.Application.Sheets.Count < 1) { oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oBook.Worksheets.Add(); } else { oSheet = (Microsoft.Office.Interop.Excel.Worksheet)oApp.Worksheets[1]; } oBook.SaveAs(filename); oBook.Close(); oApp.Quit(); } }
0 Komentar untuk "Programmatically Create Excel File with Header Names through C# Coding"