how create a excel file in c#

Question

I want to create a new excel file using C#

Dorothy Tincher · Answer

Hi, there are few ways you can achieve this: - with OLEDB connection in C#, here are some useful links: http://www.codeproject.com/Tips/705470/Read-and-Write-Excel-Documents-Using-OLEDB http://stackoverflow.com/questions/10637918/how-to-use-oledb-to-create-excel-database - with C# excel automation , this approach uses an Excel Interop dll which is basicly a .NET's wrapper of COM functions that MS Excel uses, also you have some sample codes in the above comments. - with OpenXML SDK , note that with this approach you can only create a newer XML based files (XLSX), also it has some learning curve, you will have to know the basics of this OpenXML format in order to properly work with it. - with some third party, for example I used this .NET Excel component in the past and I found it to be easy and intuitive , you can find a sample how to create an excel file with it here .

Alex Heig · Answer

Hello, if you haven't MS Office installed on your machine or you don't want to use it, you can try this 3rd party .NET library . It allows to work with .xls, .xlsx and .csv formats. Please look at this example: using System; using System.Collections.Generic; using System.Text; using Elerium.Excel; namespace HelloWorld { class Program { static void Main(string[] args) { //Create a new workbook. ExcelWorkbook Wbook = new ExcelWorkbook(); //Add new worksheet to workbook. Wbook.Worksheets.Add("Sheet1"); Wbook.Worksheets[0].Cells["A1"].Value = "Hello, world!"; //XLS Wbook.WriteXLS(@"..\..\..\FirstExcelFiles.xls"); //XLSX Wbook.WriteXLSX(@"..\..\..\FirstExcelFiles.xlsx"); //Open specified file in MS Excel. System.Diagnostics.Process.Start(@"..\..\..\FirstExcelFiles.xlsx"); } } }

Lacy Michelle · Answer

Use MS Office Excel to create an Excel: public class CreateExcelWorksheet { static void Main() { Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); if (xlApp == null) { Console.WriteLine("EXCEL could not be started. Check that your office installation and project references are correct."); return; } xlApp.Visible = true; Workbook wb = xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); Worksheet ws = (Worksheet)wb.Worksheets[1]; if (ws == null) { Console.WriteLine("Worksheet could not be created. Check that your office installation and project references are correct."); } // Select the Excel cells, in the range c1 to c7 in the worksheet. Range aRange = ws.get_Range("C1", "C7"); if (aRange == null) { Console.WriteLine("Could not get a range. Check to be sure you have the correct versions of the office DLLs."); } // Fill the cells in the C1 to C7 range of the worksheet with the number 6. Object[] args = new Object[1]; args[0] = 6; aRange.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, aRange, args); // Change the cells in the C1 to C7 range of the worksheet to the number 8. aRange.Value2 = 8; } } Use a third party library: Excel Library to create Excel file: static void Main(string[] args) { //Initialize a new Workboook object Workbook workbook = new Workbook(); //Get the first worksheet Worksheet sheet = workbook.Worksheets[0]; //Write string values in a cell sheet.Range["A3"].Text = "This Excel Document is Created by Spire.XLS for .NET"; //Save workbook to disk workbook.SaveToFile("Sample.xls"); try { System.Diagnostics.Process.Start(workbook.FileName); } catch { } } Hope it can help you!

venkata kumar · Answer

hi check fallowing code Excel.Application xlApp; // Excel.Workbook xlWorkBook; // Excel.Worksheet xlWorkSheet; // object misValue = System.Reflection.Missing.Value; // xlApp = new Excel.ApplicationClass(); // xlApp.Visible = true; // xlWorkBook = xlApp.Workbooks.Add(misValue); // xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); // int i = 0; // int j = 0; // for (i = 0; i // { // for (j = 0; j // { // DataGridViewCell cell = dataGridView1[j, i]; // xlWorkSheet.Cells[i + 1, j + 1] = cell.Value; // } // } // //xlWorkBook.SaveAs("csharp.net-informations.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); // xlWorkBook.Close(true, misValue, misValue); // xlApp.Quit(); // releaseObject(xlWorkSheet); // releaseObject(xlWorkBook); // releaseObject(xlApp); // //MessageBox.Show("Excel file created , you can find the file c:\csharp.net-informations.xls");

Rishikesh Kumar Singh · Answer

Go through the link given below.Here you will learn easily to create an excel file using c#. http://csharp.net-informations.com/excel/csharp-create-excel.htm mark it as an accepted answer if it helps you...otherwise let me know..!!

Vulpes · Answer

Check this MSDN link for details of how to create an Excel spreadsheet using COM interop: http://msdn.microsoft.com/en-gb/library/ms173186(v=vs.80).aspx Just add a reference to the latest Excel object library you have on your machine if it's not version 11.

Satyapriya Nayak · Answer

Please elaborate it more